5468.06 ms
2
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE COALESCE (t6_ . content , p0_ . slug ) = ?
Parameters :
[
"studium-vlastnosti-perovskitu "
]
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE COALESCE (t6_ . content , p0_ . slug ) = 'studium-vlastnosti-perovskitu' ; Copy
109.82 ms
2
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p10_ . category_super_id = ? AND s8_ . id = ? ORDER BY p10_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2143
2143
3
]
SELECT
p0_ . id AS id_0 ,
COALESCE (t1_ . content , p0_ . name ) AS name_1 ,
COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 ,
COALESCE (t3_ . content , p0_ . description ) AS description_3 ,
COALESCE (t4_ . content , p0_ . html ) AS html_4 ,
COALESCE (t5_ . content , p0_ . title ) AS title_5 ,
p0_ . is_active AS is_active_6 ,
COALESCE (t6_ . content , p0_ . slug ) AS slug_7 ,
p0_ . javascript AS javascript_8 ,
p0_ . sequence AS sequence_9 ,
p0_ . is_menu AS is_menu_10 ,
p0_ . latitude AS latitude_11 ,
p0_ . longitude AS longitude_12 ,
p0_ . state AS state_13 ,
p0_ . has_comments AS has_comments_14 ,
p0_ . is_indexable AS is_indexable_15 ,
p0_ . created_at AS created_at_16 ,
p0_ . published_at AS published_at_17 ,
u7_ . id AS id_18 ,
u7_ . name AS name_19 ,
u7_ . extension AS extension_20 ,
u7_ . mime AS mime_21 ,
u7_ . title AS title_22 ,
u7_ . short_description AS short_description_23 ,
u7_ . description AS description_24 ,
u7_ . created AS created_25 ,
u7_ . path AS path_26 ,
u7_ . original_name AS original_name_27 ,
u7_ . width AS width_28 ,
u7_ . height AS height_29 ,
u7_ . sequence AS sequence_30 ,
u7_ . restriction AS restriction_31 ,
p0_ . category_type_id AS category_type_id_32 ,
p0_ . upload_id AS upload_id_33 ,
u7_ . upload_group_id AS upload_group_id_34 ,
u7_ . upload_type_id AS upload_type_id_35
FROM
p_category p0_
LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id
LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id
LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id
LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'name'
AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t1_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'menu_name'
AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t2_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'description'
AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t3_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'html'
AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t4_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'title'
AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t5_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'slug'
AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t6_ . foreign_key = p0_ . id
WHERE
p0_ . is_active = ?
AND p0_ . id > = ?
AND p0_ . id < > ?
AND p10_ . category_super_id = ?
AND s8_ . id = ?
ORDER BY
p10_ . sequence ASC ,
p0_ . sequence ASC Copy
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2143 AND p10_ . category_super_id = 2143 AND s8_ . id = 3 ORDER BY p10_ . sequence ASC , p0_ . sequence ASC ; Copy
84.13 ms
2
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_ . id = p7_ . category_sub_id LEFT JOIN category_menu_type c8_ ON p0_ . id = c8_ . category_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p7_ . id IS NULL AND c8_ . menu_type_id = ? ORDER BY c8_ . sequence ASC
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_ . id = p7_ . category_sub_id LEFT JOIN category_menu_type c8_ ON p0_ . id = c8_ . category_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p7_ . id IS NULL AND c8_ . menu_type_id = 4 ORDER BY c8_ . sequence ASC ; Copy
82.31 ms
1
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p10_ . category_super_id = ? AND s8_ . id = ? AND p0_ . category_type_id IN (? ) ORDER BY p10_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2141
2141
1
2
]
SELECT
p0_ . id AS id_0 ,
COALESCE (t1_ . content , p0_ . name ) AS name_1 ,
COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 ,
COALESCE (t3_ . content , p0_ . description ) AS description_3 ,
COALESCE (t4_ . content , p0_ . html ) AS html_4 ,
COALESCE (t5_ . content , p0_ . title ) AS title_5 ,
p0_ . is_active AS is_active_6 ,
COALESCE (t6_ . content , p0_ . slug ) AS slug_7 ,
p0_ . javascript AS javascript_8 ,
p0_ . sequence AS sequence_9 ,
p0_ . is_menu AS is_menu_10 ,
p0_ . latitude AS latitude_11 ,
p0_ . longitude AS longitude_12 ,
p0_ . state AS state_13 ,
p0_ . has_comments AS has_comments_14 ,
p0_ . is_indexable AS is_indexable_15 ,
p0_ . created_at AS created_at_16 ,
p0_ . published_at AS published_at_17 ,
u7_ . id AS id_18 ,
u7_ . name AS name_19 ,
u7_ . extension AS extension_20 ,
u7_ . mime AS mime_21 ,
u7_ . title AS title_22 ,
u7_ . short_description AS short_description_23 ,
u7_ . description AS description_24 ,
u7_ . created AS created_25 ,
u7_ . path AS path_26 ,
u7_ . original_name AS original_name_27 ,
u7_ . width AS width_28 ,
u7_ . height AS height_29 ,
u7_ . sequence AS sequence_30 ,
u7_ . restriction AS restriction_31 ,
p0_ . category_type_id AS category_type_id_32 ,
p0_ . upload_id AS upload_id_33 ,
u7_ . upload_group_id AS upload_group_id_34 ,
u7_ . upload_type_id AS upload_type_id_35
FROM
p_category p0_
LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id
LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id
LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id
LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'name'
AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t1_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'menu_name'
AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t2_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'description'
AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t3_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'html'
AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t4_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'title'
AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t5_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'slug'
AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t6_ . foreign_key = p0_ . id
WHERE
p0_ . is_active = ?
AND p0_ . id > = ?
AND p0_ . id < > ?
AND p10_ . category_super_id = ?
AND s8_ . id = ?
AND p0_ . category_type_id IN (? )
ORDER BY
p10_ . sequence ASC ,
p0_ . sequence ASC Copy
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2141 AND p10_ . category_super_id = 2141 AND s8_ . id = 1 AND p0_ . category_type_id IN (2 ) ORDER BY p10_ . sequence ASC , p0_ . sequence ASC ; Copy
57.31 ms
1
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . title ) AS title_3 , COALESCE (t4_ . content , p0_ . description ) AS description_4 , COALESCE (t5_ . content , p0_ . html ) AS html_5 , p0_ . is_menu AS is_menu_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . upload_id AS upload_id_8 FROM producer p0_ INNER JOIN product p7_ ON p0_ . id = p7_ . producer_id AND (p7_ . is_active = true ) INNER JOIN category_product c15_ ON p7_ . id = c15_ . product_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'title' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'description' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'html' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t6_ . foreign_key = p0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'name' AND t8_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t8_ . foreign_key = p7_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'menu_name' AND t9_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t9_ . foreign_key = p7_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'description' AND t10_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t10_ . foreign_key = p7_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'title' AND t11_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t11_ . foreign_key = p7_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'slug' AND t12_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t12_ . foreign_key = p7_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'textGeneral' AND t13_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t13_ . foreign_key = p7_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'metaDescription' AND t14_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t14_ . foreign_key = p7_ . id WHERE c15_ . category_id IN (? ) AND p7_ . is_active = 1
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . title ) AS title_3 , COALESCE (t4_ . content , p0_ . description ) AS description_4 , COALESCE (t5_ . content , p0_ . html ) AS html_5 , p0_ . is_menu AS is_menu_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . upload_id AS upload_id_8 FROM producer p0_ INNER JOIN product p7_ ON p0_ . id = p7_ . producer_id AND (p7_ . is_active = true ) INNER JOIN category_product c15_ ON p7_ . id = c15_ . product_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'title' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'description' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'html' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND t6_ . foreign_key = p0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'name' AND t8_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t8_ . foreign_key = p7_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'menu_name' AND t9_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t9_ . foreign_key = p7_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'description' AND t10_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t10_ . foreign_key = p7_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'title' AND t11_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t11_ . foreign_key = p7_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'slug' AND t12_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t12_ . foreign_key = p7_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'textGeneral' AND t13_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t13_ . foreign_key = p7_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'metaDescription' AND t14_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t14_ . foreign_key = p7_ . id WHERE c15_ . category_id IN (322 ) AND p7_ . is_active = 1 ; Copy
36.21 ms
1
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . id IN (? , ? , ? , ? , ? )
Parameters :
[
1054
1103
1054
1045
1054
]
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . id IN (1054 , 1103 , 1054 , 1045 , 1054 ); Copy
35.97 ms
1
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p10_ . category_super_id = ? AND s8_ . id = ? AND p0_ . category_type_id NOT IN (? ) ORDER BY p10_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2141
2141
1
2
]
SELECT
p0_ . id AS id_0 ,
COALESCE (t1_ . content , p0_ . name ) AS name_1 ,
COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 ,
COALESCE (t3_ . content , p0_ . description ) AS description_3 ,
COALESCE (t4_ . content , p0_ . html ) AS html_4 ,
COALESCE (t5_ . content , p0_ . title ) AS title_5 ,
p0_ . is_active AS is_active_6 ,
COALESCE (t6_ . content , p0_ . slug ) AS slug_7 ,
p0_ . javascript AS javascript_8 ,
p0_ . sequence AS sequence_9 ,
p0_ . is_menu AS is_menu_10 ,
p0_ . latitude AS latitude_11 ,
p0_ . longitude AS longitude_12 ,
p0_ . state AS state_13 ,
p0_ . has_comments AS has_comments_14 ,
p0_ . is_indexable AS is_indexable_15 ,
p0_ . created_at AS created_at_16 ,
p0_ . published_at AS published_at_17 ,
u7_ . id AS id_18 ,
u7_ . name AS name_19 ,
u7_ . extension AS extension_20 ,
u7_ . mime AS mime_21 ,
u7_ . title AS title_22 ,
u7_ . short_description AS short_description_23 ,
u7_ . description AS description_24 ,
u7_ . created AS created_25 ,
u7_ . path AS path_26 ,
u7_ . original_name AS original_name_27 ,
u7_ . width AS width_28 ,
u7_ . height AS height_29 ,
u7_ . sequence AS sequence_30 ,
u7_ . restriction AS restriction_31 ,
p0_ . category_type_id AS category_type_id_32 ,
p0_ . upload_id AS upload_id_33 ,
u7_ . upload_group_id AS upload_group_id_34 ,
u7_ . upload_type_id AS upload_type_id_35
FROM
p_category p0_
LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id
LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id
LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id
LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'name'
AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t1_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'menu_name'
AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t2_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'description'
AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t3_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'html'
AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t4_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'title'
AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t5_ . foreign_key = p0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'slug'
AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
AND t6_ . foreign_key = p0_ . id
WHERE
p0_ . is_active = ?
AND p0_ . id > = ?
AND p0_ . id < > ?
AND p10_ . category_super_id = ?
AND s8_ . id = ?
AND p0_ . category_type_id NOT IN (? )
ORDER BY
p10_ . sequence ASC ,
p0_ . sequence ASC Copy
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u7_ . id AS id_18 , u7_ . name AS name_19 , u7_ . extension AS extension_20 , u7_ . mime AS mime_21 , u7_ . title AS title_22 , u7_ . short_description AS short_description_23 , u7_ . description AS description_24 , u7_ . created AS created_25 , u7_ . path AS path_26 , u7_ . original_name AS original_name_27 , u7_ . width AS width_28 , u7_ . height AS height_29 , u7_ . sequence AS sequence_30 , u7_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u7_ . upload_group_id AS upload_group_id_34 , u7_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u7_ ON p0_ . upload_id = u7_ . id LEFT JOIN category_sub_menu_type c9_ ON p0_ . id = c9_ . category_id LEFT JOIN sub_menu_type s8_ ON s8_ . id = c9_ . sub_menu_type_id LEFT JOIN p_category_category p10_ ON p0_ . id = p10_ . category_sub_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2141 AND p10_ . category_super_id = 2141 AND s8_ . id = 1 AND p0_ . category_type_id NOT IN (2 ) ORDER BY p10_ . sequence ASC , p0_ . sequence ASC ; Copy
10.21 ms
33
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"2141 "
"en "
"Greendot\EshopBundle\Entity\Project\Category "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '2141' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ; Copy
3.93 ms
3
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_ . id = p7_ . category_sub_id LEFT JOIN p_category_category p8_ ON p0_ . id = p8_ . category_super_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE (p7_ . category_super_id = ? OR p8_ . category_sub_id = ? ) AND p0_ . category_type_id = ? AND p0_ . is_active = 1
Parameters :
[
322
322
11
]
SELECT p0_ . id AS id_0 , COALESCE (t1_ . content , p0_ . name ) AS name_1 , COALESCE (t2_ . content , p0_ . menu_name ) AS menu_name_2 , COALESCE (t3_ . content , p0_ . description ) AS description_3 , COALESCE (t4_ . content , p0_ . html ) AS html_4 , COALESCE (t5_ . content , p0_ . title ) AS title_5 , p0_ . is_active AS is_active_6 , COALESCE (t6_ . content , p0_ . slug ) AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_ . id = p7_ . category_sub_id LEFT JOIN p_category_category p8_ ON p0_ . id = p8_ . category_super_id LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'name' AND t1_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_ . foreign_key = p0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'menu_name' AND t2_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_ . foreign_key = p0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'description' AND t3_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_ . foreign_key = p0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'html' AND t4_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_ . foreign_key = p0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'title' AND t5_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_ . foreign_key = p0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'slug' AND t6_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_ . foreign_key = p0_ . id WHERE (p7_ . category_super_id = 322 OR p8_ . category_sub_id = 322 ) AND p0_ . category_type_id = 11 AND p0_ . is_active = 1 ; Copy
3.50 ms
12
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . extension AS extension_3 , t0 . mime AS mime_4 , t0 . title AS title_5 , t0 . short_description AS short_description_6 , t0 . description AS description_7 , t0 . created AS created_8 , t0 . path AS path_9 , t0 . original_name AS original_name_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . sequence AS sequence_13 , t0 . restriction AS restriction_14 , t0 . upload_group_id AS upload_group_id_15 , t0 . upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . extension AS extension_3 , t0 . mime AS mime_4 , t0 . title AS title_5 , t0 . short_description AS short_description_6 , t0 . description AS description_7 , t0 . created AS created_8 , t0 . path AS path_9 , t0 . original_name AS original_name_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . sequence AS sequence_13 , t0 . restriction AS restriction_14 , t0 . upload_group_id AS upload_group_id_15 , t0 . upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0 . id = 66005 ; Copy
2.85 ms
8
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . vat AS vat_2 , p0_ . minimal_amount AS minimal_amount_3 , p0_ . discount AS discount_4 , p0_ . valid_from AS valid_from_5 , p0_ . valid_until AS valid_until_6 , p0_ . created AS created_7 , p0_ . is_package AS is_package_8 , p0_ . min_price AS min_price_9 , p0_ . product_variant_id AS product_variant_id_10 , p0_ . event_id AS event_id_11 FROM price p0_ WHERE p0_ . product_variant_id = ? AND p0_ . valid_from < = ? AND (p0_ . valid_until > = ? OR p0_ . valid_until IS NULL ) ORDER BY p0_ . minimal_amount ASC LIMIT 1
Parameters :
[
35
"2026-02-27 21:22:05 "
"2026-02-27 21:22:05 "
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . vat AS vat_2 , p0_ . minimal_amount AS minimal_amount_3 , p0_ . discount AS discount_4 , p0_ . valid_from AS valid_from_5 , p0_ . valid_until AS valid_until_6 , p0_ . created AS created_7 , p0_ . is_package AS is_package_8 , p0_ . min_price AS min_price_9 , p0_ . product_variant_id AS product_variant_id_10 , p0_ . event_id AS event_id_11 FROM price p0_ WHERE p0_ . product_variant_id = 35 AND p0_ . valid_from < = '2026-02-27 21:22:05' AND (p0_ . valid_until > = '2026-02-27 21:22:05' OR p0_ . valid_until IS NULL ) ORDER BY p0_ . minimal_amount ASC LIMIT 1 ; Copy
2.64 ms
8
SELECT c0_ . id AS id_0 , c0_ . created AS created_1 , c0_ . valid_from AS valid_from_2 , c0_ . rate AS rate_3 , c0_ . currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_ . currency_id = ? AND c0_ . valid_from < = ? ORDER BY c0_ . valid_from DESC LIMIT 1
Parameters :
[
1
"2026-02-27 21:22:05 "
]
SELECT c0_ . id AS id_0 , c0_ . created AS created_1 , c0_ . valid_from AS valid_from_2 , c0_ . rate AS rate_3 , c0_ . currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_ . currency_id = 1 AND c0_ . valid_from < = '2026-02-27 21:22:05' ORDER BY c0_ . valid_from DESC LIMIT 1 ; Copy
2.41 ms
8
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . vat AS vat_3 , t0 . minimal_amount AS minimal_amount_4 , t0 . discount AS discount_5 , t0 . valid_from AS valid_from_6 , t0 . valid_until AS valid_until_7 , t0 . created AS created_8 , t0 . is_package AS is_package_9 , t0 . min_price AS min_price_10 , t0 . product_variant_id AS product_variant_id_11 , t0 . event_id AS event_id_12 , t13 . id AS id_14 , t13 . amount AS amount_15 , t13 . state AS state_16 , t13 . delivery_from AS delivery_from_17 , t13 . delivery_until AS delivery_until_18 , t13 . purchase_id AS purchase_id_19 , t13 . product_variant_id AS product_variant_id_20 , t13 . price_id AS price_id_21 FROM price t0 LEFT JOIN purchase_product_variant t13 ON t13 . price_id = t0 . id WHERE t0 . product_variant_id = ?
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . vat AS vat_3 , t0 . minimal_amount AS minimal_amount_4 , t0 . discount AS discount_5 , t0 . valid_from AS valid_from_6 , t0 . valid_until AS valid_until_7 , t0 . created AS created_8 , t0 . is_package AS is_package_9 , t0 . min_price AS min_price_10 , t0 . product_variant_id AS product_variant_id_11 , t0 . event_id AS event_id_12 , t13 . id AS id_14 , t13 . amount AS amount_15 , t13 . state AS state_16 , t13 . delivery_from AS delivery_from_17 , t13 . delivery_until AS delivery_until_18 , t13 . purchase_id AS purchase_id_19 , t13 . product_variant_id AS product_variant_id_20 , t13 . price_id AS price_id_21 FROM price t0 LEFT JOIN purchase_product_variant t13 ON t13 . price_id = t0 . id WHERE t0 . product_variant_id = 35 ; Copy
1.89 ms
8
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0 ; Copy
1.72 ms
6
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . unit AS unit_3 , t0 . class AS class_4 , t0 . is_filter AS is_filter_5 , t0 . type_id AS type_id_6 , t0 . parameter_group_filter_type_id AS parameter_group_filter_type_id_7 , t0 . parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . unit AS unit_3 , t0 . class AS class_4 , t0 . is_filter AS is_filter_5 , t0 . type_id AS type_id_6 , t0 . parameter_group_filter_type_id AS parameter_group_filter_type_id_7 , t0 . parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0 . id = 35 ; Copy
1.51 ms
4
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = 2141 ; Copy
1.42 ms
5
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . stock AS stock_3 , t0 . external_id AS external_id_4 , t0 . avg_restock_days AS avg_restock_days_5 , t0 . expected_restock_date AS expected_restock_date_6 , t0 . is_active AS is_active_7 , t0 . product_id AS product_id_8 , t0 . availability_id AS availability_id_9 , t0 . upload_id AS upload_id_10 FROM product_variant t0 WHERE t0 . product_id = ? AND ((t0 . is_active = true ))
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . stock AS stock_3 , t0 . external_id AS external_id_4 , t0 . avg_restock_days AS avg_restock_days_5 , t0 . expected_restock_date AS expected_restock_date_6 , t0 . is_active AS is_active_7 , t0 . product_id AS product_id_8 , t0 . availability_id AS availability_id_9 , t0 . upload_id AS upload_id_10 FROM product_variant t0 WHERE t0 . product_id = 55935 AND ((t0 . is_active = true )); Copy
1.08 ms
4
SELECT t0 . id AS id_1 , t0 . data AS data_2 , t0 . sequence AS sequence_3 , t0 . parameter_group_id AS parameter_group_id_4 , t0 . category_id AS category_id_5 , t0 . product_variant_id AS product_variant_id_6 , t0 . person_id AS person_id_7 FROM parameter t0 WHERE t0 . product_variant_id = ?
SELECT t0 . id AS id_1 , t0 . data AS data_2 , t0 . sequence AS sequence_3 , t0 . parameter_group_id AS parameter_group_id_4 , t0 . category_id AS category_id_5 , t0 . product_variant_id AS product_variant_id_6 , t0 . person_id AS person_id_7 FROM parameter t0 WHERE t0 . product_variant_id = 35 ; Copy
1.03 ms
4
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . class AS class_3 , a0_ . is_purchasable AS is_purchasable_4 , a0_ . sequence AS sequence_5 FROM availability a0_ WHERE a0_ . is_purchasable = 1 ORDER BY a0_ . sequence DESC LIMIT 1
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . class AS class_3 , a0_ . is_purchasable AS is_purchasable_4 , a0_ . sequence AS sequence_5 FROM availability a0_ WHERE a0_ . is_purchasable = 1 ORDER BY a0_ . sequence DESC LIMIT 1 ; Copy
0.85 ms
3
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_sub_id = ? ORDER BY t0 . sequence ASC
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_sub_id = 322 ORDER BY t0 . sequence ASC ; Copy
0.76 ms
2
SELECT i0_ . id AS id_0 , i0_ . name AS name_1 , i0_ . title AS title_2 , i0_ . text AS text_3 , i0_ . is_active AS is_active_4 , i0_ . state AS state_5 , i0_ . is_reusable AS is_reusable_6 , i0_ . information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_ . information_block_type_id = i1_ . id LEFT JOIN category_information_block c2_ ON i0_ . id = c2_ . information_block_id WHERE i0_ . is_active = ? AND i1_ . id = ? AND c2_ . category_id = ? ORDER BY c2_ . sequence ASC
SELECT i0_ . id AS id_0 , i0_ . name AS name_1 , i0_ . title AS title_2 , i0_ . text AS text_3 , i0_ . is_active AS is_active_4 , i0_ . state AS state_5 , i0_ . is_reusable AS is_reusable_6 , i0_ . information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_ . information_block_type_id = i1_ . id LEFT JOIN category_information_block c2_ ON i0_ . id = c2_ . information_block_id WHERE i0_ . is_active = 1 AND i1_ . id = 4 AND c2_ . category_id = 322 ORDER BY c2_ . sequence ASC ; Copy
0.73 ms
1
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . title AS title_4 , p0_ . slug AS slug_5 , p0_ . is_active AS is_active_6 , p0_ . is_visible AS is_visible_7 , p0_ . sequence AS sequence_8 , p0_ . javascript AS javascript_9 , p0_ . text_general AS text_general_10 , p0_ . state AS state_11 , p0_ . external_id AS external_id_12 , p0_ . is_indexable AS is_indexable_13 , p0_ . meta_description AS meta_description_14 , p0_ . has_variant_picture AS has_variant_picture_15 , p0_ . sold_amount AS sold_amount_16 , p0_ . producer_id AS producer_id_17 , p0_ . upload_id AS upload_id_18 , p0_ . product_type_id AS product_type_id_19 , p0_ . product_view_type_id AS product_view_type_id_20 FROM product p0_ INNER JOIN category_product c1_ ON p0_ . id = c1_ . product_id WHERE (p0_ . is_active = ? AND c1_ . category_id IN (? )) AND (p0_ . is_active = true ) ORDER BY p0_ . sequence ASC
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . title AS title_4 , p0_ . slug AS slug_5 , p0_ . is_active AS is_active_6 , p0_ . is_visible AS is_visible_7 , p0_ . sequence AS sequence_8 , p0_ . javascript AS javascript_9 , p0_ . text_general AS text_general_10 , p0_ . state AS state_11 , p0_ . external_id AS external_id_12 , p0_ . is_indexable AS is_indexable_13 , p0_ . meta_description AS meta_description_14 , p0_ . has_variant_picture AS has_variant_picture_15 , p0_ . sold_amount AS sold_amount_16 , p0_ . producer_id AS producer_id_17 , p0_ . upload_id AS upload_id_18 , p0_ . product_type_id AS product_type_id_19 , p0_ . product_view_type_id AS product_view_type_id_20 FROM product p0_ INNER JOIN category_product c1_ ON p0_ . id = c1_ . product_id WHERE (p0_ . is_active = 1 AND c1_ . category_id IN (322 )) AND (p0_ . is_active = true ) ORDER BY p0_ . sequence ASC ; Copy
0.70 ms
2
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = '4' ; Copy
0.41 ms
1
SELECT c0_ . category_id AS sclr_0 FROM category_product c0_ LEFT JOIN product p1_ ON c0_ . product_id = p1_ . id AND (p1_ . is_active = true ) LEFT JOIN p_category p2_ ON c0_ . category_id = p2_ . id WHERE c0_ . product_id IN (262 , 3 , 120 , 118 , 48 , 55935 ) AND ? NOT IN (c0_ . category_id ) AND p2_ . is_active = 1 AND p1_ . is_active = 1 AND p2_ . category_type_id IN (? )
SELECT c0_ . category_id AS sclr_0 FROM category_product c0_ LEFT JOIN product p1_ ON c0_ . product_id = p1_ . id AND (p1_ . is_active = true ) LEFT JOIN p_category p2_ ON c0_ . category_id = p2_ . id WHERE c0_ . product_id IN (262 , 3 , 120 , 118 , 48 , 55935 ) AND 322 NOT IN (c0_ . category_id ) AND p2_ . is_active = 1 AND p1_ . is_active = 1 AND p2_ . category_type_id IN (2 ); Copy
0.36 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . department AS department_4 , t0 . email AS email_5 , t0 . phone AS phone_6 , t0 . room AS room_7 , t0 . user_id AS user_id_8 , t0 . title_before AS title_before_9 , t0 . title_after AS title_after_10 , t0 . description AS description_11 , t0 . slug AS slug_12 , t0 . is_active AS is_active_13 , t0 . html AS html_14 , t0 . upload_id AS upload_id_15 FROM person t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . department AS department_4 , t0 . email AS email_5 , t0 . phone AS phone_6 , t0 . room AS room_7 , t0 . user_id AS user_id_8 , t0 . title_before AS title_before_9 , t0 . title_after AS title_after_10 , t0 . description AS description_11 , t0 . slug AS slug_12 , t0 . is_active AS is_active_13 , t0 . html AS html_14 , t0 . upload_id AS upload_id_15 FROM person t0 WHERE t0 . id = 38 ; Copy
0.36 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . html AS html_5 , t0 . title AS title_6 , t0 . is_active AS is_active_7 , t0 . slug AS slug_8 , t0 . javascript AS javascript_9 , t0 . sequence AS sequence_10 , t0 . is_menu AS is_menu_11 , t0 . latitude AS latitude_12 , t0 . longitude AS longitude_13 , t0 . state AS state_14 , t0 . has_comments AS has_comments_15 , t0 . is_indexable AS is_indexable_16 , t0 . created_at AS created_at_17 , t0 . published_at AS published_at_18 , t0 . category_type_id AS category_type_id_19 , t0 . upload_id AS upload_id_20 FROM p_category t0 WHERE t0 . id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . html AS html_5 , t0 . title AS title_6 , t0 . is_active AS is_active_7 , t0 . slug AS slug_8 , t0 . javascript AS javascript_9 , t0 . sequence AS sequence_10 , t0 . is_menu AS is_menu_11 , t0 . latitude AS latitude_12 , t0 . longitude AS longitude_13 , t0 . state AS state_14 , t0 . has_comments AS has_comments_15 , t0 . is_indexable AS is_indexable_16 , t0 . created_at AS created_at_17 , t0 . published_at AS published_at_18 , t0 . category_type_id AS category_type_id_19 , t0 . upload_id AS upload_id_20 FROM p_category t0 WHERE t0 . id = '322' LIMIT 1 ; Copy
0.35 ms
1
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . symbol AS symbol_2 , c0_ . rounding AS rounding_3 , c0_ . is_default AS is_default_4 , c0_ . default_locale AS default_locale_5 , c0_ . is_symbol_left AS is_symbol_left_6 , c0_ . is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_ . default_locale = ? LIMIT 1
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . symbol AS symbol_2 , c0_ . rounding AS rounding_3 , c0_ . is_default AS is_default_4 , c0_ . default_locale AS default_locale_5 , c0_ . is_symbol_left AS is_symbol_left_6 , c0_ . is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_ . default_locale = 'en' LIMIT 1 ; Copy
0.35 ms
1
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_super_id = ? ORDER BY t0 . sequence ASC
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_super_id = 322 ORDER BY t0 . sequence ASC ; Copy
0.33 ms
1
SELECT c0_ . category_id AS sclr_0 FROM category_product c0_ WHERE c0_ . product_id IN (262 , 3 , 120 , 118 , 48 , 55935 ) AND ? NOT IN (c0_ . category_id )
SELECT c0_ . category_id AS sclr_0 FROM category_product c0_ WHERE c0_ . product_id IN (262 , 3 , 120 , 118 , 48 , 55935 ) AND 322 NOT IN (c0_ . category_id ); Copy
0.32 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . title AS title_5 , t0 . slug AS slug_6 , t0 . is_active AS is_active_7 , t0 . is_visible AS is_visible_8 , t0 . sequence AS sequence_9 , t0 . javascript AS javascript_10 , t0 . text_general AS text_general_11 , t0 . state AS state_12 , t0 . external_id AS external_id_13 , t0 . is_indexable AS is_indexable_14 , t0 . meta_description AS meta_description_15 , t0 . has_variant_picture AS has_variant_picture_16 , t0 . sold_amount AS sold_amount_17 , t0 . producer_id AS producer_id_18 , t0 . upload_id AS upload_id_19 , t0 . product_type_id AS product_type_id_20 , t0 . product_view_type_id AS product_view_type_id_21 FROM product t0 WHERE t0 . id IS NULL AND ((t0 . is_active = true )) LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . title AS title_5 , t0 . slug AS slug_6 , t0 . is_active AS is_active_7 , t0 . is_visible AS is_visible_8 , t0 . sequence AS sequence_9 , t0 . javascript AS javascript_10 , t0 . text_general AS text_general_11 , t0 . state AS state_12 , t0 . external_id AS external_id_13 , t0 . is_indexable AS is_indexable_14 , t0 . meta_description AS meta_description_15 , t0 . has_variant_picture AS has_variant_picture_16 , t0 . sold_amount AS sold_amount_17 , t0 . producer_id AS producer_id_18 , t0 . upload_id AS upload_id_19 , t0 . product_type_id AS product_type_id_20 , t0 . product_view_type_id AS product_view_type_id_21 FROM product t0 WHERE t0 . id IS NULL AND ((t0 . is_active = true )) LIMIT 1 ; Copy
0.31 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . slug_prefix AS slug_prefix_4 , t0 . controller_name AS controller_name_5 FROM category_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . slug_prefix AS slug_prefix_4 , t0 . controller_name AS controller_name_5 FROM category_type t0 WHERE t0 . id = 10 ; Copy
0.31 ms
1
SELECT c0_ . product_id AS sclr_0 FROM p_category p1_ LEFT JOIN category_product c0_ ON p1_ . id = c0_ . category_id WHERE p1_ . id = ?
SELECT c0_ . product_id AS sclr_0 FROM p_category p1_ LEFT JOIN category_product c0_ ON p1_ . id = c0_ . category_id WHERE p1_ . id = 322 ; Copy
0.31 ms
1
SELECT s0_ . value AS value_0 FROM settings s0_ WHERE s0_ . name = ? ORDER BY s0_ . name ASC LIMIT 1
Parameters :
[
"after_registration_discount "
]
SELECT s0_ . value AS value_0 FROM settings s0_ WHERE s0_ . name = 'after_registration_discount' ORDER BY s0_ . name ASC LIMIT 1 ; Copy
0.28 ms
1
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_manager AS is_manager_3 , t0 . category_id AS category_id_4 , t0 . person_id AS person_id_5 FROM category_person t0 WHERE t0 . category_id = ? ORDER BY t0 . sequence ASC
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_manager AS is_manager_3 , t0 . category_id AS category_id_4 , t0 . person_id AS person_id_5 FROM category_person t0 WHERE t0 . category_id = 322 ORDER BY t0 . sequence ASC ; Copy
0.25 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . class AS class_4 , t0 . is_purchasable AS is_purchasable_5 , t0 . sequence AS sequence_6 FROM availability t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . class AS class_4 , t0 . is_purchasable AS is_purchasable_5 , t0 . sequence AS sequence_6 FROM availability t0 WHERE t0 . id = 1 ; Copy
0.22 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0 WHERE t0 . is_default = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0 WHERE t0 . is_default = 1 LIMIT 1 ; Copy