Symfony Profiler

Query Metrics

19 Database Queries

8 Different statements

24.46 ms Query time

0 Invalid entities

Queries


SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_category t0_ WHERE t0_.id IN (1, 2, 3, 4, 5, 6, 7) ORDER BY t0_.id ASC
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.series AS series_2, n0_.image_url AS image_url_3, n0_.created_date AS created_date_4, n0_.background_folder AS background_folder_5, n0_.border_folder AS border_folder_6 FROM nft_collection n0_
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_genus t0_ WHERE t0_.id IN (1, 4) ORDER BY t0_.name ASC
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 ORDER BY m0_.created_at DESC) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_5 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0) dctrn_result_inner ORDER BY created_at_5 DESC) dctrn_result LIMIT 12
SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116, m0_.nft_contract_id AS nft_contract_id_117, m0_.market_contract_id AS market_contract_id_118, m0_.buyer_id AS buyer_id_119, m0_.seller_id AS seller_id_120, m0_.nft_hub_id AS nft_hub_id_121, n1_.nft_contract_id AS nft_contract_id_122, n1_.nft_metadata_id AS nft_metadata_id_123, n1_.theta_wallet_id AS theta_wallet_id_124, n1_.crate_action_log_id AS crate_action_log_id_125, n1_.parent_id AS parent_id_126, m2_.nft_contract_id AS nft_contract_id_127, m2_.market_contract_id AS market_contract_id_128, m2_.nft_hub_id AS nft_hub_id_129, m2_.bidder_id AS bidder_id_130, m2_.seller_id AS seller_id_131, n3_.nft_collection_id AS nft_collection_id_132, n3_.template_id AS template_id_133, n3_.nft_metadata_quest_id AS nft_metadata_quest_id_134, n3_.school_of_magic_id AS school_of_magic_id_135, m4_.nft_contract_id AS nft_contract_id_136, m4_.market_contract_id AS market_contract_id_137, m4_.buyer_id AS buyer_id_138, m4_.seller_id AS seller_id_139, m4_.nft_hub_id AS nft_hub_id_140, n5_.quest_id AS quest_id_141, t6_.genus_id AS genus_id_142, t6_.category_id AS category_id_143, t6_.recipe_id AS recipe_id_144, t6_.nft_game_id AS nft_game_id_145, t6_.non_nft_game_id AS non_nft_game_id_146, u11_.active_wallet_id AS active_wallet_id_147, u11_.catchable_queue_id AS catchable_queue_id_148, u11_.act_progression_id AS act_progression_id_149, u11_.theta_drop_wallet_id AS theta_drop_wallet_id_150 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	0.68 ms	SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_category t0_ WHERE t0_.id IN (1, 2, 3, 4, 5, 6, 7) ORDER BY t0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_category t0_ WHERE t0_.id IN (1, 2, 3, 4, 5, 6, 7) ORDER BY t0_.id ASC SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_category t0_ WHERE t0_.id IN (1, 2, 3, 4, 5, 6, 7) ORDER BY t0_.id ASC;
2	0.63 ms	SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.series AS series_2, n0_.image_url AS image_url_3, n0_.created_date AS created_date_4, n0_.background_folder AS background_folder_5, n0_.border_folder AS border_folder_6 FROM nft_collection n0_ Parameters: [] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.series AS series_2, n0_.image_url AS image_url_3, n0_.created_date AS created_date_4, n0_.background_folder AS background_folder_5, n0_.border_folder AS border_folder_6 FROM nft_collection n0_ SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.series AS series_2, n0_.image_url AS image_url_3, n0_.created_date AS created_date_4, n0_.background_folder AS background_folder_5, n0_.border_folder AS border_folder_6 FROM nft_collection n0_;
3	0.60 ms	SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_genus t0_ WHERE t0_.id IN (1, 4) ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_genus t0_ WHERE t0_.id IN (1, 4) ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.name AS name_1 FROM template_genus t0_ WHERE t0_.id IN (1, 4) ORDER BY t0_.name ASC;
4	4.78 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 ORDER BY m0_.created_at DESC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 ORDER BY m0_.created_at DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 ORDER BY m0_.created_at DESC) dctrn_result) dctrn_table;
5	5.90 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_5 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0) dctrn_result_inner ORDER BY created_at_5 DESC) dctrn_result LIMIT 12 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, created_at_5 FROM ( SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 ) dctrn_result_inner ORDER BY created_at_5 DESC ) dctrn_result LIMIT 12 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_5 FROM (SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0) dctrn_result_inner ORDER BY created_at_5 DESC) dctrn_result LIMIT 12;
6	2.27 ms	SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116, m0_.nft_contract_id AS nft_contract_id_117, m0_.market_contract_id AS market_contract_id_118, m0_.buyer_id AS buyer_id_119, m0_.seller_id AS seller_id_120, m0_.nft_hub_id AS nft_hub_id_121, n1_.nft_contract_id AS nft_contract_id_122, n1_.nft_metadata_id AS nft_metadata_id_123, n1_.theta_wallet_id AS theta_wallet_id_124, n1_.crate_action_log_id AS crate_action_log_id_125, n1_.parent_id AS parent_id_126, m2_.nft_contract_id AS nft_contract_id_127, m2_.market_contract_id AS market_contract_id_128, m2_.nft_hub_id AS nft_hub_id_129, m2_.bidder_id AS bidder_id_130, m2_.seller_id AS seller_id_131, n3_.nft_collection_id AS nft_collection_id_132, n3_.template_id AS template_id_133, n3_.nft_metadata_quest_id AS nft_metadata_quest_id_134, n3_.school_of_magic_id AS school_of_magic_id_135, m4_.nft_contract_id AS nft_contract_id_136, m4_.market_contract_id AS market_contract_id_137, m4_.buyer_id AS buyer_id_138, m4_.seller_id AS seller_id_139, m4_.nft_hub_id AS nft_hub_id_140, n5_.quest_id AS quest_id_141, t6_.genus_id AS genus_id_142, t6_.category_id AS category_id_143, t6_.recipe_id AS recipe_id_144, t6_.nft_game_id AS nft_game_id_145, t6_.non_nft_game_id AS non_nft_game_id_146, u11_.active_wallet_id AS active_wallet_id_147, u11_.catchable_queue_id AS catchable_queue_id_148, u11_.act_progression_id AS act_progression_id_149, u11_.theta_drop_wallet_id AS theta_drop_wallet_id_150 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.created_at DESC Parameters: [`520 519 518 517 516 515 514 512 510 505 504 502`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116, m0_.nft_contract_id AS nft_contract_id_117, m0_.market_contract_id AS market_contract_id_118, m0_.buyer_id AS buyer_id_119, m0_.seller_id AS seller_id_120, m0_.nft_hub_id AS nft_hub_id_121, n1_.nft_contract_id AS nft_contract_id_122, n1_.nft_metadata_id AS nft_metadata_id_123, n1_.theta_wallet_id AS theta_wallet_id_124, n1_.crate_action_log_id AS crate_action_log_id_125, n1_.parent_id AS parent_id_126, m2_.nft_contract_id AS nft_contract_id_127, m2_.market_contract_id AS market_contract_id_128, m2_.nft_hub_id AS nft_hub_id_129, m2_.bidder_id AS bidder_id_130, m2_.seller_id AS seller_id_131, n3_.nft_collection_id AS nft_collection_id_132, n3_.template_id AS template_id_133, n3_.nft_metadata_quest_id AS nft_metadata_quest_id_134, n3_.school_of_magic_id AS school_of_magic_id_135, m4_.nft_contract_id AS nft_contract_id_136, m4_.market_contract_id AS market_contract_id_137, m4_.buyer_id AS buyer_id_138, m4_.seller_id AS seller_id_139, m4_.nft_hub_id AS nft_hub_id_140, n5_.quest_id AS quest_id_141, t6_.genus_id AS genus_id_142, t6_.category_id AS category_id_143, t6_.recipe_id AS recipe_id_144, t6_.nft_game_id AS nft_game_id_145, t6_.non_nft_game_id AS non_nft_game_id_146, u11_.active_wallet_id AS active_wallet_id_147, u11_.catchable_queue_id AS catchable_queue_id_148, u11_.act_progression_id AS act_progression_id_149, u11_.theta_drop_wallet_id AS theta_drop_wallet_id_150 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.created_at DESC SELECT m0_.id AS id_0, m0_.item_id AS item_id_1, m0_.price AS price_2, m0_.is_sold AS is_sold_3, m0_.is_canceled AS is_canceled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.notification_read AS notification_read_7, m0_.seller_payout AS seller_payout_8, m0_.fee AS fee_9, m0_.tx AS tx_10, n1_.id AS id_11, n1_.ipfs_url AS ipfs_url_12, n1_.price AS price_13, n1_.is_minted AS is_minted_14, n1_.signature AS signature_15, n1_.is_confirmed AS is_confirmed_16, n1_.script_mint AS script_mint_17, m2_.id AS id_18, m2_.offer_id AS offer_id_19, m2_.price AS price_20, m2_.is_accepted AS is_accepted_21, m2_.is_canceled AS is_canceled_22, m2_.created_at AS created_at_23, m2_.updated_at AS updated_at_24, m2_.notification_read AS notification_read_25, m2_.seller_payout AS seller_payout_26, m2_.fee AS fee_27, m2_.tx AS tx_28, n3_.id AS id_29, n3_.created_at AS created_at_30, n3_.creator AS creator_31, n3_.name AS name_32, n3_.description AS description_33, n3_.image_url AS image_url_34, n3_.wear AS wear_35, n3_.score AS score_36, n3_.grade AS grade_37, n3_.mint AS mint_38, n3_.stat_square AS stat_square_39, n3_.stat_circle AS stat_circle_40, n3_.stat_diamond AS stat_diamond_41, n3_.stat_triangle AS stat_triangle_42, n3_.stat_rectangle AS stat_rectangle_43, n3_.stat_star AS stat_star_44, n3_.stat_heart AS stat_heart_45, n3_.stat_octagon AS stat_octagon_46, n3_.weight AS weight_47, m4_.id AS id_48, m4_.item_id AS item_id_49, m4_.price AS price_50, m4_.is_sold AS is_sold_51, m4_.is_canceled AS is_canceled_52, m4_.created_at AS created_at_53, m4_.updated_at AS updated_at_54, m4_.notification_read AS notification_read_55, m4_.seller_payout AS seller_payout_56, m4_.fee AS fee_57, m4_.tx AS tx_58, n5_.id AS id_59, n5_.progress AS progress_60, n5_.goal AS goal_61, n5_.stat_square_mod AS stat_square_mod_62, n5_.stat_circle_mod AS stat_circle_mod_63, n5_.stat_diamond_mod AS stat_diamond_mod_64, n5_.stat_triangle_mod AS stat_triangle_mod_65, n5_.stat_rectangle_mod AS stat_rectangle_mod_66, n5_.stat_star_mod AS stat_star_mod_67, n5_.stat_heart_mod AS stat_heart_mod_68, n5_.stat_octagon_mod AS stat_octagon_mod_69, t6_.id AS id_70, t6_.is_catchable AS is_catchable_71, t6_.name AS name_72, t6_.description AS description_73, t6_.image_url AS image_url_74, t6_.tier AS tier_75, t6_.min_stat AS min_stat_76, t6_.max_stat AS max_stat_77, t6_.min_weight AS min_weight_78, t6_.max_weight AS max_weight_79, t6_.aux_data AS aux_data_80, t6_.buy_price AS buy_price_81, t6_.shop_inventory AS shop_inventory_82, t6_.release_at AS release_at_83, t6_.max_editions AS max_editions_84, t6_.lootable AS lootable_85, t7_.id AS id_86, t7_.name AS name_87, t8_.id AS id_88, t8_.name AS name_89, n9_.id AS id_90, n9_.name AS name_91, n9_.series AS series_92, n9_.image_url AS image_url_93, n9_.created_date AS created_date_94, n9_.background_folder AS background_folder_95, n9_.border_folder AS border_folder_96, t10_.id AS id_97, t10_.address AS address_98, t10_.is_approved_for_all_market AS is_approved_for_all_market_99, t10_.is_approved_for_all_market2 AS is_approved_for_all_market2_100, t10_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_101, u11_.id AS id_102, u11_.email AS email_103, u11_.roles AS roles_104, u11_.password AS password_105, u11_.game_token AS game_token_106, u11_.wallet AS wallet_107, u11_.google_id AS google_id_108, u11_.username AS username_109, u11_.wallet_extension AS wallet_extension_110, u11_.config AS config_111, u11_.last_recipe_hint AS last_recipe_hint_112, u11_.experience AS experience_113, u11_.shadow_ban_until AS shadow_ban_until_114, u11_.shinies AS shinies_115, u11_.game_token2 AS game_token2_116, m0_.nft_contract_id AS nft_contract_id_117, m0_.market_contract_id AS market_contract_id_118, m0_.buyer_id AS buyer_id_119, m0_.seller_id AS seller_id_120, m0_.nft_hub_id AS nft_hub_id_121, n1_.nft_contract_id AS nft_contract_id_122, n1_.nft_metadata_id AS nft_metadata_id_123, n1_.theta_wallet_id AS theta_wallet_id_124, n1_.crate_action_log_id AS crate_action_log_id_125, n1_.parent_id AS parent_id_126, m2_.nft_contract_id AS nft_contract_id_127, m2_.market_contract_id AS market_contract_id_128, m2_.nft_hub_id AS nft_hub_id_129, m2_.bidder_id AS bidder_id_130, m2_.seller_id AS seller_id_131, n3_.nft_collection_id AS nft_collection_id_132, n3_.template_id AS template_id_133, n3_.nft_metadata_quest_id AS nft_metadata_quest_id_134, n3_.school_of_magic_id AS school_of_magic_id_135, m4_.nft_contract_id AS nft_contract_id_136, m4_.market_contract_id AS market_contract_id_137, m4_.buyer_id AS buyer_id_138, m4_.seller_id AS seller_id_139, m4_.nft_hub_id AS nft_hub_id_140, n5_.quest_id AS quest_id_141, t6_.genus_id AS genus_id_142, t6_.category_id AS category_id_143, t6_.recipe_id AS recipe_id_144, t6_.nft_game_id AS nft_game_id_145, t6_.non_nft_game_id AS non_nft_game_id_146, u11_.active_wallet_id AS active_wallet_id_147, u11_.catchable_queue_id AS catchable_queue_id_148, u11_.act_progression_id AS act_progression_id_149, u11_.theta_drop_wallet_id AS theta_drop_wallet_id_150 FROM market_item m0_ LEFT JOIN nft_hub n1_ ON m0_.nft_hub_id = n1_.id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN nft_metadata n3_ ON n1_.nft_metadata_id = n3_.id LEFT JOIN market_item m4_ ON n1_.id = m4_.nft_hub_id LEFT JOIN nft_metadata_quest n5_ ON n3_.nft_metadata_quest_id = n5_.id LEFT JOIN template t6_ ON n3_.template_id = t6_.id LEFT JOIN template_category t7_ ON t6_.category_id = t7_.id LEFT JOIN template_genus t8_ ON t6_.genus_id = t8_.id LEFT JOIN nft_collection n9_ ON n3_.nft_collection_id = n9_.id LEFT JOIN theta_wallet t10_ ON n1_.theta_wallet_id = t10_.id LEFT JOIN user u11_ ON t10_.id = u11_.active_wallet_id WHERE m0_.is_sold = 0 AND m0_.id IN (520, 519, 518, 517, 516, 515, 514, 512, 510, 505, 504, 502) ORDER BY m0_.created_at DESC;
7	0.67 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = 3;
8	0.87 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`87`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 87;
9	0.73 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = 2;
10	0.89 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 25;
11	0.64 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = 4;
12	0.56 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = 1;
13	0.74 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`116`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 116;
14	0.73 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`226`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 226;
15	0.73 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`214`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 214;
16	0.65 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 2;
17	1.01 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`217`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 217;
18	0.68 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`161`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 161;
19	0.68 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? Parameters: [`155`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = 155;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\NftCollection	No errors.
App\Entity\TemplateGenus	No errors.
App\Entity\TemplateCategory	No errors.
App\Entity\Template	No errors.
App\Entity\MarketItem	No errors.
App\Entity\NftMetadata	No errors.
App\Entity\NftHub	No errors.
App\Entity\MarketOffer	No errors.
App\Entity\NftMetadataQuest	No errors.
App\Entity\ThetaWallet	No errors.
App\Entity\User	No errors.
App\Entity\NftContract	No errors.
App\Entity\CrateActionLog	No errors.
App\Entity\SchoolOfMagic	No errors.
App\Entity\Quest	No errors.
App\Entity\Recipe	No errors.
App\Entity\Game	No errors.
App\Entity\CatchableQueue	No errors.
App\Entity\ActProgression	No errors.
App\Entity\NftTransfer	No errors.
App\Entity\Zone	No errors.
App\Entity\TemplateMaterialProbability	No errors.
App\Entity\WithdrawalLog	No errors.
App\Entity\InventoryEquipment	No errors.
App\Entity\InventoryCatchable	No errors.
App\Entity\UserGear	No errors.
App\Entity\UserRecord	No errors.
App\Entity\InventoryMaterial	No errors.
App\Entity\SalvageQueue	No errors.
App\Entity\ShopItemPurchases	No errors.

Symfony Profiler

GET https://tkgstage.com/index.php/marketplace?state=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping