Query Metrics
48
Database Queries
13
Different statements
21.82 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 5.06 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.department_id = ?
Parameters:
[
"3"
]
|
2 | 0.86 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "3" "en_US" "App\Entity\Department" ] |
3 | 1.80 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
3
]
|
4 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "3" "en" "App\Entity\Department" ] |
5 | 0.04 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.lft <= 1 AND d0_.rgt >= 12 AND d0_.root_id = ? ORDER BY d0_.lft ASC
Parameters:
[
3
]
|
6 | 0.03 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
3
]
|
7 | 2.71 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "3" "en" "App\Entity\Department" ] |
8 | 0.05 ms |
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[] |
9 | 2.02 ms |
SELECT e0_.eshop_link_id AS eshop_link_id_0, e0_.eshop_link_name AS eshop_link_name_1, e0_.eshop_link_description AS eshop_link_description_2, e0_.eshop_link_url AS eshop_link_url_3, e0_.user_id AS user_id_4, e0_.eshop_link_type AS eshop_link_type_5, e0_.priority AS priority_6, e0_.status AS status_7, e0_.date_inserted AS date_inserted_8, e0_.date_last_control AS date_last_control_9, e0_.logo_url AS logo_url_10, e0_.notes AS notes_11, e0_.admin_user_id AS admin_user_id_12, e0_.eshop_link_email AS eshop_link_email_13, e0_.preferred_language_id AS preferred_language_id_14, e0_.cut_long_description AS cut_long_description_15, e0_.eshop_link_current AS eshop_link_current_16 FROM eshop_link e0_ INNER JOIN eshop_link_department e2_ ON e0_.eshop_link_id = e2_.eshop_link_id INNER JOIN department d1_ ON d1_.department_id = e2_.department_id WHERE d1_.department_id = ?
Parameters:
[
"3"
]
|
10 | 3.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM eshop_link_translation e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "10" "en_US" "App\Entity\EshopLink" ] |
11 | 0.05 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM eshop_link_translation e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "11" "en_US" "App\Entity\EshopLink" ] |
12 | 0.04 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM eshop_link_translation e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "12" "en_US" "App\Entity\EshopLink" ] |
13 | 0.05 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id IS NULL ORDER BY d0_.lft ASC
Parameters:
[] |
14 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\Department" ] |
15 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\Department" ] |
16 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "4" "en_US" "App\Entity\Department" ] |
17 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "5" "en_US" "App\Entity\Department" ] |
18 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "6" "en_US" "App\Entity\Department" ] |
19 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "7" "en_US" "App\Entity\Department" ] |
20 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "8" "en_US" "App\Entity\Department" ] |
21 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "9" "en_US" "App\Entity\Department" ] |
22 | 0.12 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "10" "en_US" "App\Entity\Department" ] |
23 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "11" "en_US" "App\Entity\Department" ] |
24 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "12" "en_US" "App\Entity\Department" ] |
25 | 0.03 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
3
]
|
26 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "95" "en_US" "App\Entity\Department" ] |
27 | 0.08 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "96" "en_US" "App\Entity\Department" ] |
28 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "97" "en_US" "App\Entity\Department" ] |
29 | 0.92 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "98" "en_US" "App\Entity\Department" ] |
30 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "99" "en_US" "App\Entity\Department" ] |
31 | 0.05 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
95
]
|
32 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "95" "en" "App\Entity\Department" ] |
33 | 0.05 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
95
]
|
34 | 0.05 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
96
]
|
35 | 2.99 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "96" "en" "App\Entity\Department" ] |
36 | 0.06 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
96
]
|
37 | 0.05 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
97
]
|
38 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "97" "en" "App\Entity\Department" ] |
39 | 0.05 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
97
]
|
40 | 0.04 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
98
]
|
41 | 0.05 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "98" "en" "App\Entity\Department" ] |
42 | 0.04 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
98
]
|
43 | 0.05 ms |
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
99
]
|
44 | 0.04 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "99" "en" "App\Entity\Department" ] |
45 | 0.05 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
99
]
|
46 | 0.44 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id INNER JOIN department d1_ ON d1_.department_id = p2_.department_id WHERE p0_.stock <> ? AND d1_.department_id IN (?) ORDER BY p0_.priority ASC LIMIT 20 OFFSET 55698820
Parameters:
[ -3 3 ] |
47 | 0.04 ms |
SELECT COUNT(p0_.product_id) AS sclr_0 FROM product p0_ INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id INNER JOIN department d1_ ON d1_.department_id = p2_.department_id WHERE d1_.department_id IN (?)
Parameters:
[
3
]
|
48 | 0.04 ms |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (NULL)
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
dynamic_conn | doctrine.dbal.dynamic_conn_connection |
eshop_conn | doctrine.dbal.eshop_conn_connection |
eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
dynamic_em | doctrine.orm.dynamic_em_entity_manager |
eshop_em | doctrine.orm.eshop_em_entity_manager |
eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Server | No errors. |
App\Entity\Department | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\DepartmentTranslation | No errors. |
App\Entity\Language | No errors. |
App\Entity\EshopLink | No errors. |
App\Entity\EshopLinkTranslation | No errors. |
App\Entity\Product | No errors. |
App\Entity\Price | No errors. |
dynamic_em entity manager
No loaded entities.
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.