Query Metrics
19
Database Queries
5
Different statements
208.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
111.82 ms (53.63%) |
15 |
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:
[
663
]
|
|
48.57 ms (23.29%) |
1 |
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:
[] |
|
40.85 ms (19.59%) |
1 |
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:
[] |
|
4.93 ms (2.36%) |
1 |
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:
[
[
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
]
]
|
|
2.34 ms (1.12%) |
1 |
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 210
Parameters:
[] |
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. |