1 |
3.34 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.template AS template_4, p0_.is_render_button AS is_render_button_5, p0_.button_url AS button_url_6, w1_.id AS id_7, w1_.order_widget AS order_widget_8, w1_.type AS type_9, w1_.items AS items_10, w2_.data AS data_11, w2_.id AS id_12, w2_.locale AS locale_13, w2_.field AS field_14, w2_.content AS content_15, p3_.seo_title AS seo_title_16, p3_.seo_description AS seo_description_17, p3_.seo_keywords AS seo_keywords_18, p3_.title AS title_19, p3_.menu_title AS menu_title_20, p3_.button_text AS button_text_21, p3_.id AS id_22, p3_.locale AS locale_23, p3_.field AS field_24, p3_.content AS content_25, p4_.id AS id_26, p4_.name AS name_27, p4_.host AS host_28, p4_.logo AS logo_29, p4_.favicon AS favicon_30, p4_.currency AS currency_31, p4_.languages AS languages_32, p4_.is_active AS is_active_33, p4_.telegram AS telegram_34, p4_.whatsapp AS whatsapp_35, p4_.phone AS phone_36, p4_.handlers AS handlers_37, p4_.is_fullname AS is_fullname_38, p4_.is_delivery_outside_city AS is_delivery_outside_city_39, p4_.min_order_price AS min_order_price_40, p4_.telegram_message_footer AS telegram_message_footer_41, p4_.verified_domain AS verified_domain_42, p4_.is_urgent_order AS is_urgent_order_43, p4_.is_comment_order AS is_comment_order_44, p4_.country AS country_45, p4_.site_menu AS site_menu_46, p4_.site_theme AS site_theme_47, p4_.email AS email_48, p4_.instagram AS instagram_49, p4_.address AS address_50, p4_.map AS map_51, p4_.min_carpet_price AS min_carpet_price_52, p4_.header_button_link AS header_button_link_53, p4_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_54, p0_.project_id AS project_id_55, w1_.discriminator AS discriminator_56, w1_.page_id AS page_id_57, w2_.object_id AS object_id_58, p3_.object_id AS object_id_59 FROM page p0_ LEFT JOIN widgets w1_ ON p0_.id = w1_.page_id AND w1_.discriminator IN (0, 1) LEFT JOIN widget_translations w2_ ON w1_.id = w2_.object_id LEFT JOIN page_translations p3_ ON p0_.id = p3_.object_id LEFT JOIN projects p4_ ON p0_.project_id = p4_.id WHERE p4_.host = ? AND p3_.locale = ? AND p0_.slug IS NULL ORDER BY w1_.order_widget ASC
Parameters: [
"itkovrochist.online"
"ru"
]
SELECT
p0_.id AS id_0,
p0_.slug AS slug_1,
p0_.created_at AS created_at_2,
p0_.updated_at AS updated_at_3,
p0_.template AS template_4,
p0_.is_render_button AS is_render_button_5,
p0_.button_url AS button_url_6,
w1_.id AS id_7,
w1_.order_widget AS order_widget_8,
w1_.type AS type_9,
w1_.items AS items_10,
w2_.data AS data_11,
w2_.id AS id_12,
w2_.locale AS locale_13,
w2_.field AS field_14,
w2_.content AS content_15,
p3_.seo_title AS seo_title_16,
p3_.seo_description AS seo_description_17,
p3_.seo_keywords AS seo_keywords_18,
p3_.title AS title_19,
p3_.menu_title AS menu_title_20,
p3_.button_text AS button_text_21,
p3_.id AS id_22,
p3_.locale AS locale_23,
p3_.field AS field_24,
p3_.content AS content_25,
p4_.id AS id_26,
p4_.name AS name_27,
p4_.host AS host_28,
p4_.logo AS logo_29,
p4_.favicon AS favicon_30,
p4_.currency AS currency_31,
p4_.languages AS languages_32,
p4_.is_active AS is_active_33,
p4_.telegram AS telegram_34,
p4_.whatsapp AS whatsapp_35,
p4_.phone AS phone_36,
p4_.handlers AS handlers_37,
p4_.is_fullname AS is_fullname_38,
p4_.is_delivery_outside_city AS is_delivery_outside_city_39,
p4_.min_order_price AS min_order_price_40,
p4_.telegram_message_footer AS telegram_message_footer_41,
p4_.verified_domain AS verified_domain_42,
p4_.is_urgent_order AS is_urgent_order_43,
p4_.is_comment_order AS is_comment_order_44,
p4_.country AS country_45,
p4_.site_menu AS site_menu_46,
p4_.site_theme AS site_theme_47,
p4_.email AS email_48,
p4_.instagram AS instagram_49,
p4_.address AS address_50,
p4_.map AS map_51,
p4_.min_carpet_price AS min_carpet_price_52,
p4_.header_button_link AS header_button_link_53,
p4_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_54,
p0_.project_id AS project_id_55,
w1_.discriminator AS discriminator_56,
w1_.page_id AS page_id_57,
w2_.object_id AS object_id_58,
p3_.object_id AS object_id_59
FROM
page p0_
LEFT JOIN widgets w1_ ON p0_.id = w1_.page_id
AND w1_.discriminator IN (0, 1)
LEFT JOIN widget_translations w2_ ON w1_.id = w2_.object_id
LEFT JOIN page_translations p3_ ON p0_.id = p3_.object_id
LEFT JOIN projects p4_ ON p0_.project_id = p4_.id
WHERE
p4_.host = ?
AND p3_.locale = ?
AND p0_.slug IS NULL
ORDER BY
w1_.order_widget ASC
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.template AS template_4, p0_.is_render_button AS is_render_button_5, p0_.button_url AS button_url_6, w1_.id AS id_7, w1_.order_widget AS order_widget_8, w1_.type AS type_9, w1_.items AS items_10, w2_.data AS data_11, w2_.id AS id_12, w2_.locale AS locale_13, w2_.field AS field_14, w2_.content AS content_15, p3_.seo_title AS seo_title_16, p3_.seo_description AS seo_description_17, p3_.seo_keywords AS seo_keywords_18, p3_.title AS title_19, p3_.menu_title AS menu_title_20, p3_.button_text AS button_text_21, p3_.id AS id_22, p3_.locale AS locale_23, p3_.field AS field_24, p3_.content AS content_25, p4_.id AS id_26, p4_.name AS name_27, p4_.host AS host_28, p4_.logo AS logo_29, p4_.favicon AS favicon_30, p4_.currency AS currency_31, p4_.languages AS languages_32, p4_.is_active AS is_active_33, p4_.telegram AS telegram_34, p4_.whatsapp AS whatsapp_35, p4_.phone AS phone_36, p4_.handlers AS handlers_37, p4_.is_fullname AS is_fullname_38, p4_.is_delivery_outside_city AS is_delivery_outside_city_39, p4_.min_order_price AS min_order_price_40, p4_.telegram_message_footer AS telegram_message_footer_41, p4_.verified_domain AS verified_domain_42, p4_.is_urgent_order AS is_urgent_order_43, p4_.is_comment_order AS is_comment_order_44, p4_.country AS country_45, p4_.site_menu AS site_menu_46, p4_.site_theme AS site_theme_47, p4_.email AS email_48, p4_.instagram AS instagram_49, p4_.address AS address_50, p4_.map AS map_51, p4_.min_carpet_price AS min_carpet_price_52, p4_.header_button_link AS header_button_link_53, p4_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_54, p0_.project_id AS project_id_55, w1_.discriminator AS discriminator_56, w1_.page_id AS page_id_57, w2_.object_id AS object_id_58, p3_.object_id AS object_id_59 FROM page p0_ LEFT JOIN widgets w1_ ON p0_.id = w1_.page_id AND w1_.discriminator IN (0, 1) LEFT JOIN widget_translations w2_ ON w1_.id = w2_.object_id LEFT JOIN page_translations p3_ ON p0_.id = p3_.object_id LEFT JOIN projects p4_ ON p0_.project_id = p4_.id WHERE p4_.host = 'itkovrochist.online' AND p3_.locale = 'ru' AND p0_.slug IS NULL ORDER BY w1_.order_widget ASC;
|
4 |
0.64 ms |
SELECT t0.id AS id_1, t0.monday_start AS monday_start_2, t0.monday_stop AS monday_stop_3, t0.tuesday_start AS tuesday_start_4, t0.tuesday_stop AS tuesday_stop_5, t0.wednesday_start AS wednesday_start_6, t0.wednesday_stop AS wednesday_stop_7, t0.thursday_start AS thursday_start_8, t0.thursday_stop AS thursday_stop_9, t0.friday_start AS friday_start_10, t0.friday_stop AS friday_stop_11, t0.saturday_start AS saturday_start_12, t0.saturday_stop AS saturday_stop_13, t0.sunday_start AS sunday_start_14, t0.sunday_stop AS sunday_stop_15, t0.project_id AS project_id_16 FROM workdays t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.monday_start AS monday_start_2, t0.monday_stop AS monday_stop_3, t0.tuesday_start AS tuesday_start_4, t0.tuesday_stop AS tuesday_stop_5, t0.wednesday_start AS wednesday_start_6, t0.wednesday_stop AS wednesday_stop_7, t0.thursday_start AS thursday_start_8, t0.thursday_stop AS thursday_stop_9, t0.friday_start AS friday_start_10, t0.friday_stop AS friday_stop_11, t0.saturday_start AS saturday_start_12, t0.saturday_stop AS saturday_stop_13, t0.sunday_start AS sunday_start_14, t0.sunday_stop AS sunday_stop_15, t0.project_id AS project_id_16 FROM workdays t0 WHERE t0.project_id = 1;
|