Query Metrics
2
Database Queries
2
Different statements
3.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.93 ms (81.49%) |
1 |
SELECT t0_.id AS id_0, t0_.is_catchable AS is_catchable_1, t0_.name AS name_2, t0_.description AS description_3, t0_.image_url AS image_url_4, t0_.tier AS tier_5, t0_.min_stat AS min_stat_6, t0_.max_stat AS max_stat_7, t0_.min_weight AS min_weight_8, t0_.max_weight AS max_weight_9, t0_.aux_data AS aux_data_10, t0_.buy_price AS buy_price_11, t0_.shop_inventory AS shop_inventory_12, t0_.release_at AS release_at_13, t0_.max_editions AS max_editions_14, t0_.lootable AS lootable_15, count(n1_.id) AS sclr_16 FROM nft_metadata n1_ LEFT JOIN template t0_ ON (n1_.template_id = t0_.id) INNER JOIN nft_hub n2_ ON n1_.id = n2_.nft_metadata_id WHERE n1_.nft_collection_id = ? AND n2_.is_minted = 1 GROUP BY t0_.id, t0_.is_catchable, t0_.name, t0_.description, t0_.image_url, t0_.tier, t0_.min_stat, t0_.max_stat, t0_.min_weight, t0_.max_weight, t0_.aux_data, t0_.buy_price, t0_.shop_inventory, t0_.release_at, t0_.max_editions, t0_.lootable, t0_.genus_id, t0_.category_id, t0_.recipe_id, t0_.nft_game_id, t0_.non_nft_game_id ORDER BY t0_.genus_id DESC, t0_.tier DESC
Parameters:
[
"2"
]
|
|
0.67 ms (18.51%) |
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:
[
"2"
]
|
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\NftHub | No errors. |