1 |
1.63 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 = ? ORDER BY w1_.order_widget ASC
Parameters: [
"itkovrochist.online"
"ru"
" about-us"
]
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 = ?
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 = ' about-us' ORDER BY w1_.order_widget ASC;
|
2 |
0.66 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.host AS host_2, p0_.logo AS logo_3, p0_.favicon AS favicon_4, p0_.currency AS currency_5, p0_.languages AS languages_6, p0_.is_active AS is_active_7, p0_.telegram AS telegram_8, p0_.whatsapp AS whatsapp_9, p0_.phone AS phone_10, p0_.handlers AS handlers_11, p0_.is_fullname AS is_fullname_12, p0_.is_delivery_outside_city AS is_delivery_outside_city_13, p0_.min_order_price AS min_order_price_14, p0_.telegram_message_footer AS telegram_message_footer_15, p0_.verified_domain AS verified_domain_16, p0_.is_urgent_order AS is_urgent_order_17, p0_.is_comment_order AS is_comment_order_18, p0_.country AS country_19, p0_.site_menu AS site_menu_20, p0_.site_theme AS site_theme_21, p0_.email AS email_22, p0_.instagram AS instagram_23, p0_.address AS address_24, p0_.map AS map_25, p0_.min_carpet_price AS min_carpet_price_26, p0_.header_button_link AS header_button_link_27, p0_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_28 FROM projects p0_ WHERE p0_.host = ?
Parameters: [
"itkovrochist.online"
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.host AS host_2, p0_.logo AS logo_3, p0_.favicon AS favicon_4, p0_.currency AS currency_5, p0_.languages AS languages_6, p0_.is_active AS is_active_7, p0_.telegram AS telegram_8, p0_.whatsapp AS whatsapp_9, p0_.phone AS phone_10, p0_.handlers AS handlers_11, p0_.is_fullname AS is_fullname_12, p0_.is_delivery_outside_city AS is_delivery_outside_city_13, p0_.min_order_price AS min_order_price_14, p0_.telegram_message_footer AS telegram_message_footer_15, p0_.verified_domain AS verified_domain_16, p0_.is_urgent_order AS is_urgent_order_17, p0_.is_comment_order AS is_comment_order_18, p0_.country AS country_19, p0_.site_menu AS site_menu_20, p0_.site_theme AS site_theme_21, p0_.email AS email_22, p0_.instagram AS instagram_23, p0_.address AS address_24, p0_.map AS map_25, p0_.min_carpet_price AS min_carpet_price_26, p0_.header_button_link AS header_button_link_27, p0_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_28 FROM projects p0_ WHERE p0_.host = 'itkovrochist.online';
|