http://5.135.160.91/items/recipes/12?p=items%2Frecipes%2F12

Method
GET
HTTP Status
200
IP
3.137.223.190
Profiled on
Token
b02e8c

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 5.16 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.cant1 AS cant1_2, d0_.material1 AS material1_3, d0_.cant2 AS cant2_4, d0_.material2 AS material2_5, d0_.cant3 AS cant3_6, d0_.material3 AS material3_7, d0_.cant4 AS cant4_8, d0_.material4 AS material4_9, d0_.cant5 AS cant5_10, d0_.material5 AS material5_11, d0_.cant6 AS cant6_12, d0_.material6 AS material6_13, d0_.source AS source_14, d0_.source_notes AS source_notes_15, d0_.version AS version_16, d0_.category AS category_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.filename AS filename_20, d0_.buy AS buy_21, d0_.sell AS sell_22, d0_.miles_price AS miles_price_23, d0_.version_added AS version_added_24, d0_.recipes_to_unlock AS recipes_to_unlock_25, d0_.crafted_item_internal_id AS crafted_item_internal_id_26, d0_.card_color AS card_color_27, d0_.serial_id AS serial_id_28 FROM data_recipes d0_) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 35.86 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.cant1 AS cant1_3, t0.material1 AS material1_4, t0.cant2 AS cant2_5, t0.material2 AS material2_6, t0.cant3 AS cant3_7, t0.material3 AS material3_8, t0.cant4 AS cant4_9, t0.material4 AS material4_10, t0.cant5 AS cant5_11, t0.material5 AS material5_12, t0.cant6 AS cant6_13, t0.material6 AS material6_14, t0.source AS source_15, t0.source_notes AS source_notes_16, t0.version AS version_17, t0.category AS category_18, t0.internal_id AS internal_id_19, t0.unique_entry_id AS unique_entry_id_20, t0.filename AS filename_21, t0.buy AS buy_22, t0.sell AS sell_23, t0.miles_price AS miles_price_24, t0.version_added AS version_added_25, t0.recipes_to_unlock AS recipes_to_unlock_26, t0.crafted_item_internal_id AS crafted_item_internal_id_27, t0.card_color AS card_color_28, t0.serial_id AS serial_id_29 FROM data_recipes t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 2.22 ms 
SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.cant1 AS cant1_2, d0_.material1 AS material1_3, d0_.cant2 AS cant2_4, d0_.material2 AS material2_5, d0_.cant3 AS cant3_6, d0_.material3 AS material3_7, d0_.cant4 AS cant4_8, d0_.material4 AS material4_9, d0_.cant5 AS cant5_10, d0_.material5 AS material5_11, d0_.cant6 AS cant6_12, d0_.material6 AS material6_13, d0_.source AS source_14, d0_.source_notes AS source_notes_15, d0_.version AS version_16, d0_.category AS category_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.filename AS filename_20, d0_.buy AS buy_21, d0_.sell AS sell_22, d0_.miles_price AS miles_price_23, d0_.version_added AS version_added_24, d0_.recipes_to_unlock AS recipes_to_unlock_25, d0_.crafted_item_internal_id AS crafted_item_internal_id_26, d0_.card_color AS card_color_27, d0_.serial_id AS serial_id_28 FROM data_recipes d0_) dctrn_result LIMIT 15 OFFSET 165
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 4.13 ms 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.cant1 AS cant1_2, d0_.material1 AS material1_3, d0_.cant2 AS cant2_4, d0_.material2 AS material2_5, d0_.cant3 AS cant3_6, d0_.material3 AS material3_7, d0_.cant4 AS cant4_8, d0_.material4 AS material4_9, d0_.cant5 AS cant5_10, d0_.material5 AS material5_11, d0_.cant6 AS cant6_12, d0_.material6 AS material6_13, d0_.source AS source_14, d0_.source_notes AS source_notes_15, d0_.version AS version_16, d0_.category AS category_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.filename AS filename_20, d0_.buy AS buy_21, d0_.sell AS sell_22, d0_.miles_price AS miles_price_23, d0_.version_added AS version_added_24, d0_.recipes_to_unlock AS recipes_to_unlock_25, d0_.crafted_item_internal_id AS crafted_item_internal_id_26, d0_.card_color AS card_color_27, d0_.serial_id AS serial_id_28 FROM data_recipes 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 6.02 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  402
]
View formatted query    View runnable query    Explain query
6 18.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  191
]
View formatted query    View runnable query    Explain query
7 9.21 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  282
]
View formatted query    View runnable query    Explain query
8 6.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  646
]
View formatted query    View runnable query    Explain query
9 8.68 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
10 8.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
11 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
12 9.20 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
13 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
14 4.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  121
]
View formatted query    View runnable query    Explain query
15 5.75 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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  608
]
View formatted query    View runnable query    Explain query
16 3.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  233
]
View formatted query    View runnable query    Explain query
17 17.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  488
]
View formatted query    View runnable query    Explain query
18 13.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  484
]
View formatted query    View runnable query    Explain query
19 15.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  464
]
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\DataRecipes No errors.
App\Entity\Translate No errors.
App\Entity\AcnhItems No errors.
App\Entity\AuxItem No errors.
App\Entity\TodosItems No errors.