http://ks3309556.kimsufi.com/items/tools/6?p=items%2Ftools%2F6

Method
GET
HTTP Status
200
IP
3.145.111.116
Profiled on
Token
d487e3

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 2.51 ms 
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: 
[]
View formatted query    View runnable query    Explain query
2 13.23 ms 
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: 
[]
View formatted query    View runnable query    Explain query
3 1.74 ms 
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 75
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 2.21 ms 
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: 
[
  [
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
  ]
]
View formatted query    View runnable query    Explain query
5 9.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: 
[
  3083
]
View formatted query    View runnable query    Explain query
6 9.37 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: 
[
  9617
]
View formatted query    View runnable query    Explain query
7 8.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.id0 = ? LIMIT 1
Parameters: 
[
  8179
]
View formatted query    View runnable query    Explain query
8 8.85 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: 
[
  8660
]
View formatted query    View runnable query    Explain query
9 8.98 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: 
[
  8574
]
View formatted query    View runnable query    Explain query
10 8.12 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: 
[
  8578
]
View formatted query    View runnable query    Explain query
11 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: 
[
  7591
]
View formatted query    View runnable query    Explain query
12 8.94 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: 
[
  8533
]
View formatted query    View runnable query    Explain query
13 9.03 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: 
[
  5083
]
View formatted query    View runnable query    Explain query
14 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.id0 = ? LIMIT 1
Parameters: 
[
  7585
]
View formatted query    View runnable query    Explain query
15 8.30 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: 
[
  7592
]
View formatted query    View runnable query    Explain query
16 9.25 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: 
[
  2615
]
View formatted query    View runnable query    Explain query
17 18.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.id0 = ? LIMIT 1
Parameters: 
[
  5741
]
View formatted query    View runnable query    Explain query
18 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: 
[
  5094
]
View formatted query    View runnable query    Explain query
19 8.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.id0 = ? LIMIT 1
Parameters: 
[
  5095
]
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\DataTools No errors.
App\Entity\Translate No errors.
App\Entity\AcnhItems No errors.
App\Entity\AuxItem No errors.
App\Entity\TodosItems No errors.