Query Metrics
19
Database Queries
5
Different statements
618.12 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.68 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.buy AS buy_2, d0_.sell AS sell_3, d0_.color1 AS color1_4, d0_.color2 AS color2_5, d0_.source AS source_6, d0_.version AS version_7, d0_.catalog AS catalog_8, d0_.filename AS filename_9, d0_.internal_id AS internal_id_10, d0_.unique_entry_id AS unique_entry_id_11, d0_.size AS size_12, d0_.source_notes AS source_notes_13, d0_.miles_price AS miles_price_14, d0_.version_unlock AS version_unlock_15, d0_.hha_base_points AS hha_base_points_16, d0_.out_door AS out_door_17 FROM data_posters d0_) dctrn_result) dctrn_table
Parameters:
[] |
2 | 36.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.buy AS buy_3, t0.sell AS sell_4, t0.color1 AS color1_5, t0.color2 AS color2_6, t0.source AS source_7, t0.version AS version_8, t0.catalog AS catalog_9, t0.filename AS filename_10, t0.internal_id AS internal_id_11, t0.unique_entry_id AS unique_entry_id_12, t0.size AS size_13, t0.source_notes AS source_notes_14, t0.miles_price AS miles_price_15, t0.version_unlock AS version_unlock_16, t0.hha_base_points AS hha_base_points_17, t0.out_door AS out_door_18 FROM data_posters t0 ORDER BY t0.name ASC
Parameters:
[] |
3 | 2.53 ms |
SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.buy AS buy_2, d0_.sell AS sell_3, d0_.color1 AS color1_4, d0_.color2 AS color2_5, d0_.source AS source_6, d0_.version AS version_7, d0_.catalog AS catalog_8, d0_.filename AS filename_9, d0_.internal_id AS internal_id_10, d0_.unique_entry_id AS unique_entry_id_11, d0_.size AS size_12, d0_.source_notes AS source_notes_13, d0_.miles_price AS miles_price_14, d0_.version_unlock AS version_unlock_15, d0_.hha_base_points AS hha_base_points_16, d0_.out_door AS out_door_17 FROM data_posters d0_) dctrn_result LIMIT 15 OFFSET 90
Parameters:
[] |
4 | 3.51 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.buy AS buy_2, d0_.sell AS sell_3, d0_.color1 AS color1_4, d0_.color2 AS color2_5, d0_.source AS source_6, d0_.version AS version_7, d0_.catalog AS catalog_8, d0_.filename AS filename_9, d0_.internal_id AS internal_id_10, d0_.unique_entry_id AS unique_entry_id_11, d0_.size AS size_12, d0_.source_notes AS source_notes_13, d0_.miles_price AS miles_price_14, d0_.version_unlock AS version_unlock_15, d0_.hha_base_points AS hha_base_points_16, d0_.out_door AS out_door_17 FROM data_posters d0_ WHERE d0_.id IN (?)
Parameters:
[ [ 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 ] ] |
5 | 42.64 ms |
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:
[
10515
]
|
6 | 46.40 ms |
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:
[
11124
]
|
7 | 25.78 ms |
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:
[
10628
]
|
8 | 34.83 ms |
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:
[
10504
]
|
9 | 41.25 ms |
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:
[
10317
]
|
10 | 45.67 ms |
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:
[
10649
]
|
11 | 46.00 ms |
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:
[
10680
]
|
12 | 43.61 ms |
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:
[
10356
]
|
13 | 45.29 ms |
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:
[
10686
]
|
14 | 39.31 ms |
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:
[
10379
]
|
15 | 42.60 ms |
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:
[
10326
]
|
16 | 42.58 ms |
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:
[
10452
]
|
17 | 27.26 ms |
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:
[
10367
]
|
18 | 22.35 ms |
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:
[
10335
]
|
19 | 24.96 ms |
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:
[
10448
]
|
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\DataPosters | No errors. |
App\Entity\Translate | No errors. |
App\Entity\AcnhItems | No errors. |
App\Entity\AuxItem | No errors. |
App\Entity\TodosItems | No errors. |