480.25 ms
(58.12%)
|
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_.title) AS title_4, COALESCE(t5_.content, 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, COALESCE(t6_.content, 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, COALESCE(t7_.content, 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_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' 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\\Product' 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\\Product' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'title' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'slug' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'textGeneral' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t6_.foreign_key = p0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'metaDescription' AND t7_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t7_.foreign_key = p0_.id WHERE (COALESCE(t5_.content, p0_.slug) = ?) AND (p0_.is_active = true)
Parameters: [
"ochranna-laserova-bunka"
]
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_.title) AS title_4, COALESCE(t5_.content, 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, COALESCE(t6_.content, 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, COALESCE(t7_.content, 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_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' 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\\Product' 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\\Product' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'title' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'slug' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'textGeneral' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t6_.foreign_key = p0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'metaDescription' AND t7_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t7_.foreign_key = p0_.id WHERE (COALESCE(t5_.content, p0_.slug) = 'ochranna-laserova-bunka') AND (p0_.is_active = true);
|
115.84 ms
(14.02%)
|
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
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;
|
91.23 ms
(11.04%)
|
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;
|
82.69 ms
(10.01%)
|
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
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;
|
37.58 ms
(4.55%)
|
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
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;
|
5.80 ms
(0.70%)
|
1 |
SELECT 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_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = ? OR p3_.category_super_id = ?) AND (p0_.is_active = true)
Parameters: [
3836
3836
]
SELECT 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_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = 3836 OR p3_.category_super_id = 3836) AND (p0_.is_active = true);
|
3.22 ms
(0.39%)
|
8 |
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';
|
1.90 ms
(0.23%)
|
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;
|
1.76 ms
(0.21%)
|
4 |
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 = 1042 ORDER BY t0.sequence ASC;
|
0.81 ms
(0.10%)
|
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';
|
0.73 ms
(0.09%)
|
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;
|
0.55 ms
(0.07%)
|
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 = 0;
|
0.44 ms
(0.05%)
|
1 |
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 = 56001 AND ((t0.is_active = true));
|
0.44 ms
(0.05%)
|
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 IS NULL 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 IS NULL LIMIT 1;
|
0.44 ms
(0.05%)
|
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 = ? 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 = 56001 AND ((t0.is_active = true)) LIMIT 1;
|
0.43 ms
(0.05%)
|
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4 FROM category_product t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4 FROM category_product t0 WHERE t0.product_id = 56001;
|
0.42 ms
(0.05%)
|
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 = ?
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 = 1042;
|
0.41 ms
(0.05%)
|
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.person_id AS person_id_4 FROM product_person t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.person_id AS person_id_4 FROM product_person t0 WHERE t0.product_id = 56001;
|
0.38 ms
(0.05%)
|
1 |
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 = 67825;
|
0.37 ms
(0.04%)
|
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;
|
0.32 ms
(0.04%)
|
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;
|
0.29 ms
(0.03%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM product_view_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM product_view_type t0 WHERE t0.id = 1;
|