Query Metrics
19
Database Queries
5
Different statements
151.06 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
128.52 ms (85.08%) |
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.id0 = ? LIMIT 1
Parameters:
[
8473
]
|
13.47 ms (8.92%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.variation AS variation_3, t0.body_title AS body_title_4, t0.diy AS diy_5, t0.customize AS customize_6, t0.kit_cost AS kit_cost_7, t0.buy AS buy_8, t0.sell AS sell_9, t0.size AS size_10, t0.source AS source_11, t0.version AS version_12, t0.filename AS filename_13, t0.variant_id AS variant_id_14, t0.internal_id AS internal_id_15, t0.unique_entry_id AS unique_entry_id_16, t0.uses AS uses_17, t0.stack_size AS stack_size_18, t0.color1 AS color1_19, t0.color2 AS color2_20, t0.set_item AS set_item_21, t0.source_notes AS source_notes_22, t0.miles_price AS miles_price_23, t0.version_unlock AS version_unlock_24, t0.hha_base_points AS hha_base_points_25, t0.out_door AS out_door_26 FROM data_tools t0 ORDER BY t0.name ASC
Parameters:
[] |
3.92 ms (2.60%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.body_title AS body_title_3, d0_.diy AS diy_4, d0_.customize AS customize_5, d0_.kit_cost AS kit_cost_6, d0_.buy AS buy_7, d0_.sell AS sell_8, d0_.size AS size_9, d0_.source AS source_10, d0_.version AS version_11, d0_.filename AS filename_12, d0_.variant_id AS variant_id_13, d0_.internal_id AS internal_id_14, d0_.unique_entry_id AS unique_entry_id_15, d0_.uses AS uses_16, d0_.stack_size AS stack_size_17, d0_.color1 AS color1_18, d0_.color2 AS color2_19, d0_.set_item AS set_item_20, d0_.source_notes AS source_notes_21, d0_.miles_price AS miles_price_22, d0_.version_unlock AS version_unlock_23, d0_.hha_base_points AS hha_base_points_24, d0_.out_door AS out_door_25 FROM data_tools d0_) dctrn_result) dctrn_table
Parameters:
[] |
3.19 ms (2.11%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.body_title AS body_title_3, d0_.diy AS diy_4, d0_.customize AS customize_5, d0_.kit_cost AS kit_cost_6, d0_.buy AS buy_7, d0_.sell AS sell_8, d0_.size AS size_9, d0_.source AS source_10, d0_.version AS version_11, d0_.filename AS filename_12, d0_.variant_id AS variant_id_13, d0_.internal_id AS internal_id_14, d0_.unique_entry_id AS unique_entry_id_15, d0_.uses AS uses_16, d0_.stack_size AS stack_size_17, d0_.color1 AS color1_18, d0_.color2 AS color2_19, d0_.set_item AS set_item_20, d0_.source_notes AS source_notes_21, d0_.miles_price AS miles_price_22, d0_.version_unlock AS version_unlock_23, d0_.hha_base_points AS hha_base_points_24, d0_.out_door AS out_door_25 FROM data_tools d0_ WHERE d0_.id IN (?)
Parameters:
[ [ 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 ] ] |
1.95 ms (1.29%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.body_title AS body_title_3, d0_.diy AS diy_4, d0_.customize AS customize_5, d0_.kit_cost AS kit_cost_6, d0_.buy AS buy_7, d0_.sell AS sell_8, d0_.size AS size_9, d0_.source AS source_10, d0_.version AS version_11, d0_.filename AS filename_12, d0_.variant_id AS variant_id_13, d0_.internal_id AS internal_id_14, d0_.unique_entry_id AS unique_entry_id_15, d0_.uses AS uses_16, d0_.stack_size AS stack_size_17, d0_.color1 AS color1_18, d0_.color2 AS color2_19, d0_.set_item AS set_item_20, d0_.source_notes AS source_notes_21, d0_.miles_price AS miles_price_22, d0_.version_unlock AS version_unlock_23, d0_.hha_base_points AS hha_base_points_24, d0_.out_door AS out_door_25 FROM data_tools d0_) dctrn_result LIMIT 15 OFFSET 105
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\DataTools | No errors. |
App\Entity\Translate | No errors. |
App\Entity\AcnhItems | No errors. |
App\Entity\AuxItem | No errors. |
App\Entity\TodosItems | No errors. |