1.78 ms (15.41%)
3
SELECT c0_ . content_type AS content_type_0 , c0_ . content_name AS content_name_1 , c0_ . content_order AS content_order_2 , c0_ . content_visible AS content_visible_3 , c0_ . id AS id_4 , c0_ . created_at AS created_at_5 , c0_ . updated_at AS updated_at_6 , c0_ . uuid AS uuid_7 , c1_ . id AS id_8 , c1_ . created_at AS created_at_9 , c1_ . updated_at AS updated_at_10 , c2_ . class AS class_11 , c2_ . style AS style_12 , c2_ . id AS id_13 , c2_ . created_at AS created_at_14 , c2_ . updated_at AS updated_at_15 , c3_ . anchor AS anchor_16 , c3_ . external_link AS external_link_17 , c3_ . target AS target_18 , c3_ . id AS id_19 , c3_ . created_at AS created_at_20 , c3_ . updated_at AS updated_at_21 , c4_ . id AS id_22 , c4_ . created_at AS created_at_23 , c4_ . updated_at AS updated_at_24 , c5_ . class AS class_25 , c5_ . style AS style_26 , c5_ . external_link AS external_link_27 , c5_ . link_class AS link_class_28 , c5_ . link_style AS link_style_29 , c5_ . target AS target_30 , c5_ . lazy_loading AS lazy_loading_31 , c5_ . id AS id_32 , c5_ . created_at AS created_at_33 , c5_ . updated_at AS updated_at_34 , c6_ . background_position AS background_position_35 , c6_ . background_repeat AS background_repeat_36 , c6_ . background_size AS background_size_37 , c6_ . id AS id_38 , c6_ . created_at AS created_at_39 , c6_ . updated_at AS updated_at_40 , c7_ . video_id AS video_id_41 , c7_ . width AS width_42 , c7_ . ratio AS ratio_43 , c7_ . controls AS controls_44 , c7_ . loop_video AS loop_video_45 , c7_ . mute AS mute_46 , c7_ . autoplay AS autoplay_47 , c7_ . fullscreen AS fullscreen_48 , c7_ . id AS id_49 , c7_ . created_at AS created_at_50 , c7_ . updated_at AS updated_at_51 , c8_ . locale AS locale_52 , c8_ . field_name AS field_name_53 , c8_ . translation AS translation_54 , c8_ . id AS id_55 , c8_ . created_at AS created_at_56 , c8_ . updated_at AS updated_at_57 , c9_ . locale AS locale_58 , c9_ . field_name AS field_name_59 , c9_ . translation AS translation_60 , c9_ . id AS id_61 , c9_ . created_at AS created_at_62 , c9_ . updated_at AS updated_at_63 , c10_ . locale AS locale_64 , c10_ . field_name AS field_name_65 , c10_ . translation AS translation_66 , c10_ . id AS id_67 , c10_ . created_at AS created_at_68 , c10_ . updated_at AS updated_at_69 , c11_ . locale AS locale_70 , c11_ . field_name AS field_name_71 , c11_ . translation AS translation_72 , c11_ . id AS id_73 , c11_ . created_at AS created_at_74 , c11_ . updated_at AS updated_at_75 , c0_ . page_id AS page_id_76 , c0_ . page_content_text_id AS page_content_text_id_77 , c0_ . page_content_link_id AS page_content_link_id_78 , c0_ . page_content_text_link_id AS page_content_text_link_id_79 , c0_ . page_content_editor_id AS page_content_editor_id_80 , c0_ . page_content_image_id AS page_content_image_id_81 , c0_ . page_content_background_id AS page_content_background_id_82 , c0_ . page_content_icon_id AS page_content_icon_id_83 , c0_ . page_content_video_id AS page_content_video_id_84 , c0_ . page_content_blog_category_id AS page_content_blog_category_id_85 , c0_ . page_content_date_id AS page_content_date_id_86 , c0_ . page_content_anchor_id AS page_content_anchor_id_87 , c0_ . page_content_blog_id AS page_content_blog_id_88 , c0_ . page_content_list_id AS page_content_list_id_89 , c0_ . page_content_carousel_id AS page_content_carousel_id_90 , c0_ . page_content_countdown_id AS page_content_countdown_id_91 , c0_ . page_content_element_id AS page_content_element_id_92 , c0_ . page_content_element_child_item_id AS page_content_element_child_item_id_93 , c0_ . page_content_gallery_id AS page_content_gallery_id_94 , c1_ . category_id AS category_id_95 , c1_ . page_id AS page_id_96 , c1_ . template_id AS template_id_97 , c3_ . link_page_id AS link_page_id_98 , c5_ . image_id AS image_id_99 , c5_ . link_page_id AS link_page_id_100 , c6_ . image_id AS image_id_101 , c8_ . page_content_text_id AS page_content_text_id_102 , c9_ . page_content_link_id AS page_content_link_id_103 , c10_ . page_content_editor_id AS page_content_editor_id_104 , c11_ . page_content_image_id AS page_content_image_id_105 FROM cms_page_content c0_ LEFT JOIN cms_page_content_element c1_ ON c0_ . page_content_element_id = c1_ . id LEFT JOIN cms_page_content_text c2_ ON c0_ . page_content_text_id = c2_ . id LEFT JOIN cms_page_content_link c3_ ON c0_ . page_content_link_id = c3_ . id LEFT JOIN cms_page_content_editor c4_ ON c0_ . page_content_editor_id = c4_ . id LEFT JOIN cms_page_content_image c5_ ON c0_ . page_content_image_id = c5_ . id LEFT JOIN cms_page_content_background c6_ ON c0_ . page_content_background_id = c6_ . id LEFT JOIN cms_page_content_video c7_ ON c0_ . page_content_video_id = c7_ . id LEFT JOIN cms_page_content_text_translation c8_ ON c2_ . id = c8_ . page_content_text_id AND (c8_ . locale = ? ) LEFT JOIN cms_page_content_link_translation c9_ ON c3_ . id = c9_ . page_content_link_id AND (c9_ . locale = ? ) LEFT JOIN cms_page_content_editor_translation c10_ ON c4_ . id = c10_ . page_content_editor_id AND (c10_ . locale = ? ) LEFT JOIN cms_page_content_image_translation c11_ ON c5_ . id = c11_ . page_content_image_id AND (c11_ . locale = ? ) WHERE c0_ . page_id = ?
Parameters :
[
"en "
"en "
"en "
"en "
8
]
SELECT
c0_ . content_type AS content_type_0 ,
c0_ . content_name AS content_name_1 ,
c0_ . content_order AS content_order_2 ,
c0_ . content_visible AS content_visible_3 ,
c0_ . id AS id_4 ,
c0_ . created_at AS created_at_5 ,
c0_ . updated_at AS updated_at_6 ,
c0_ . uuid AS uuid_7 ,
c1_ . id AS id_8 ,
c1_ . created_at AS created_at_9 ,
c1_ . updated_at AS updated_at_10 ,
c2_ . class AS class_11 ,
c2_ . style AS style_12 ,
c2_ . id AS id_13 ,
c2_ . created_at AS created_at_14 ,
c2_ . updated_at AS updated_at_15 ,
c3_ . anchor AS anchor_16 ,
c3_ . external_link AS external_link_17 ,
c3_ . target AS target_18 ,
c3_ . id AS id_19 ,
c3_ . created_at AS created_at_20 ,
c3_ . updated_at AS updated_at_21 ,
c4_ . id AS id_22 ,
c4_ . created_at AS created_at_23 ,
c4_ . updated_at AS updated_at_24 ,
c5_ . class AS class_25 ,
c5_ . style AS style_26 ,
c5_ . external_link AS external_link_27 ,
c5_ . link_class AS link_class_28 ,
c5_ . link_style AS link_style_29 ,
c5_ . target AS target_30 ,
c5_ . lazy_loading AS lazy_loading_31 ,
c5_ . id AS id_32 ,
c5_ . created_at AS created_at_33 ,
c5_ . updated_at AS updated_at_34 ,
c6_ . background_position AS background_position_35 ,
c6_ . background_repeat AS background_repeat_36 ,
c6_ . background_size AS background_size_37 ,
c6_ . id AS id_38 ,
c6_ . created_at AS created_at_39 ,
c6_ . updated_at AS updated_at_40 ,
c7_ . video_id AS video_id_41 ,
c7_ . width AS width_42 ,
c7_ . ratio AS ratio_43 ,
c7_ . controls AS controls_44 ,
c7_ . loop_video AS loop_video_45 ,
c7_ . mute AS mute_46 ,
c7_ . autoplay AS autoplay_47 ,
c7_ . fullscreen AS fullscreen_48 ,
c7_ . id AS id_49 ,
c7_ . created_at AS created_at_50 ,
c7_ . updated_at AS updated_at_51 ,
c8_ . locale AS locale_52 ,
c8_ . field_name AS field_name_53 ,
c8_ . translation AS translation_54 ,
c8_ . id AS id_55 ,
c8_ . created_at AS created_at_56 ,
c8_ . updated_at AS updated_at_57 ,
c9_ . locale AS locale_58 ,
c9_ . field_name AS field_name_59 ,
c9_ . translation AS translation_60 ,
c9_ . id AS id_61 ,
c9_ . created_at AS created_at_62 ,
c9_ . updated_at AS updated_at_63 ,
c10_ . locale AS locale_64 ,
c10_ . field_name AS field_name_65 ,
c10_ . translation AS translation_66 ,
c10_ . id AS id_67 ,
c10_ . created_at AS created_at_68 ,
c10_ . updated_at AS updated_at_69 ,
c11_ . locale AS locale_70 ,
c11_ . field_name AS field_name_71 ,
c11_ . translation AS translation_72 ,
c11_ . id AS id_73 ,
c11_ . created_at AS created_at_74 ,
c11_ . updated_at AS updated_at_75 ,
c0_ . page_id AS page_id_76 ,
c0_ . page_content_text_id AS page_content_text_id_77 ,
c0_ . page_content_link_id AS page_content_link_id_78 ,
c0_ . page_content_text_link_id AS page_content_text_link_id_79 ,
c0_ . page_content_editor_id AS page_content_editor_id_80 ,
c0_ . page_content_image_id AS page_content_image_id_81 ,
c0_ . page_content_background_id AS page_content_background_id_82 ,
c0_ . page_content_icon_id AS page_content_icon_id_83 ,
c0_ . page_content_video_id AS page_content_video_id_84 ,
c0_ . page_content_blog_category_id AS page_content_blog_category_id_85 ,
c0_ . page_content_date_id AS page_content_date_id_86 ,
c0_ . page_content_anchor_id AS page_content_anchor_id_87 ,
c0_ . page_content_blog_id AS page_content_blog_id_88 ,
c0_ . page_content_list_id AS page_content_list_id_89 ,
c0_ . page_content_carousel_id AS page_content_carousel_id_90 ,
c0_ . page_content_countdown_id AS page_content_countdown_id_91 ,
c0_ . page_content_element_id AS page_content_element_id_92 ,
c0_ . page_content_element_child_item_id AS page_content_element_child_item_id_93 ,
c0_ . page_content_gallery_id AS page_content_gallery_id_94 ,
c1_ . category_id AS category_id_95 ,
c1_ . page_id AS page_id_96 ,
c1_ . template_id AS template_id_97 ,
c3_ . link_page_id AS link_page_id_98 ,
c5_ . image_id AS image_id_99 ,
c5_ . link_page_id AS link_page_id_100 ,
c6_ . image_id AS image_id_101 ,
c8_ . page_content_text_id AS page_content_text_id_102 ,
c9_ . page_content_link_id AS page_content_link_id_103 ,
c10_ . page_content_editor_id AS page_content_editor_id_104 ,
c11_ . page_content_image_id AS page_content_image_id_105
FROM
cms_page_content c0_
LEFT JOIN cms_page_content_element c1_ ON c0_ . page_content_element_id = c1_ . id
LEFT JOIN cms_page_content_text c2_ ON c0_ . page_content_text_id = c2_ . id
LEFT JOIN cms_page_content_link c3_ ON c0_ . page_content_link_id = c3_ . id
LEFT JOIN cms_page_content_editor c4_ ON c0_ . page_content_editor_id = c4_ . id
LEFT JOIN cms_page_content_image c5_ ON c0_ . page_content_image_id = c5_ . id
LEFT JOIN cms_page_content_background c6_ ON c0_ . page_content_background_id = c6_ . id
LEFT JOIN cms_page_content_video c7_ ON c0_ . page_content_video_id = c7_ . id
LEFT JOIN cms_page_content_text_translation c8_ ON c2_ . id = c8_ . page_content_text_id
AND (c8_ . locale = ? )
LEFT JOIN cms_page_content_link_translation c9_ ON c3_ . id = c9_ . page_content_link_id
AND (c9_ . locale = ? )
LEFT JOIN cms_page_content_editor_translation c10_ ON c4_ . id = c10_ . page_content_editor_id
AND (c10_ . locale = ? )
LEFT JOIN cms_page_content_image_translation c11_ ON c5_ . id = c11_ . page_content_image_id
AND (c11_ . locale = ? )
WHERE
c0_ . page_id = ?
Copy
SELECT c0_ . content_type AS content_type_0 , c0_ . content_name AS content_name_1 , c0_ . content_order AS content_order_2 , c0_ . content_visible AS content_visible_3 , c0_ . id AS id_4 , c0_ . created_at AS created_at_5 , c0_ . updated_at AS updated_at_6 , c0_ . uuid AS uuid_7 , c1_ . id AS id_8 , c1_ . created_at AS created_at_9 , c1_ . updated_at AS updated_at_10 , c2_ . class AS class_11 , c2_ . style AS style_12 , c2_ . id AS id_13 , c2_ . created_at AS created_at_14 , c2_ . updated_at AS updated_at_15 , c3_ . anchor AS anchor_16 , c3_ . external_link AS external_link_17 , c3_ . target AS target_18 , c3_ . id AS id_19 , c3_ . created_at AS created_at_20 , c3_ . updated_at AS updated_at_21 , c4_ . id AS id_22 , c4_ . created_at AS created_at_23 , c4_ . updated_at AS updated_at_24 , c5_ . class AS class_25 , c5_ . style AS style_26 , c5_ . external_link AS external_link_27 , c5_ . link_class AS link_class_28 , c5_ . link_style AS link_style_29 , c5_ . target AS target_30 , c5_ . lazy_loading AS lazy_loading_31 , c5_ . id AS id_32 , c5_ . created_at AS created_at_33 , c5_ . updated_at AS updated_at_34 , c6_ . background_position AS background_position_35 , c6_ . background_repeat AS background_repeat_36 , c6_ . background_size AS background_size_37 , c6_ . id AS id_38 , c6_ . created_at AS created_at_39 , c6_ . updated_at AS updated_at_40 , c7_ . video_id AS video_id_41 , c7_ . width AS width_42 , c7_ . ratio AS ratio_43 , c7_ . controls AS controls_44 , c7_ . loop_video AS loop_video_45 , c7_ . mute AS mute_46 , c7_ . autoplay AS autoplay_47 , c7_ . fullscreen AS fullscreen_48 , c7_ . id AS id_49 , c7_ . created_at AS created_at_50 , c7_ . updated_at AS updated_at_51 , c8_ . locale AS locale_52 , c8_ . field_name AS field_name_53 , c8_ . translation AS translation_54 , c8_ . id AS id_55 , c8_ . created_at AS created_at_56 , c8_ . updated_at AS updated_at_57 , c9_ . locale AS locale_58 , c9_ . field_name AS field_name_59 , c9_ . translation AS translation_60 , c9_ . id AS id_61 , c9_ . created_at AS created_at_62 , c9_ . updated_at AS updated_at_63 , c10_ . locale AS locale_64 , c10_ . field_name AS field_name_65 , c10_ . translation AS translation_66 , c10_ . id AS id_67 , c10_ . created_at AS created_at_68 , c10_ . updated_at AS updated_at_69 , c11_ . locale AS locale_70 , c11_ . field_name AS field_name_71 , c11_ . translation AS translation_72 , c11_ . id AS id_73 , c11_ . created_at AS created_at_74 , c11_ . updated_at AS updated_at_75 , c0_ . page_id AS page_id_76 , c0_ . page_content_text_id AS page_content_text_id_77 , c0_ . page_content_link_id AS page_content_link_id_78 , c0_ . page_content_text_link_id AS page_content_text_link_id_79 , c0_ . page_content_editor_id AS page_content_editor_id_80 , c0_ . page_content_image_id AS page_content_image_id_81 , c0_ . page_content_background_id AS page_content_background_id_82 , c0_ . page_content_icon_id AS page_content_icon_id_83 , c0_ . page_content_video_id AS page_content_video_id_84 , c0_ . page_content_blog_category_id AS page_content_blog_category_id_85 , c0_ . page_content_date_id AS page_content_date_id_86 , c0_ . page_content_anchor_id AS page_content_anchor_id_87 , c0_ . page_content_blog_id AS page_content_blog_id_88 , c0_ . page_content_list_id AS page_content_list_id_89 , c0_ . page_content_carousel_id AS page_content_carousel_id_90 , c0_ . page_content_countdown_id AS page_content_countdown_id_91 , c0_ . page_content_element_id AS page_content_element_id_92 , c0_ . page_content_element_child_item_id AS page_content_element_child_item_id_93 , c0_ . page_content_gallery_id AS page_content_gallery_id_94 , c1_ . category_id AS category_id_95 , c1_ . page_id AS page_id_96 , c1_ . template_id AS template_id_97 , c3_ . link_page_id AS link_page_id_98 , c5_ . image_id AS image_id_99 , c5_ . link_page_id AS link_page_id_100 , c6_ . image_id AS image_id_101 , c8_ . page_content_text_id AS page_content_text_id_102 , c9_ . page_content_link_id AS page_content_link_id_103 , c10_ . page_content_editor_id AS page_content_editor_id_104 , c11_ . page_content_image_id AS page_content_image_id_105 FROM cms_page_content c0_ LEFT JOIN cms_page_content_element c1_ ON c0_ . page_content_element_id = c1_ . id LEFT JOIN cms_page_content_text c2_ ON c0_ . page_content_text_id = c2_ . id LEFT JOIN cms_page_content_link c3_ ON c0_ . page_content_link_id = c3_ . id LEFT JOIN cms_page_content_editor c4_ ON c0_ . page_content_editor_id = c4_ . id LEFT JOIN cms_page_content_image c5_ ON c0_ . page_content_image_id = c5_ . id LEFT JOIN cms_page_content_background c6_ ON c0_ . page_content_background_id = c6_ . id LEFT JOIN cms_page_content_video c7_ ON c0_ . page_content_video_id = c7_ . id LEFT JOIN cms_page_content_text_translation c8_ ON c2_ . id = c8_ . page_content_text_id AND (c8_ . locale = 'en' ) LEFT JOIN cms_page_content_link_translation c9_ ON c3_ . id = c9_ . page_content_link_id AND (c9_ . locale = 'en' ) LEFT JOIN cms_page_content_editor_translation c10_ ON c4_ . id = c10_ . page_content_editor_id AND (c10_ . locale = 'en' ) LEFT JOIN cms_page_content_image_translation c11_ ON c5_ . id = c11_ . page_content_image_id AND (c11_ . locale = 'en' ) WHERE c0_ . page_id = 8 ;
Copy
0.56 ms (4.89%)
3
SELECT t0 . content_type AS content_type_1 , t0 . content_name AS content_name_2 , t0 . content_order AS content_order_3 , t0 . content_visible AS content_visible_4 , t0 . id AS id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . uuid AS uuid_8 , t0 . page_id AS page_id_9 , t0 . page_content_text_id AS page_content_text_id_10 , t0 . page_content_link_id AS page_content_link_id_11 , t0 . page_content_text_link_id AS page_content_text_link_id_12 , t0 . page_content_editor_id AS page_content_editor_id_13 , t0 . page_content_image_id AS page_content_image_id_14 , t0 . page_content_background_id AS page_content_background_id_15 , t0 . page_content_icon_id AS page_content_icon_id_16 , t0 . page_content_video_id AS page_content_video_id_17 , t0 . page_content_blog_category_id AS page_content_blog_category_id_18 , t0 . page_content_date_id AS page_content_date_id_19 , t0 . page_content_anchor_id AS page_content_anchor_id_20 , t0 . page_content_blog_id AS page_content_blog_id_21 , t0 . page_content_list_id AS page_content_list_id_22 , t0 . page_content_carousel_id AS page_content_carousel_id_23 , t0 . page_content_countdown_id AS page_content_countdown_id_24 , t0 . page_content_element_id AS page_content_element_id_25 , t0 . page_content_element_child_item_id AS page_content_element_child_item_id_26 , t0 . page_content_gallery_id AS page_content_gallery_id_27 FROM cms_page_extra_field_content t0 WHERE t0 . page_id = ?
SELECT t0 . content_type AS content_type_1 , t0 . content_name AS content_name_2 , t0 . content_order AS content_order_3 , t0 . content_visible AS content_visible_4 , t0 . id AS id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . uuid AS uuid_8 , t0 . page_id AS page_id_9 , t0 . page_content_text_id AS page_content_text_id_10 , t0 . page_content_link_id AS page_content_link_id_11 , t0 . page_content_text_link_id AS page_content_text_link_id_12 , t0 . page_content_editor_id AS page_content_editor_id_13 , t0 . page_content_image_id AS page_content_image_id_14 , t0 . page_content_background_id AS page_content_background_id_15 , t0 . page_content_icon_id AS page_content_icon_id_16 , t0 . page_content_video_id AS page_content_video_id_17 , t0 . page_content_blog_category_id AS page_content_blog_category_id_18 , t0 . page_content_date_id AS page_content_date_id_19 , t0 . page_content_anchor_id AS page_content_anchor_id_20 , t0 . page_content_blog_id AS page_content_blog_id_21 , t0 . page_content_list_id AS page_content_list_id_22 , t0 . page_content_carousel_id AS page_content_carousel_id_23 , t0 . page_content_countdown_id AS page_content_countdown_id_24 , t0 . page_content_element_id AS page_content_element_id_25 , t0 . page_content_element_child_item_id AS page_content_element_child_item_id_26 , t0 . page_content_gallery_id AS page_content_gallery_id_27 FROM cms_page_extra_field_content t0 WHERE t0 . page_id = 1 ;
Copy