Query Metrics
14
Database Queries
5
Different statements
136.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
123.35 ms (90.33%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.id0 AS id0_3, t0.id1 AS id1_4, t0.code AS code_5, t0.internal_name AS internal_name_6, t0.price AS price_7, t0.diy_recipe0 AS diy_recipe0_8, t0.diy_recipe1 AS diy_recipe1_9, t0.id_item AS id_item_10, t0.en AS en_11, t0.es AS es_12, t0.de AS de_13, t0.fr AS fr_14, t0.it AS it_15, t0.ru AS ru_16, t0.nl AS nl_17 FROM acnh_items t0 WHERE t0.id0 = ? LIMIT 1
Parameters:
[
34
]
|
|
5.40 ms (3.96%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.genuine AS genuine_3, t0.category AS category_4, t0.buy AS buy_5, t0.sell AS sell_6, t0.color1 AS color1_7, t0.color2 AS color2_8, t0.size AS size_9, t0.real_artwork_title AS real_artwork_title_10, t0.artist AS artist_11, t0.museum_description AS museum_description_12, t0.source AS source_13, t0.version AS version_14, t0.hha_concept1 AS hha_concept1_15, t0.hha_concept2 AS hha_concept2_16, t0.hha_series AS hha_series_17, t0.hha_set AS hha_set_18, t0.interact AS interact_19, t0.tag AS tag_20, t0.speaker_type AS speaker_type_21, t0.lighting_type AS lighting_type_22, t0.catalog AS catalog_23, t0.filename AS filename_24, t0.internal_id AS internal_id_25, t0.unique_entry_id AS unique_entry_id_26, t0.highres_texture AS highres_texture_27 FROM data_art t0 ORDER BY t0.name ASC
Parameters:
[] |
|
4.01 ms (2.94%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.genuine AS genuine_2, d0_.category AS category_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.real_artwork_title AS real_artwork_title_9, d0_.artist AS artist_10, d0_.museum_description AS museum_description_11, d0_.source AS source_12, d0_.version AS version_13, d0_.hha_concept1 AS hha_concept1_14, d0_.hha_concept2 AS hha_concept2_15, d0_.hha_series AS hha_series_16, d0_.hha_set AS hha_set_17, d0_.interact AS interact_18, d0_.tag AS tag_19, d0_.speaker_type AS speaker_type_20, d0_.lighting_type AS lighting_type_21, d0_.catalog AS catalog_22, d0_.filename AS filename_23, d0_.internal_id AS internal_id_24, d0_.unique_entry_id AS unique_entry_id_25, d0_.highres_texture AS highres_texture_26 FROM data_art d0_ WHERE d0_.id IN (?)
Parameters:
[
[
61
62
63
64
65
66
67
68
69
70
]
]
|
|
2.07 ms (1.52%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.genuine AS genuine_2, d0_.category AS category_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.real_artwork_title AS real_artwork_title_9, d0_.artist AS artist_10, d0_.museum_description AS museum_description_11, d0_.source AS source_12, d0_.version AS version_13, d0_.hha_concept1 AS hha_concept1_14, d0_.hha_concept2 AS hha_concept2_15, d0_.hha_series AS hha_series_16, d0_.hha_set AS hha_set_17, d0_.interact AS interact_18, d0_.tag AS tag_19, d0_.speaker_type AS speaker_type_20, d0_.lighting_type AS lighting_type_21, d0_.catalog AS catalog_22, d0_.filename AS filename_23, d0_.internal_id AS internal_id_24, d0_.unique_entry_id AS unique_entry_id_25, d0_.highres_texture AS highres_texture_26 FROM data_art d0_) dctrn_result) dctrn_table
Parameters:
[] |
|
1.71 ms (1.25%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.genuine AS genuine_2, d0_.category AS category_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.real_artwork_title AS real_artwork_title_9, d0_.artist AS artist_10, d0_.museum_description AS museum_description_11, d0_.source AS source_12, d0_.version AS version_13, d0_.hha_concept1 AS hha_concept1_14, d0_.hha_concept2 AS hha_concept2_15, d0_.hha_series AS hha_series_16, d0_.hha_set AS hha_set_17, d0_.interact AS interact_18, d0_.tag AS tag_19, d0_.speaker_type AS speaker_type_20, d0_.lighting_type AS lighting_type_21, d0_.catalog AS catalog_22, d0_.filename AS filename_23, d0_.internal_id AS internal_id_24, d0_.unique_entry_id AS unique_entry_id_25, d0_.highres_texture AS highres_texture_26 FROM data_art d0_) dctrn_result LIMIT 15 OFFSET 60
Parameters:
[] |
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\DataArt | No errors. |
| App\Entity\Translate | No errors. |
| App\Entity\AcnhItems | No errors. |
| App\Entity\AuxItem | No errors. |
| App\Entity\TodosItems | No errors. |