Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

149 Database Queries

11 Different statements

118.13 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 d1_.department_id IN (?) LIMIT 6
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?

#▲	Time	Info
1	1.57 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: [] View formatted query View runnable query Explain query 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 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;
2	14.78 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '1' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
3	0.45 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '2' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
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_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '3' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
5	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '4' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
6	6.83 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '5' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
7	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '6' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
8	3.73 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '7' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
9	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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '8' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
10	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '9' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
11	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '10' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
12	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '11' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
13	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '12' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
14	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: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
15	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '1' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
16	8.63 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: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
17	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: [`"20" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '20' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
18	1.77 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: [`"21" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '21' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
19	2.27 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: [`"22" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '22' AND d0_.locale = 'en_US' AND d0_.object_class = '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: [`"23" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '23' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
21	0.03 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: [`"24" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '24' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
22	0.03 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: [`"25" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '25' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
23	0.03 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: [`"26" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '26' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
24	3.54 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: [`"27" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '27' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
25	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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
26	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '2' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
27	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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
28	0.03 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: [`"35" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '35' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
29	0.03 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: [`"36" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '36' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
30	0.68 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: [`"37" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '37' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
31	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: [`"38" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '38' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
32	0.03 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: [`"39" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '39' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
33	0.03 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: [`"40" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '40' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
34	0.03 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: [`"41" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '41' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
35	0.03 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: [`"42" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '42' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
36	0.03 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: [`"43" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '43' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
37	1.77 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: [`"53" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '53' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
38	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: [`"57" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '57' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
39	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`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
40	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '3' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
41	3.58 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: [`3`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
42	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: [`"95" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '95' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
43	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '96' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
44	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '97' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
45	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '98' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
46	0.03 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"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '99' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
47	7.36 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: [`4`] View formatted query View runnable query Explain query 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 = ? 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 = 4;
48	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: [`"4" "en" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '4' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
49	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: [`4`] View formatted query View runnable query Explain query 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 = ? 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 = 4;
50	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: [`"64" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '64' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
51	0.03 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: [`"108" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '108' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
52	0.03 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: [`"109" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '109' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
53	0.03 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: [`"110" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '110' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
54	1.22 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: [`"111" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '111' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
55	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: [`5`] View formatted query View runnable query Explain query 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 = ? 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 = 5;
56	1.69 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '5' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
57	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: [`5`] View formatted query View runnable query Explain query 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 = ? 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 = 5;
58	0.03 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: [`"28" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '28' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
59	0.68 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: [`"29" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '29' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
60	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: [`"30" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '30' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
61	0.03 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: [`"31" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '31' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
62	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: [`"60" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '60' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
63	0.03 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: [`"91" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '91' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
64	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: [`6`] View formatted query View runnable query Explain query 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 = ? 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 = 6;
65	2.10 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '6' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
66	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: [`6`] View formatted query View runnable query Explain query 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 = ? 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 = 6;
67	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: [`"59" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '59' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
68	0.03 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: [`"61" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '61' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
69	0.03 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: [`"62" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '62' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
70	3.39 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: [`"63" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '63' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
71	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: [`"65" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '65' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
72	3.81 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: [`"66" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '66' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
73	3.91 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: [`"67" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '67' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
74	0.63 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: [`"68" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '68' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
75	3.22 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: [`"69" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '69' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
76	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: [`"70" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '70' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
77	0.03 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: [`"71" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '71' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
78	0.03 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: [`"72" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '72' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
79	0.03 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: [`"73" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '73' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
80	0.03 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: [`"74" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '74' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
81	2.68 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: [`"75" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '75' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
82	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: [`"76" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '76' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
83	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: [`7`] View formatted query View runnable query Explain query 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 = ? 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 = 7;
84	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '7' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
85	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: [`7`] View formatted query View runnable query Explain query 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 = ? 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 = 7;
86	0.03 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: [`"100" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '100' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
87	0.03 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: [`"101" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '101' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
88	0.03 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: [`"102" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '102' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
89	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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;
90	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '8' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
91	0.03 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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;
92	0.03 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: [`"112" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '112' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
93	0.03 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: [`"113" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '113' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
94	0.03 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: [`"114" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '114' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
95	0.03 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: [`"115" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '115' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
96	0.03 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: [`"116" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '116' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
97	0.03 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: [`"117" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '117' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
98	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: [`9`] View formatted query View runnable query Explain query 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 = ? 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 = 9;
99	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '9' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
100	0.03 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: [`9`] View formatted query View runnable query Explain query 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 = ? 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 = 9;
101	0.03 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: [`"32" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '32' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
102	0.03 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: [`"33" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '33' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
103	0.03 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: [`"34" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '34' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
104	2.17 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: [`10`] View formatted query View runnable query Explain query 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 = ? 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 = 10;
105	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: [`"10" "en" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '10' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
106	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: [`10`] View formatted query View runnable query Explain query 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 = ? 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 = 10;
107	7.97 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: [`"77" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '77' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
108	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: [`"78" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '78' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
109	3.15 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: [`"79" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '79' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
110	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: [`"80" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '80' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
111	0.03 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: [`"81" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '81' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
112	0.03 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: [`"82" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '82' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
113	3.51 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: [`"83" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '83' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
114	0.06 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: [`"84" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '84' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
115	0.03 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: [`"85" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '85' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
116	0.03 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: [`"86" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '86' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
117	0.03 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: [`"87" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '87' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
118	0.03 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: [`"88" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '88' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
119	0.03 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: [`"89" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '89' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
120	0.03 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: [`"90" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '90' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
121	0.03 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: [`"92" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '92' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
122	0.03 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: [`"93" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '93' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
123	0.03 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: [`"94" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '94' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
124	3.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: [`11`] View formatted query View runnable query Explain query 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 = ? 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 = 11;
125	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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '11' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
126	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: [`11`] View formatted query View runnable query Explain query 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 = ? 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 = 11;
127	0.03 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: [`"103" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '103' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
128	0.03 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: [`"104" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '104' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
129	0.03 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: [`"105" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '105' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
130	0.03 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: [`"106" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '106' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
131	0.03 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: [`"107" "en_US" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '107' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';
132	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: [`12`] View formatted query View runnable query Explain query 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 = ? 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 = 12;
133	0.03 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" "App\Entity\Department"`] View formatted query View runnable query Explain query 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 = ? SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '12' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';
134	0.08 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: [`12`] View formatted query View runnable query Explain query 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 = ? 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 = 12;
135	2.55 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`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
136	2.74 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 d1_.department_id IN (?) LIMIT 6 Parameters: [`3`] View formatted query View runnable query Explain query 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 d1_.department_id IN (?) LIMIT 6 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 d1_.department_id IN (3) LIMIT 6;
137	0.63 ms	SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ? SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = 95;
138	4.43 ms	SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ? SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = 95;

dynamic_conn connection


SELECT r0_.redaction_list_id AS redaction_list_id_0, r0_.redaction_list_name AS redaction_list_name_1, r0_.redaction_list_description AS redaction_list_description_2, r0_.is_public AS is_public_3, r0_.is_web_based AS is_web_based_4, r0_.date_created AS date_created_5, r0_.wepages_count AS wepages_count_6, r0_.thumb_width AS thumb_width_7, r0_.thumb_height AS thumb_height_8, r0_.priority AS priority_9, r0_.user_id AS user_id_10, r0_.score AS score_11, r0_.css_class AS css_class_12 FROM redaction_list r0_ WHERE r0_.redaction_list_id = ?
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id WHERE redaction_list_webpage.redaction_list_id = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?

#▲	Time	Info
1	0.06 ms	SELECT r0_.redaction_list_id AS redaction_list_id_0, r0_.redaction_list_name AS redaction_list_name_1, r0_.redaction_list_description AS redaction_list_description_2, r0_.is_public AS is_public_3, r0_.is_web_based AS is_web_based_4, r0_.date_created AS date_created_5, r0_.wepages_count AS wepages_count_6, r0_.thumb_width AS thumb_width_7, r0_.thumb_height AS thumb_height_8, r0_.priority AS priority_9, r0_.user_id AS user_id_10, r0_.score AS score_11, r0_.css_class AS css_class_12 FROM redaction_list r0_ WHERE r0_.redaction_list_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT r0_.redaction_list_id AS redaction_list_id_0, r0_.redaction_list_name AS redaction_list_name_1, r0_.redaction_list_description AS redaction_list_description_2, r0_.is_public AS is_public_3, r0_.is_web_based AS is_web_based_4, r0_.date_created AS date_created_5, r0_.wepages_count AS wepages_count_6, r0_.thumb_width AS thumb_width_7, r0_.thumb_height AS thumb_height_8, r0_.priority AS priority_9, r0_.user_id AS user_id_10, r0_.score AS score_11, r0_.css_class AS css_class_12 FROM redaction_list r0_ WHERE r0_.redaction_list_id = ? SELECT r0_.redaction_list_id AS redaction_list_id_0, r0_.redaction_list_name AS redaction_list_name_1, r0_.redaction_list_description AS redaction_list_description_2, r0_.is_public AS is_public_3, r0_.is_web_based AS is_web_based_4, r0_.date_created AS date_created_5, r0_.wepages_count AS wepages_count_6, r0_.thumb_width AS thumb_width_7, r0_.thumb_height AS thumb_height_8, r0_.priority AS priority_9, r0_.user_id AS user_id_10, r0_.score AS score_11, r0_.css_class AS css_class_12 FROM redaction_list r0_ WHERE r0_.redaction_list_id = 1;
2	0.05 ms	SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id WHERE redaction_list_webpage.redaction_list_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id WHERE redaction_list_webpage.redaction_list_id = ? SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id WHERE redaction_list_webpage.redaction_list_id = 1;
3	3.57 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"2" "en_US" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '2' AND w0_.locale = 'en_US' AND w0_.object_class = 'App\\Entity\\WebPage';
4	0.04 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"4" "en_US" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '4' AND w0_.locale = 'en_US' AND w0_.object_class = 'App\\Entity\\WebPage';
5	0.03 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"5" "en_US" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '5' AND w0_.locale = 'en_US' AND w0_.object_class = 'App\\Entity\\WebPage';
6	0.04 ms	SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = 5;
7	0.04 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"5" "en" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '5' AND w0_.locale = 'en' AND w0_.object_class = 'App\\Entity\\WebPage';
8	0.04 ms	SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = 4;
9	0.04 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"4" "en" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '4' AND w0_.locale = 'en' AND w0_.object_class = 'App\\Entity\\WebPage';
10	0.04 ms	SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ? SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = 2;
11	0.03 ms	SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? Parameters: [`"2" "en" "App\Entity\WebPage"`] View formatted query View runnable query Explain query SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ? SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '2' AND w0_.locale = 'en' AND w0_.object_class = 'App\\Entity\\WebPage';

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\Department	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
App\Entity\DepartmentTranslation	No errors.
App\Entity\Server	No errors.
App\Entity\ShoppingWindow	No errors.
App\Entity\Product	No errors.
App\Entity\User	No errors.
App\Entity\Service	No errors.
App\Entity\Module	No errors.

dynamic_em entity manager

Class	Mapping errors
App\Entity\RedactionList	No errors.
App\Entity\WebPage	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
App\Entity\WebPageTranslation	No errors.

eshop_em entity manager

No loaded entities.

eshop_demo_em entity manager

No loaded entities.

Symfony Profiler

https://www.virtualrealitycommerce.org/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

dynamic_conn connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

dynamic_em entity manager

eshop_em entity manager

eshop_demo_em entity manager