http://ks3309556.kimsufi.com/items/posters/12?p=items%2Fposters%2F12

Method
GET
HTTP Status
200
IP
3.137.198.239
Profiled on
Token
9be840

Query Metrics

19 Database Queries
5 Different statements
451.19 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.31 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: 
[]
View formatted query    View runnable query    Explain query
2 37.21 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: 
[]
View formatted query    View runnable query    Explain query
3 2.92 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 165
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 3.68 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: 
[
  [
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
  ]
]
View formatted query    View runnable query    Explain query
5 34.23 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: 
[
  10469
]
View formatted query    View runnable query    Explain query
6 25.23 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: 
[
  10657
]
View formatted query    View runnable query    Explain query
7 23.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: 
[
  10422
]
View formatted query    View runnable query    Explain query
8 24.42 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: 
[
  10586
]
View formatted query    View runnable query    Explain query
9 28.85 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: 
[
  10523
]
View formatted query    View runnable query    Explain query
10 31.69 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: 
[
  10643
]
View formatted query    View runnable query    Explain query
11 34.84 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: 
[
  10694
]
View formatted query    View runnable query    Explain query
12 33.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: 
[
  10518
]
View formatted query    View runnable query    Explain query
13 23.87 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: 
[
  10529
]
View formatted query    View runnable query    Explain query
14 23.10 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: 
[
  10436
]
View formatted query    View runnable query    Explain query
15 23.51 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: 
[
  10470
]
View formatted query    View runnable query    Explain query
16 25.18 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: 
[
  10806
]
View formatted query    View runnable query    Explain query
17 22.94 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: 
[
  10380
]
View formatted query    View runnable query    Explain query
18 25.06 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: 
[
  10678
]
View formatted query    View runnable query    Explain query
19 23.70 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: 
[
  10521
]
View formatted query    View runnable query    Explain query

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.