http://bea.sharksgames.com/items/art?p=items%2Fart

Method
GET
HTTP Status
200
IP
3.136.17.139
Profiled on
Token
5ff029

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 3.35 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.58 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.70 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 4.02 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: 
[
  [
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
  ]
]
View formatted query    View runnable query    Explain query
5 8.97 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: 
[
  12619
]
View formatted query    View runnable query    Explain query
6 8.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: 
[
  12620
]
View formatted query    View runnable query    Explain query
7 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: 
[
  56
]
View formatted query    View runnable query    Explain query
8 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: 
[
  55
]
View formatted query    View runnable query    Explain query
9 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: 
[
  1337
]
View formatted query    View runnable query    Explain query
10 8.45 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: 
[
  1338
]
View formatted query    View runnable query    Explain query
11 7.03 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: 
[
  14
]
View formatted query    View runnable query    Explain query
12 7.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: 
[
  13
]
View formatted query    View runnable query    Explain query
13 8.63 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: 
[
  1341
]
View formatted query    View runnable query    Explain query
14 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: 
[
  1342
]
View formatted query    View runnable query    Explain query
15 7.24 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: 
[
  78
]
View formatted query    View runnable query    Explain query
16 8.24 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: 
[
  44
]
View formatted query    View runnable query    Explain query
17 8.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: 
[
  12622
]
View formatted query    View runnable query    Explain query
18 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: 
[
  12623
]
View formatted query    View runnable query    Explain query
19 6.95 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: 
[
  38
]
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.