Query Metrics
141
Database Queries
18
Different statements
9.38 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.18 ms |
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.http_host = ? OR s0_.http_host = ?
Parameters:
[ "www.vrcommerce.cz" "www.www.vrcommerce.cz" ] |
2 | 0.12 ms |
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.label = ?
Parameters:
[
"vrcommerce.cz"
]
|
3 | 0.10 ms |
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[] |
4 | 0.11 ms |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_
Parameters:
[] |
5 | 0.08 ms |
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_ WHERE l0_.lang_id = ?
Parameters:
[
4
]
|
6 | 0.08 ms |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
4
]
|
7 | 0.10 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:
[] |
8 | 0.09 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" ] |
9 | 0.08 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\Department" ] |
10 | 0.07 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" ] |
11 | 0.07 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" ] |
12 | 0.07 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" ] |
13 | 0.07 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" ] |
14 | 0.07 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" ] |
15 | 0.07 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" ] |
16 | 0.07 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" ] |
17 | 0.07 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" ] |
18 | 0.07 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" ] |
19 | 0.07 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" ] |
20 | 0.08 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
]
|
21 | 0.09 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
]
|
22 | 0.08 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "20" "en_US" "App\Entity\Department" ] |
23 | 0.07 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" ] |
24 | 0.07 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" ] |
25 | 0.07 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" ] |
26 | 0.07 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" ] |
27 | 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:
[ "25" "en_US" "App\Entity\Department" ] |
28 | 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:
[ "26" "en_US" "App\Entity\Department" ] |
29 | 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:
[ "27" "en_US" "App\Entity\Department" ] |
30 | 0.07 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
]
|
31 | 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:
[
2
]
|
32 | 0.07 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" ] |
33 | 0.07 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" ] |
34 | 0.07 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" ] |
35 | 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:
[ "38" "en_US" "App\Entity\Department" ] |
36 | 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:
[ "39" "en_US" "App\Entity\Department" ] |
37 | 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:
[ "40" "en_US" "App\Entity\Department" ] |
38 | 0.07 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" ] |
39 | 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:
[ "42" "en_US" "App\Entity\Department" ] |
40 | 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:
[ "43" "en_US" "App\Entity\Department" ] |
41 | 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:
[ "53" "en_US" "App\Entity\Department" ] |
42 | 0.08 ms |
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[ "57" "en_US" "App\Entity\Department" ] |
43 | 0.07 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
]
|
44 | 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:
[
3
]
|
45 | 0.07 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" ] |
46 | 0.07 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" ] |
47 | 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:
[ "97" "en_US" "App\Entity\Department" ] |
48 | 0.07 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" ] |
49 | 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:
[ "99" "en_US" "App\Entity\Department" ] |
50 | 0.06 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
]
|
51 | 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:
[
4
]
|
52 | 0.07 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" ] |
53 | 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:
[ "108" "en_US" "App\Entity\Department" ] |
54 | 0.07 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" ] |
55 | 0.07 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" ] |
56 | 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:
[ "111" "en_US" "App\Entity\Department" ] |
57 | 0.06 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
]
|
58 | 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:
[
5
]
|
59 | 0.07 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" ] |
60 | 0.07 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" ] |
61 | 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:
[ "30" "en_US" "App\Entity\Department" ] |
62 | 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:
[ "31" "en_US" "App\Entity\Department" ] |
63 | 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:
[ "60" "en_US" "App\Entity\Department" ] |
64 | 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:
[ "91" "en_US" "App\Entity\Department" ] |
65 | 0.07 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
]
|
66 | 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:
[
6
]
|
67 | 0.07 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" ] |
68 | 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:
[ "61" "en_US" "App\Entity\Department" ] |
69 | 0.09 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" ] |
70 | 0.07 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" ] |
71 | 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:
[ "65" "en_US" "App\Entity\Department" ] |
72 | 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:
[ "66" "en_US" "App\Entity\Department" ] |
73 | 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:
[ "67" "en_US" "App\Entity\Department" ] |
74 | 0.07 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" ] |
75 | 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:
[ "69" "en_US" "App\Entity\Department" ] |
76 | 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:
[ "70" "en_US" "App\Entity\Department" ] |
77 | 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:
[ "71" "en_US" "App\Entity\Department" ] |
78 | 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:
[ "72" "en_US" "App\Entity\Department" ] |
79 | 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:
[ "73" "en_US" "App\Entity\Department" ] |
80 | 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:
[ "74" "en_US" "App\Entity\Department" ] |
81 | 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:
[ "75" "en_US" "App\Entity\Department" ] |
82 | 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:
[ "76" "en_US" "App\Entity\Department" ] |
83 | 0.06 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
]
|
84 | 0.07 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
]
|
85 | 0.07 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" ] |
86 | 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:
[ "101" "en_US" "App\Entity\Department" ] |
87 | 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:
[ "102" "en_US" "App\Entity\Department" ] |
88 | 0.07 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
]
|
89 | 0.07 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
]
|
90 | 0.07 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" ] |
91 | 0.07 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" ] |
92 | 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:
[ "114" "en_US" "App\Entity\Department" ] |
93 | 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:
[ "115" "en_US" "App\Entity\Department" ] |
94 | 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:
[ "116" "en_US" "App\Entity\Department" ] |
95 | 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:
[ "117" "en_US" "App\Entity\Department" ] |
96 | 0.06 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
]
|
97 | 0.07 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
]
|
98 | 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:
[ "32" "en_US" "App\Entity\Department" ] |
99 | 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:
[ "33" "en_US" "App\Entity\Department" ] |
100 | 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:
[ "34" "en_US" "App\Entity\Department" ] |
101 | 0.06 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
]
|
102 | 0.07 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
]
|
103 | 0.07 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" ] |
104 | 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:
[ "78" "en_US" "App\Entity\Department" ] |
105 | 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:
[ "79" "en_US" "App\Entity\Department" ] |
106 | 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:
[ "80" "en_US" "App\Entity\Department" ] |
107 | 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:
[ "81" "en_US" "App\Entity\Department" ] |
108 | 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:
[ "82" "en_US" "App\Entity\Department" ] |
109 | 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:
[ "83" "en_US" "App\Entity\Department" ] |
110 | 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" ] |
111 | 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:
[ "85" "en_US" "App\Entity\Department" ] |
112 | 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:
[ "86" "en_US" "App\Entity\Department" ] |
113 | 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:
[ "87" "en_US" "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:
[ "88" "en_US" "App\Entity\Department" ] |
115 | 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:
[ "89" "en_US" "App\Entity\Department" ] |
116 | 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:
[ "90" "en_US" "App\Entity\Department" ] |
117 | 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:
[ "92" "en_US" "App\Entity\Department" ] |
118 | 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:
[ "93" "en_US" "App\Entity\Department" ] |
119 | 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:
[ "94" "en_US" "App\Entity\Department" ] |
120 | 0.06 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
]
|
121 | 0.06 ms |
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
11
]
|
122 | 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:
[ "103" "en_US" "App\Entity\Department" ] |
123 | 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:
[ "104" "en_US" "App\Entity\Department" ] |
124 | 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:
[ "105" "en_US" "App\Entity\Department" ] |
125 | 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:
[ "106" "en_US" "App\Entity\Department" ] |
126 | 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:
[ "107" "en_US" "App\Entity\Department" ] |
127 | 0.06 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
]
|
128 | 0.07 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
]
|
129 | 0.07 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
]
|
130 | 0.12 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
]
|
131 | 0.07 ms |
SELECT t0.service_id AS service_id_1, t0.service_name AS service_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12 FROM service t0 INNER JOIN server_service ON t0.service_id = server_service.service_id WHERE server_service.server_id = ?
Parameters:
[
14
]
|
132 | 0.06 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
]
|
133 | 0.05 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
]
|
dynamic_conn connection
#▲ | Time | Info |
---|---|---|
1 | 0.05 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
]
|
2 | 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 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
]
|
3 | 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:
[ "2" "en_US" "App\Entity\WebPage" ] |
4 | 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:
[ "4" "en_US" "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" ] |
6 | 0.03 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
]
|
7 | 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
]
|
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:
[
2
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
dynamic_conn | doctrine.dbal.dynamic_conn_connection |
eshop_conn | doctrine.dbal.eshop_conn_connection |
eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
dynamic_em | doctrine.orm.dynamic_em_entity_manager |
eshop_em | doctrine.orm.eshop_em_entity_manager |
eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Server | No errors. |
App\Entity\Service | No errors. |
App\Entity\Language | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Department | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\DepartmentTranslation | No errors. |
App\Entity\ShoppingWindow | No errors. |
App\Entity\Product | No errors. |
App\Entity\Module | No errors. |
App\Entity\User | 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.