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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.81 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:
[]
2 5.20 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:
[]
3 1.51 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 30
Parameters:
[]
4 4.12 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:
[
  [
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
  ]
]
5 8.53 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:
[
  1331
]
6 8.81 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:
[
  1332
]
7 7.04 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:
[
  32
]
8 7.88 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:
[
  31
]
9 8.04 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:
[
  12625
]
10 7.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:
[
  1343
]
11 7.17 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:
[
  1344
]
12 7.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:
[
  48
]
13 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:
[
  20
]
14 6.92 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:
[
  46
]
15 6.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:
[
  10
]
16 8.80 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:
[
  9
]
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:
[
  1335
]
18 7.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:
[
  1336
]
19 8.14 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:
[
  12533
]

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.