GET https://tkgstage.com/explorer/asset/10542

Query Metrics

13 Database Queries
10 Different statements
32.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.ipfs_url AS ipfs_url_2, t0.price AS price_3, t0.is_minted AS is_minted_4, t0.signature AS signature_5, t0.is_confirmed AS is_confirmed_6, t0.script_mint AS script_mint_7, t0.nft_contract_id AS nft_contract_id_8, t0.nft_metadata_id AS nft_metadata_id_9, t0.theta_wallet_id AS theta_wallet_id_10, t0.crate_action_log_id AS crate_action_log_id_11, t0.parent_id AS parent_id_12 FROM nft_hub t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "10542"
]
2 0.77 ms
SELECT t0.id AS id_1, t0.block_number AS block_number_2, t0.from_address AS from_address_3, t0.to_address AS to_address_4, t0.timestamp AS timestamp_5, t0.nft_hub_id AS nft_hub_id_6 FROM nft_transfer t0 WHERE t0.nft_hub_id = ? ORDER BY t0.id DESC, t0.timestamp DESC LIMIT 10
Parameters:
[
  10542
]
3 0.49 ms
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.price AS price_3, t0.is_sold AS is_sold_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.buyer_id AS buyer_id_14, t0.seller_id AS seller_id_15, t0.nft_hub_id AS nft_hub_id_16 FROM market_item t0 WHERE t0.nft_hub_id = ? AND t0.is_sold = ? ORDER BY t0.updated_at DESC LIMIT 10
Parameters:
[
  10542
  1
]
4 0.99 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.creator AS creator_3, t0.name AS name_4, t0.description AS description_5, t0.image_url AS image_url_6, t0.wear AS wear_7, t0.score AS score_8, t0.grade AS grade_9, t0.mint AS mint_10, t0.stat_square AS stat_square_11, t0.stat_circle AS stat_circle_12, t0.stat_diamond AS stat_diamond_13, t0.stat_triangle AS stat_triangle_14, t0.stat_rectangle AS stat_rectangle_15, t0.stat_star AS stat_star_16, t0.stat_heart AS stat_heart_17, t0.stat_octagon AS stat_octagon_18, t0.weight AS weight_19, t0.nft_collection_id AS nft_collection_id_20, t21.id AS id_22, t21.name AS name_23, t21.series AS series_24, t21.image_url AS image_url_25, t21.created_date AS created_date_26, t21.background_folder AS background_folder_27, t21.border_folder AS border_folder_28, t0.template_id AS template_id_29, t30.id AS id_31, t30.is_catchable AS is_catchable_32, t30.name AS name_33, t30.description AS description_34, t30.image_url AS image_url_35, t30.tier AS tier_36, t30.min_stat AS min_stat_37, t30.max_stat AS max_stat_38, t30.min_weight AS min_weight_39, t30.max_weight AS max_weight_40, t30.aux_data AS aux_data_41, t30.buy_price AS buy_price_42, t30.shop_inventory AS shop_inventory_43, t30.release_at AS release_at_44, t30.max_editions AS max_editions_45, t30.lootable AS lootable_46, t30.genus_id AS genus_id_47, t30.category_id AS category_id_48, t30.recipe_id AS recipe_id_49, t30.nft_game_id AS nft_game_id_50, t30.non_nft_game_id AS non_nft_game_id_51, t52.id AS id_53, t52.ipfs_url AS ipfs_url_54, t52.price AS price_55, t52.is_minted AS is_minted_56, t52.signature AS signature_57, t52.is_confirmed AS is_confirmed_58, t52.script_mint AS script_mint_59, t52.nft_contract_id AS nft_contract_id_60, t52.nft_metadata_id AS nft_metadata_id_61, t52.theta_wallet_id AS theta_wallet_id_62, t52.crate_action_log_id AS crate_action_log_id_63, t52.parent_id AS parent_id_64, t0.nft_metadata_quest_id AS nft_metadata_quest_id_65, t66.id AS id_67, t66.progress AS progress_68, t66.goal AS goal_69, t66.stat_square_mod AS stat_square_mod_70, t66.stat_circle_mod AS stat_circle_mod_71, t66.stat_diamond_mod AS stat_diamond_mod_72, t66.stat_triangle_mod AS stat_triangle_mod_73, t66.stat_rectangle_mod AS stat_rectangle_mod_74, t66.stat_star_mod AS stat_star_mod_75, t66.stat_heart_mod AS stat_heart_mod_76, t66.stat_octagon_mod AS stat_octagon_mod_77, t66.quest_id AS quest_id_78, t0.school_of_magic_id AS school_of_magic_id_79 FROM nft_metadata t0 INNER JOIN nft_collection t21 ON t0.nft_collection_id = t21.id INNER JOIN template t30 ON t0.template_id = t30.id LEFT JOIN nft_hub t52 ON t52.nft_metadata_id = t0.id LEFT JOIN nft_metadata_quest t66 ON t0.nft_metadata_quest_id = t66.id WHERE t0.id = ?
Parameters:
[
  10542
]
5 8.09 ms
SELECT count(n0_.id) AS sclr_0 FROM nft_metadata n0_ LEFT JOIN nft_collection n1_ ON (n0_.nft_collection_id = n1_.id) INNER JOIN nft_hub n2_ ON n0_.id = n2_.nft_metadata_id WHERE n0_.template_id = ? AND n1_.id = ?
Parameters:
[
  174
  5
]
6 18.43 ms
SELECT MAX(n0_.stat_star) AS sclr_0, MIN(n0_.stat_star) AS sclr_1, MAX(n0_.stat_rectangle) AS sclr_2, MIN(n0_.stat_rectangle) AS sclr_3, MAX(n0_.stat_circle) AS sclr_4, MIN(n0_.stat_circle) AS sclr_5, MAX(n0_.score) AS sclr_6, MIN(n0_.score) AS sclr_7, MAX(n0_.stat_square) AS sclr_8, MIN(n0_.stat_square) AS sclr_9, MAX(n0_.stat_diamond) AS sclr_10, MIN(n0_.stat_diamond) AS sclr_11, MAX(n0_.stat_triangle) AS sclr_12, MIN(n0_.stat_triangle) AS sclr_13, MAX(n0_.stat_heart) AS sclr_14, MIN(n0_.stat_heart) AS sclr_15, MAX(n0_.stat_octagon) AS sclr_16, MIN(n0_.stat_octagon) AS sclr_17 FROM nft_metadata n0_ INNER JOIN template t1_ ON n0_.template_id = t1_.id INNER JOIN nft_hub n2_ ON n0_.id = n2_.nft_metadata_id WHERE t1_.id = ?
Parameters:
[
  174
]
7 0.73 ms
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.price AS price_3, t0.is_sold AS is_sold_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.buyer_id AS buyer_id_14, t0.seller_id AS seller_id_15, t0.nft_hub_id AS nft_hub_id_16 FROM market_item t0 WHERE (t0.is_sold = ? AND t0.nft_hub_id = ?) ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  0
  10542
]
8 0.71 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:
[
  150
]
9 0.52 ms
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.price AS price_3, t0.is_sold AS is_sold_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.buyer_id AS buyer_id_14, t0.seller_id AS seller_id_15, t0.nft_hub_id AS nft_hub_id_16 FROM market_item t0 WHERE (t0.is_sold = ? AND t0.nft_hub_id = ?) ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  0
  10542
]
10 0.38 ms
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.price AS price_3, t0.is_sold AS is_sold_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.buyer_id AS buyer_id_14, t0.seller_id AS seller_id_15, t0.nft_hub_id AS nft_hub_id_16 FROM market_item t0 WHERE (t0.is_sold = ? AND t0.nft_hub_id = ?) ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  0
  10542
]
11 0.36 ms
SELECT t0.id AS id_1, t0.received_at AS received_at_2, t0.received_tx AS received_tx_3, t0.initiate_open_at AS initiate_open_at_4, t0.is_opened AS is_opened_5, t0.opened_tx AS opened_tx_6, t0.received_by_id AS received_by_id_7, t0.opened_by_id AS opened_by_id_8, t9.id AS id_10, t9.ipfs_url AS ipfs_url_11, t9.price AS price_12, t9.is_minted AS is_minted_13, t9.signature AS signature_14, t9.is_confirmed AS is_confirmed_15, t9.script_mint AS script_mint_16, t9.nft_contract_id AS nft_contract_id_17, t9.nft_metadata_id AS nft_metadata_id_18, t9.theta_wallet_id AS theta_wallet_id_19, t9.crate_action_log_id AS crate_action_log_id_20, t9.parent_id AS parent_id_21 FROM crate_action_log t0 LEFT JOIN nft_hub t9 ON t9.crate_action_log_id = t0.id WHERE t0.id = ?
Parameters:
[
  3190
]
12 0.33 ms
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.price AS price_3, t0.is_sold AS is_sold_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.buyer_id AS buyer_id_14, t0.seller_id AS seller_id_15, t0.nft_hub_id AS nft_hub_id_16 FROM market_item t0 WHERE (t0.is_sold = ? AND t0.nft_hub_id = ?) ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  0
  10542
]
13 0.44 ms
SELECT t0.id AS id_1, t0.offer_id AS offer_id_2, t0.price AS price_3, t0.is_accepted AS is_accepted_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.nft_hub_id AS nft_hub_id_14, t0.bidder_id AS bidder_id_15, t0.seller_id AS seller_id_16 FROM market_offer t0 WHERE (t0.is_accepted = ? AND t0.nft_hub_id = ?) ORDER BY t0.created_at DESC LIMIT 20
Parameters:
[
  0
  10542
]

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\NftHub No errors.
App\Entity\NftContract No errors.
App\Entity\NftMetadata No errors.
App\Entity\ThetaWallet No errors.
App\Entity\CrateActionLog No errors.
App\Entity\NftTransfer No errors.
App\Entity\MarketItem No errors.
App\Entity\MarketOffer No errors.
App\Entity\NftCollection No errors.
App\Entity\Template No errors.
App\Entity\TemplateGenus No errors.
App\Entity\TemplateCategory No errors.
App\Entity\Recipe No errors.
App\Entity\Game No errors.
App\Entity\NftMetadataQuest No errors.
App\Entity\Quest No errors.
App\Entity\SchoolOfMagic No errors.
App\Entity\Zone No errors.
App\Entity\TemplateMaterialProbability No errors.
App\Entity\User No errors.
App\Entity\CatchableQueue No errors.
App\Entity\ActProgression No errors.
App\Entity\WithdrawalLog No errors.