GET https://occultoftheoculi.tkgstage.com/explorer/collection/5/template/134

Response
200 OK
IP
3.128.255.168
Profiled on
Token
e82886

Query Metrics

9 Database Queries
6 Different statements
11.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
5.81 ms
(51.88%) 		1 
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"
  "134"
]
View formatted query    View runnable query    Explain query
2.14 ms
(19.08%) 		4 
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
1.25 ms
(11.20%) 		1 
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: 
[
  4476
  4477
  4478
  4479
  4480
  4481
  4482
  4483
  4484
  4485
  4486
  4487
  4488
  4489
  4490
  4491
  4492
  4493
  4494
  4495
  4496
  4497
  4498
  4499
  4500
  4501
  4502
  4503
  4504
  4505
  4506
  4507
  4508
  4509
  4510
  4511
  4512
  4513
  4514
  4515
  4516
  4517
  4518
  4519
  4520
  4521
  4522
  4523
  4524
  4525
  4526
  4527
  4528
  4529
  4530
  4531
  4532
  4533
  4534
  4535
  4536
  4537
  4538
  4539
  4540
  4541
  4542
  4543
  4544
  4545
  4546
  4547
  4548
  4549
  4550
  4551
  4552
  4553
  4554
  4555
  4556
  4557
  4558
  4559
  4560
  4561
  4562
  4563
  4564
  4565
  4566
  4567
  4568
  4569
  4570
  4571
  4572
  4573
  4574
  4575
  4576
  4577
  4578
  4579
  4580
  4581
  4582
  4583
  4584
  4585
  4586
  4587
  4588
  4589
  4590
  4591
  4592
  4593
  4594
  4595
  4596
  4597
  4598
  4599
  4600
  4601
  4602
  4603
  4604
  4605
  4606
  4607
  4608
  4609
  4610
  4611
  4612
  4613
  4614
  4615
  4616
  4617
  4618
  4619
  4620
  4621
  4622
  4623
  4624
  4625
]
View formatted query    View runnable query    Explain query
0.77 ms
(6.86%) 		1 
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: 
[
  "134"
]
View formatted query    View runnable query    Explain query
0.75 ms
(6.73%) 		1 
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
0.48 ms
(4.25%) 		1 
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

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.