1
0.39 ms
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
2
0.27 ms
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
3
0.37 ms
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
4
2917.41 ms
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 :
[
"ochrana-pri-praci-s-laserem "
]
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 ) = 'ochrana-pri-praci-s-laserem' ;
Copy
5
0.40 ms
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 = 20 ;
Copy
6
3017.99 ms
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 :
[
"ochrana-pri-praci-s-laserem "
]
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 ) = 'ochrana-pri-praci-s-laserem' ;
Copy
7
0.45 ms
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
8
48.33 ms
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
9
0.49 ms
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 = '1' ;
Copy
10
42.08 ms
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 = 1 ORDER BY c8_ . sequence ASC ;
Copy
11
0.71 ms
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
12
0.48 ms
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 :
[
"2143 "
"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 = '2143' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
13
0.43 ms
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 :
[
"2128 "
"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 = '2128' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
14
0.44 ms
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 :
[
"2129 "
"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 = '2129' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
15
0.44 ms
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
16
96.74 ms
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
17
36.07 ms
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
18
0.49 ms
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 = 2143 ;
Copy
19
140.69 ms
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
20
0.53 ms
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 = 2128 ;
Copy
21
53.66 ms
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
2128
2128
5
]
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 < > 2128 AND p10_ . category_super_id = 2128 AND s8_ . id = 5 ORDER BY p10_ . sequence ASC , p0_ . sequence ASC ;
Copy
22
0.54 ms
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 :
[
"2131 "
"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 = '2131' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
23
0.44 ms
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 :
[
"2132 "
"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 = '2132' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
24
0.44 ms
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 :
[
"2134 "
"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 = '2134' AND e0_ . locale = 'en' AND e0_ . object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' ;
Copy
25
0.50 ms
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 = 2129 ;
Copy
26
0.97 ms
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 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 p7_ . category_super_id = ? ORDER BY p7_ . 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 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 p7_ . category_super_id = 3835 ORDER BY p7_ . sequence ASC ;
Copy
27
0.33 ms
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 = 3835 ORDER BY t0 . sequence ASC ;
Copy
28
0.65 ms
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 (3835 )) AND (p0_ . is_active = true ) ORDER BY p0_ . sequence ASC ;
Copy
29
1.10 ms
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 :
[
3835
3835
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 = 3835 OR p8_ . category_sub_id = 3835 ) AND p0_ . category_type_id = 11 AND p0_ . is_active = 1 ;
Copy
30
0.45 ms
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 = 5 AND c2_ . category_id = 3835 ORDER BY c2_ . sequence ASC ;
Copy
31
0.42 ms
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 = '3835' LIMIT 1 ;
Copy
32
0.40 ms
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 = 3835 ORDER BY t0 . sequence ASC ;
Copy