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

Response
200 OK
IP
3.147.76.183
Profiled on
Token
2c95ce

Query Metrics

19 Database Queries
8 Different statements
21.76 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
4.84 ms
(22.24%) 		1 
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
4.76 ms
(21.87%) 		1 
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
4.75 ms
(21.80%) 		9 
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
3.00 ms
(13.81%) 		4 
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
2.19 ms
(10.05%) 		1 
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
0.82 ms
(3.77%) 		1 
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
0.79 ms
(3.61%) 		1 
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
0.62 ms
(2.85%) 		1 
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

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.