Query Metrics
17
Database Queries
8
Different statements
22.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.63 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, n1_.id AS id_19, n1_.ipfs_url AS ipfs_url_20, n1_.price AS price_21, n1_.is_minted AS is_minted_22, n1_.signature AS signature_23, n1_.is_confirmed AS is_confirmed_24, n1_.script_mint AS script_mint_25, m2_.id AS id_26, m2_.offer_id AS offer_id_27, m2_.price AS price_28, m2_.is_accepted AS is_accepted_29, m2_.is_canceled AS is_canceled_30, m2_.created_at AS created_at_31, m2_.updated_at AS updated_at_32, m2_.notification_read AS notification_read_33, m2_.seller_payout AS seller_payout_34, m2_.fee AS fee_35, m2_.tx AS tx_36, m3_.id AS id_37, m3_.item_id AS item_id_38, m3_.price AS price_39, m3_.is_sold AS is_sold_40, m3_.is_canceled AS is_canceled_41, m3_.created_at AS created_at_42, m3_.updated_at AS updated_at_43, m3_.notification_read AS notification_read_44, m3_.seller_payout AS seller_payout_45, m3_.fee AS fee_46, m3_.tx AS tx_47, n0_.nft_collection_id AS nft_collection_id_48, n0_.template_id AS template_id_49, n0_.nft_metadata_quest_id AS nft_metadata_quest_id_50, n0_.school_of_magic_id AS school_of_magic_id_51, n1_.nft_contract_id AS nft_contract_id_52, n1_.nft_metadata_id AS nft_metadata_id_53, n1_.theta_wallet_id AS theta_wallet_id_54, n1_.crate_action_log_id AS crate_action_log_id_55, n1_.parent_id AS parent_id_56, m2_.nft_contract_id AS nft_contract_id_57, m2_.market_contract_id AS market_contract_id_58, m2_.nft_hub_id AS nft_hub_id_59, m2_.bidder_id AS bidder_id_60, m2_.seller_id AS seller_id_61, m3_.nft_contract_id AS nft_contract_id_62, m3_.market_contract_id AS market_contract_id_63, m3_.buyer_id AS buyer_id_64, m3_.seller_id AS seller_id_65, m3_.nft_hub_id AS nft_hub_id_66 FROM nft_metadata n0_ INNER JOIN nft_hub n1_ ON n0_.id = n1_.nft_metadata_id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN market_item m3_ ON n1_.id = m3_.nft_hub_id WHERE n0_.nft_collection_id = ? AND n1_.is_minted = 1 ORDER BY n0_.score DESC
Parameters:
[
2
]
|
| 2 | 0.77 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 IN (?)
Parameters:
[
2
]
|
| 3 | 0.93 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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 54 56 58 55 57 47 50 52 49 48 51 53 38 43 46 35 31 28 30 ] |
| 4 | 1.14 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:
[ 1140 961 1137 1186 1451 1449 960 1144 957 1142 958 793 1450 792 1143 1138 1139 791 790 1141 1448 959 1136 1538 1335 575 1522 1521 1532 576 1323 1325 1528 659 1311 1331 1316 1320 1527 662 1309 1336 1551 1515 1318 1529 1308 1543 1533 1313 1317 1539 1552 1312 1549 1537 1540 1330 1512 1524 1530 1535 1310 660 1181 1526 1324 624 1531 1332 1514 1547 1314 1544 578 1546 1513 1517 1518 1519 1315 1328 1182 1523 1541 1516 1520 1511 1319 1333 1542 1545 1326 1525 661 1322 1534 1337 577 1327 1321 1334 1548 1550 1329 823 541 824 527 986 989 990 988 987 506 387 388 386 425 ] |
| 5 | 1.78 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.game_token AS game_token_5, t0.wallet AS wallet_6, t0.google_id AS google_id_7, t0.username AS username_8, t0.wallet_extension AS wallet_extension_9, t0.config AS config_10, t0.last_recipe_hint AS last_recipe_hint_11, t0.experience AS experience_12, t0.shadow_ban_until AS shadow_ban_until_13, t0.shinies AS shinies_14, t0.game_token2 AS game_token2_15, t0.active_wallet_id AS active_wallet_id_16, t0.catchable_queue_id AS catchable_queue_id_17, t0.act_progression_id AS act_progression_id_18, t0.theta_drop_wallet_id AS theta_drop_wallet_id_19 FROM user t0 ORDER BY t0.experience DESC LIMIT 10
Parameters:
[] |
| 6 | 8.16 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.game_token AS game_token_4, u0_.wallet AS wallet_5, u0_.google_id AS google_id_6, u0_.username AS username_7, u0_.wallet_extension AS wallet_extension_8, u0_.config AS config_9, u0_.last_recipe_hint AS last_recipe_hint_10, u0_.experience AS experience_11, u0_.shadow_ban_until AS shadow_ban_until_12, u0_.shinies AS shinies_13, u0_.game_token2 AS game_token2_14, SUM(n1_.score) AS sclr_15, u0_.active_wallet_id AS active_wallet_id_16, u0_.catchable_queue_id AS catchable_queue_id_17, u0_.act_progression_id AS act_progression_id_18, u0_.theta_drop_wallet_id AS theta_drop_wallet_id_19 FROM user u0_ INNER JOIN user_gear u2_ ON u0_.id = u2_.user_id INNER JOIN nft_metadata n1_ ON u2_.nft_metadata_id = n1_.id GROUP BY u0_.id, u0_.email, u0_.roles, u0_.password, u0_.game_token, u0_.wallet, u0_.google_id, u0_.username, u0_.wallet_extension, u0_.config, u0_.last_recipe_hint, u0_.experience, u0_.shadow_ban_until, u0_.shinies, u0_.game_token2, u0_.active_wallet_id, u0_.catchable_queue_id, u0_.act_progression_id, u0_.theta_drop_wallet_id ORDER BY sclr_15 DESC LIMIT 25
Parameters:
[] |
| 7 | 0.91 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 8 | 0.79 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:
[
115
]
|
| 9 | 0.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.66 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
]
|
| 11 | 0.63 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:
[
83
]
|
| 12 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 13 | 0.63 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:
[
4
]
|
| 14 | 0.63 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
]
|
| 15 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 16 | 0.42 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:
[
1
]
|
| 17 | 0.59 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:
[
173
]
|
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\NftMetadata | No errors. |
| App\Entity\NftHub | No errors. |
| App\Entity\MarketOffer | No errors. |
| App\Entity\MarketItem | No errors. |
| App\Entity\NftCollection | No errors. |
| App\Entity\Template | 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\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\Quest | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CatchableQueue | No errors. |
| App\Entity\ActProgression | 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. |
| App\Entity\WithdrawalLog | No errors. |