GET https://tkgstage.com/index.php/explorer/collection/5/template/164

Response
200 OK
IP
3.141.31.178
Profiled on
Token
4d042b

Query Metrics

13 Database Queries
6 Different statements
19.96 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.82 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.series AS series_3, t0.image_url AS image_url_4, t0.created_date AS created_date_5, t0.background_folder AS background_folder_6, t0.border_folder AS border_folder_7 FROM nft_collection t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "5"
]
View formatted query    View runnable query    Explain query
2 0.74 ms 
SELECT t0.id AS id_1, t0.is_catchable AS is_catchable_2, t0.name AS name_3, t0.description AS description_4, t0.image_url AS image_url_5, t0.tier AS tier_6, t0.min_stat AS min_stat_7, t0.max_stat AS max_stat_8, t0.min_weight AS min_weight_9, t0.max_weight AS max_weight_10, t0.aux_data AS aux_data_11, t0.buy_price AS buy_price_12, t0.shop_inventory AS shop_inventory_13, t0.release_at AS release_at_14, t0.max_editions AS max_editions_15, t0.lootable AS lootable_16, t0.genus_id AS genus_id_17, t0.category_id AS category_id_18, t0.recipe_id AS recipe_id_19, t0.nft_game_id AS nft_game_id_20, t0.non_nft_game_id AS non_nft_game_id_21 FROM template t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "164"
]
View formatted query    View runnable query    Explain query
3 8.31 ms 
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.creator AS creator_2, n0_.name AS name_3, n0_.description AS description_4, n0_.image_url AS image_url_5, n0_.wear AS wear_6, n0_.score AS score_7, n0_.grade AS grade_8, n0_.mint AS mint_9, n0_.stat_square AS stat_square_10, n0_.stat_circle AS stat_circle_11, n0_.stat_diamond AS stat_diamond_12, n0_.stat_triangle AS stat_triangle_13, n0_.stat_rectangle AS stat_rectangle_14, n0_.stat_star AS stat_star_15, n0_.stat_heart AS stat_heart_16, n0_.stat_octagon AS stat_octagon_17, n0_.weight AS weight_18, t1_.id AS id_19, t1_.is_catchable AS is_catchable_20, t1_.name AS name_21, t1_.description AS description_22, t1_.image_url AS image_url_23, t1_.tier AS tier_24, t1_.min_stat AS min_stat_25, t1_.max_stat AS max_stat_26, t1_.min_weight AS min_weight_27, t1_.max_weight AS max_weight_28, t1_.aux_data AS aux_data_29, t1_.buy_price AS buy_price_30, t1_.shop_inventory AS shop_inventory_31, t1_.release_at AS release_at_32, t1_.max_editions AS max_editions_33, t1_.lootable AS lootable_34, n2_.id AS id_35, n2_.ipfs_url AS ipfs_url_36, n2_.price AS price_37, n2_.is_minted AS is_minted_38, n2_.signature AS signature_39, n2_.is_confirmed AS is_confirmed_40, n2_.script_mint AS script_mint_41, m3_.id AS id_42, m3_.offer_id AS offer_id_43, m3_.price AS price_44, m3_.is_accepted AS is_accepted_45, m3_.is_canceled AS is_canceled_46, m3_.created_at AS created_at_47, m3_.updated_at AS updated_at_48, m3_.notification_read AS notification_read_49, m3_.seller_payout AS seller_payout_50, m3_.fee AS fee_51, m3_.tx AS tx_52, m4_.id AS id_53, m4_.item_id AS item_id_54, m4_.price AS price_55, m4_.is_sold AS is_sold_56, m4_.is_canceled AS is_canceled_57, m4_.created_at AS created_at_58, m4_.updated_at AS updated_at_59, m4_.notification_read AS notification_read_60, m4_.seller_payout AS seller_payout_61, m4_.fee AS fee_62, m4_.tx AS tx_63, n0_.nft_collection_id AS nft_collection_id_64, n0_.template_id AS template_id_65, n0_.nft_metadata_quest_id AS nft_metadata_quest_id_66, n0_.school_of_magic_id AS school_of_magic_id_67, t1_.genus_id AS genus_id_68, t1_.category_id AS category_id_69, t1_.recipe_id AS recipe_id_70, t1_.nft_game_id AS nft_game_id_71, t1_.non_nft_game_id AS non_nft_game_id_72, n2_.nft_contract_id AS nft_contract_id_73, n2_.nft_metadata_id AS nft_metadata_id_74, n2_.theta_wallet_id AS theta_wallet_id_75, n2_.crate_action_log_id AS crate_action_log_id_76, n2_.parent_id AS parent_id_77, m3_.nft_contract_id AS nft_contract_id_78, m3_.market_contract_id AS market_contract_id_79, m3_.nft_hub_id AS nft_hub_id_80, m3_.bidder_id AS bidder_id_81, m3_.seller_id AS seller_id_82, m4_.nft_contract_id AS nft_contract_id_83, m4_.market_contract_id AS market_contract_id_84, m4_.buyer_id AS buyer_id_85, m4_.seller_id AS seller_id_86, m4_.nft_hub_id AS nft_hub_id_87 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 LEFT JOIN market_offer m3_ ON n2_.id = m3_.nft_hub_id LEFT JOIN market_item m4_ ON n2_.id = m4_.nft_hub_id WHERE n0_.nft_collection_id = ? AND t1_.id = ? ORDER BY n0_.mint ASC
Parameters: 
[
  "5"
  "164"
]
View formatted query    View runnable query    Explain query
4 2.99 ms 
SELECT t0.id AS id_1, t0.progress AS progress_2, t0.goal AS goal_3, t0.stat_square_mod AS stat_square_mod_4, t0.stat_circle_mod AS stat_circle_mod_5, t0.stat_diamond_mod AS stat_diamond_mod_6, t0.stat_triangle_mod AS stat_triangle_mod_7, t0.stat_rectangle_mod AS stat_rectangle_mod_8, t0.stat_star_mod AS stat_star_mod_9, t0.stat_heart_mod AS stat_heart_mod_10, t0.stat_octagon_mod AS stat_octagon_mod_11, t0.quest_id AS quest_id_12 FROM nft_metadata_quest t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  5816
  5817
  5818
  5819
  5820
  5821
  5822
  5823
  5824
  5825
  5826
  5827
  5828
  5829
  5830
  5831
  5832
  5833
  5834
  5835
  5836
  5837
  5838
  5839
  5840
  5841
  5842
  5843
  5844
  5845
  5846
  5847
  5848
  5849
  5850
  5851
  5852
  5853
  5854
  5855
  5856
  5857
  5858
  5859
  5860
  5861
  5862
  5863
  5864
  5865
  5866
  5867
  5868
  5869
  5870
  5871
  5872
  5873
  5874
  5875
  5876
  5877
  5878
  5879
  5880
  5881
  5882
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  5897
  5898
  5899
  5900
  5901
  5902
  5903
  5904
  5905
  5906
  5907
  5908
  5909
  5910
  5911
  5912
  5913
  5914
  5915
  5916
  5917
  5918
  5919
  5920
  5921
  5922
  5923
  5924
  5925
  5926
  5927
  5928
  5929
  5930
  5931
  5932
  5933
  5934
  5935
  5936
  5937
  5938
  5939
  5940
  5941
  5942
  5943
  5944
  5945
  5946
  5947
  5948
  5949
  5950
  5951
  5952
  5953
  5954
  5955
  5956
  5957
  5958
  5959
  5960
  5961
  5962
  5963
  5964
  5965
  5966
  5967
  5968
  5969
  5970
  5971
  5972
  5973
  5974
  5975
  5976
  5977
  5978
  5979
  5980
  5981
  5982
  5983
  5984
  5985
  5986
  5987
  5988
  5989
  5990
  5991
  5992
  5993
  5994
  5995
  5996
  5997
  5998
  5999
  6000
  6001
  6002
  6003
  6004
  6005
  6006
  6007
  6008
  6009
  6010
  6011
  6012
  6013
  6014
  6015
  6016
  6017
  6018
  6019
  6020
  6021
  6022
  6023
  6024
  6025
  6026
  6027
  6028
  6029
  6030
  6031
  6032
  6033
  6034
  6035
  6036
  6037
  6038
  6039
  6040
  6041
  6042
  6043
  6044
  6045
  6046
  6047
  6048
  6049
  6050
  6051
  6052
  6053
  6054
  6055
  6056
  6057
  6058
  6059
  6060
  6061
  6062
  6063
  6064
  6065
  6066
  6067
  6068
  6069
  6070
  6071
  6072
  6073
  6074
  6075
  6076
  6077
  6078
  6079
  6080
  6081
  6082
  6083
  6084
  6085
  6086
  6087
  6088
  6089
  6090
  6091
  6092
  6093
  6094
  6095
  6096
  6097
  6098
  6099
  6100
  6101
  6102
  6103
  6104
  6105
  6106
  6107
  6108
  6109
  6110
  6111
  6112
  6113
  6114
  6115
]
View formatted query    View runnable query    Explain query
5 0.76 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
6 0.88 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
]
View formatted query    View runnable query    Explain query
7 0.95 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
8 0.54 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
9 0.33 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
10 1.02 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: 
[
  163
]
View formatted query    View runnable query    Explain query
11 0.83 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
12 0.93 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: 
[
  209
]
View formatted query    View runnable query    Explain query
13 0.86 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

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