http://ks3309556.kimsufi.com/items/art/4?p=items%2Fart%2F4

Method
GET
HTTP Status
200
IP
3.144.17.193
Profiled on
Token
ed2629

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 4.04 ms 
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: 
[]
View formatted query    View runnable query    Explain query
2 7.16 ms 
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: 
[]
View formatted query    View runnable query    Explain query
3 1.64 ms 
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 45
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 2.43 ms 
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: 
[
  [
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
  ]
]
View formatted query    View runnable query    Explain query
5 7.65 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: 
[
  12534
]
View formatted query    View runnable query    Explain query
6 8.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: 
[
  66
]
View formatted query    View runnable query    Explain query
7 9.07 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: 
[
  65
]
View formatted query    View runnable query    Explain query
8 7.72 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: 
[
  2
]
View formatted query    View runnable query    Explain query
9 7.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: 
[
  12629
]
View formatted query    View runnable query    Explain query
10 7.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: 
[
  24
]
View formatted query    View runnable query    Explain query
11 7.72 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: 
[
  23
]
View formatted query    View runnable query    Explain query
12 7.32 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: 
[
  12621
]
View formatted query    View runnable query    Explain query
13 7.09 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: 
[
  72
]
View formatted query    View runnable query    Explain query
14 7.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: 
[
  71
]
View formatted query    View runnable query    Explain query
15 8.44 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: 
[
  12537
]
View formatted query    View runnable query    Explain query
16 7.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: 
[
  12538
]
View formatted query    View runnable query    Explain query
17 8.09 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: 
[
  12618
]
View formatted query    View runnable query    Explain query
18 8.15 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: 
[
  1345
]
View formatted query    View runnable query    Explain query
19 7.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: 
[
  1346
]
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\Translate No errors.
App\Entity\AcnhItems No errors.
App\Entity\AuxItem No errors.
App\Entity\TodosItems No errors.