http://bea.sharksgames.com/items/recipes/8?p=items%2Frecipes%2F8

Method
GET
HTTP Status
200
IP
18.227.134.133
Profiled on
Token
e9eb5e

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 6.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 37.24 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 1.88 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 105
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 4.68 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: 
[
  [
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
  ]
]
View formatted query    View runnable query    Explain query
5 8.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  537
]
View formatted query    View runnable query    Explain query
6 5.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  418
]
View formatted query    View runnable query    Explain query
7 13.79 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: 
[
  480
]
View formatted query    View runnable query    Explain query
8 16.00 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: 
[
  444
]
View formatted query    View runnable query    Explain query
9 31.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  259
]
View formatted query    View runnable query    Explain query
10 31.73 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: 
[
  254
]
View formatted query    View runnable query    Explain query
11 31.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: 
[
  244
]
View formatted query    View runnable query    Explain query
12 16.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: 
[
  440
]
View formatted query    View runnable query    Explain query
13 12.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: 
[
  313
]
View formatted query    View runnable query    Explain query
14 1.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: 
[
  164
]
View formatted query    View runnable query    Explain query
15 4.57 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: 
[
  192
]
View formatted query    View runnable query    Explain query
16 14.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  317
]
View formatted query    View runnable query    Explain query
17 3.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: 
[
  457
]
View formatted query    View runnable query    Explain query
18 3.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.diy_recipe0 = ? LIMIT 1
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query
19 5.49 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: 
[
  405
]
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.