Query Metrics
9
Database Queries
6
Different statements
20.65 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11.95 ms (57.87%) |
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" "165" ] |
3.03 ms (14.68%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2.80 ms (13.55%) |
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:
[ 6116 6117 6118 6119 6120 6121 6122 6123 6124 6125 6126 6127 6128 6129 6130 6131 6132 6133 6134 6135 6136 6137 6138 6139 6140 6141 6142 6143 6144 6145 6146 6147 6148 6149 6150 6151 6152 6153 6154 6155 6156 6157 6158 6159 6160 6161 6162 6163 6164 6165 6166 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6190 6191 6192 6193 6194 6195 6196 6197 6198 6199 6200 6201 6202 6203 6204 6205 6206 6207 6208 6209 6210 6211 6212 6213 6214 6215 6216 6217 6218 6219 6220 6221 6222 6223 6224 6225 6226 6227 6228 6229 6230 6231 6232 6233 6234 6235 6236 6237 6238 6239 6240 6241 6242 6243 6244 6245 6246 6247 6248 6249 6250 6251 6252 6253 6254 6255 6256 6257 6258 6259 6260 6261 6262 6263 6264 6265 6266 6267 6268 6269 6270 6271 6272 6273 6274 6275 6276 6277 6278 6279 6280 6281 6282 6283 6284 6285 6286 6287 6288 6289 6290 6291 6292 6293 6294 6295 6296 6297 6298 6299 6300 6301 6302 6303 6304 6305 6306 6307 6308 6309 6310 6311 6312 6313 6314 6315 6316 6317 6318 6319 6320 6321 6322 6323 6324 6325 6326 6327 6328 6329 6330 6331 6332 6333 6334 6335 6336 6337 6338 6339 6340 6341 6342 6343 6344 6345 6346 6347 6348 6349 6350 6351 6352 6353 6354 6355 6356 6357 6358 6359 6360 6361 6362 6363 6364 6365 6366 6367 6368 6369 6370 6371 6372 6373 6374 6375 6376 6377 6378 6379 6380 6381 6382 6383 6384 6385 6386 6387 6388 6389 6390 6391 6392 6393 6394 6395 6396 6397 6398 6399 6400 6401 6402 6403 6404 6405 6406 6407 6408 6409 6410 6411 6412 6413 6414 6415 ] |
1.07 ms (5.19%) |
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
]
|
0.91 ms (4.41%) |
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:
[
"165"
]
|
0.89 ms (4.30%) |
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"
]
|
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. |