1
2.05 ms
SELECT s0_ . slug AS slug_0 , s0_ . class_name AS class_name_1 , s0_ . content_updated_at AS content_updated_at_2 , s0_ . created_at AS created_at_3 , s0_ . updated_at AS updated_at_4 , s0_ . id AS id_5 FROM slug s0_ WHERE s0_ . slug = ? LIMIT 1
SELECT s0_ . slug AS slug_0 , s0_ . class_name AS class_name_1 , s0_ . content_updated_at AS content_updated_at_2 , s0_ . created_at AS created_at_3 , s0_ . updated_at AS updated_at_4 , s0_ . id AS id_5 FROM slug s0_ WHERE s0_ . slug = '' LIMIT 1 ;
Copy
2
23.31 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p0_ . slug_id = ? ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(p0_ . slug_id = ? )
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p0_ . slug_id = '018ee149-8f00-7d1d-82b2-32a5d423cff4' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC ;
Copy
3
124.15 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'home' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
4
0.90 ms
SELECT t0 . title AS title_1 , t0 . template AS template_2 , t0 . allow_blocks AS allow_blocks_3 , t0 . allow_categories AS allow_categories_4 , t0 . static_page AS static_page_5 , t0 . banner_image AS banner_image_6 , t0 . slider AS slider_7 , t0 . content AS content_8 , t0 . duplicable AS duplicable_9 , t0 . deletable AS deletable_10 , t0 . searchable AS searchable_11 , t0 . featurable AS featurable_12 , t0 . sortable AS sortable_13 , t0 . exportable AS exportable_14 , t0 . has_downloads AS has_downloads_15 , t0 . has_images AS has_images_16 , t0 . family AS family_17 , t0 . product AS product_18 , t0 . publishable AS publishable_19 , t0 . tagged AS tagged_20 , t0 . meta_title AS meta_title_21 , t0 . meta_description AS meta_description_22 , t0 . deleted_at AS deleted_at_23 , t0 . created_at AS created_at_24 , t0 . updated_at AS updated_at_25 , t0 . id AS id_26 FROM page_basis t0 WHERE t0 . template = ? AND ((t0 . deleted_at IS NULL )) LIMIT 1
SELECT t0 . title AS title_1 , t0 . template AS template_2 , t0 . allow_blocks AS allow_blocks_3 , t0 . allow_categories AS allow_categories_4 , t0 . static_page AS static_page_5 , t0 . banner_image AS banner_image_6 , t0 . slider AS slider_7 , t0 . content AS content_8 , t0 . duplicable AS duplicable_9 , t0 . deletable AS deletable_10 , t0 . searchable AS searchable_11 , t0 . featurable AS featurable_12 , t0 . sortable AS sortable_13 , t0 . exportable AS exportable_14 , t0 . has_downloads AS has_downloads_15 , t0 . has_images AS has_images_16 , t0 . family AS family_17 , t0 . product AS product_18 , t0 . publishable AS publishable_19 , t0 . tagged AS tagged_20 , t0 . meta_title AS meta_title_21 , t0 . meta_description AS meta_description_22 , t0 . deleted_at AS deleted_at_23 , t0 . created_at AS created_at_24 , t0 . updated_at AS updated_at_25 , t0 . id AS id_26 FROM page_basis t0 WHERE t0 . template = 'home' AND ((t0 . deleted_at IS NULL )) LIMIT 1 ;
Copy
5
122.58 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
Parameters :
[
"contact "
]
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'contact' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
6
127.53 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'home' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
7
100.60 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
Parameters :
[
"products "
]
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'products' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
8
114.40 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'news' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
9
161.74 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = ? AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1
SELECT
p0_ . title AS title_0 ,
p0_ . menu_title AS menu_title_1 ,
p0_ . content AS content_2 ,
p0_ . feature AS feature_3 ,
p0_ . published_at AS published_at_4 ,
p0_ . deleted_at AS deleted_at_5 ,
p0_ . position AS position_6 ,
p0_ . created_at AS created_at_7 ,
p0_ . updated_at AS updated_at_8 ,
p0_ . active AS active_9 ,
p0_ . id AS id_10 ,
p1_ . title AS title_11 ,
p1_ . template AS template_12 ,
p1_ . allow_blocks AS allow_blocks_13 ,
p1_ . allow_categories AS allow_categories_14 ,
p1_ . static_page AS static_page_15 ,
p1_ . banner_image AS banner_image_16 ,
p1_ . slider AS slider_17 ,
p1_ . content AS content_18 ,
p1_ . duplicable AS duplicable_19 ,
p1_ . deletable AS deletable_20 ,
p1_ . searchable AS searchable_21 ,
p1_ . featurable AS featurable_22 ,
p1_ . sortable AS sortable_23 ,
p1_ . exportable AS exportable_24 ,
p1_ . has_downloads AS has_downloads_25 ,
p1_ . has_images AS has_images_26 ,
p1_ . family AS family_27 ,
p1_ . product AS product_28 ,
p1_ . publishable AS publishable_29 ,
p1_ . tagged AS tagged_30 ,
p1_ . meta_title AS meta_title_31 ,
p1_ . meta_description AS meta_description_32 ,
p1_ . deleted_at AS deleted_at_33 ,
p1_ . created_at AS created_at_34 ,
p1_ . updated_at AS updated_at_35 ,
p1_ . id AS id_36 ,
i2_ . name AS name_37 ,
i2_ . original_name AS original_name_38 ,
i2_ . size AS size_39 ,
i2_ . alt AS alt_40 ,
i2_ . source AS source_41 ,
i2_ . created_at AS created_at_42 ,
i2_ . updated_at AS updated_at_43 ,
i2_ . id AS id_44 ,
s3_ . slug AS slug_45 ,
s3_ . class_name AS class_name_46 ,
s3_ . content_updated_at AS content_updated_at_47 ,
s3_ . created_at AS created_at_48 ,
s3_ . updated_at AS updated_at_49 ,
s3_ . id AS id_50 ,
m4_ . keywords AS keywords_51 ,
m4_ . meta_title AS meta_title_52 ,
m4_ . meta_description AS meta_description_53 ,
m4_ . og_title AS og_title_54 ,
m4_ . og_description AS og_description_55 ,
m4_ . twitter_title AS twitter_title_56 ,
m4_ . twitter_description AS twitter_description_57 ,
m4_ . robots_index AS robots_index_58 ,
m4_ . created_at AS created_at_59 ,
m4_ . updated_at AS updated_at_60 ,
m4_ . id AS id_61 ,
i5_ . name AS name_62 ,
i5_ . original_name AS original_name_63 ,
i5_ . size AS size_64 ,
i5_ . alt AS alt_65 ,
i5_ . source AS source_66 ,
i5_ . created_at AS created_at_67 ,
i5_ . updated_at AS updated_at_68 ,
i5_ . id AS id_69 ,
i6_ . name AS name_70 ,
i6_ . original_name AS original_name_71 ,
i6_ . size AS size_72 ,
i6_ . alt AS alt_73 ,
i6_ . source AS source_74 ,
i6_ . created_at AS created_at_75 ,
i6_ . updated_at AS updated_at_76 ,
i6_ . id AS id_77 ,
b7_ . is_wide AS is_wide_78 ,
b7_ . title AS title_79 ,
b7_ . content AS content_80 ,
b7_ . deleted_at AS deleted_at_81 ,
b7_ . position AS position_82 ,
b7_ . created_at AS created_at_83 ,
b7_ . updated_at AS updated_at_84 ,
b7_ . active AS active_85 ,
b7_ . id AS id_86 ,
b8_ . name AS name_87 ,
b8_ . template AS template_88 ,
b8_ . has_wide AS has_wide_89 ,
b8_ . has_title AS has_title_90 ,
b8_ . has_content AS has_content_91 ,
b8_ . has_image AS has_image_92 ,
b8_ . has_link AS has_link_93 ,
b8_ . has_video AS has_video_94 ,
b8_ . has_downloads AS has_downloads_95 ,
b8_ . has_images AS has_images_96 ,
b8_ . has_links AS has_links_97 ,
b8_ . created_at AS created_at_98 ,
b8_ . updated_at AS updated_at_99 ,
b8_ . active AS active_100 ,
b8_ . id AS id_101 ,
a9_ . name AS name_102 ,
a9_ . original_name AS original_name_103 ,
a9_ . size AS size_104 ,
a9_ . alt AS alt_105 ,
a9_ . source AS source_106 ,
a9_ . created_at AS created_at_107 ,
a9_ . updated_at AS updated_at_108 ,
a9_ . id AS id_109 ,
i10_ . name AS name_110 ,
i10_ . original_name AS original_name_111 ,
i10_ . size AS size_112 ,
i10_ . alt AS alt_113 ,
i10_ . source AS source_114 ,
i10_ . created_at AS created_at_115 ,
i10_ . updated_at AS updated_at_116 ,
i10_ . id AS id_117 ,
l11_ . text AS text_118 ,
l11_ . link AS link_119 ,
l11_ . created_at AS created_at_120 ,
l11_ . updated_at AS updated_at_121 ,
l11_ . id AS id_122 ,
v12_ . text AS text_123 ,
v12_ . link AS link_124 ,
v12_ . source AS source_125 ,
v12_ . created_at AS created_at_126 ,
v12_ . updated_at AS updated_at_127 ,
v12_ . id AS id_128 ,
b13_ . position AS position_129 ,
b13_ . id AS id_130 ,
d14_ . name AS name_131 ,
d14_ . original_name AS original_name_132 ,
d14_ . size AS size_133 ,
d14_ . text AS text_134 ,
d14_ . created_at AS created_at_135 ,
d14_ . updated_at AS updated_at_136 ,
d14_ . id AS id_137 ,
b15_ . position AS position_138 ,
b15_ . id AS id_139 ,
i16_ . name AS name_140 ,
i16_ . original_name AS original_name_141 ,
i16_ . size AS size_142 ,
i16_ . alt AS alt_143 ,
i16_ . source AS source_144 ,
i16_ . created_at AS created_at_145 ,
i16_ . updated_at AS updated_at_146 ,
i16_ . id AS id_147 ,
b17_ . position AS position_148 ,
b17_ . id AS id_149 ,
l18_ . text AS text_150 ,
l18_ . link AS link_151 ,
l18_ . created_at AS created_at_152 ,
l18_ . updated_at AS updated_at_153 ,
l18_ . id AS id_154 ,
p19_ . position AS position_155 ,
p19_ . id AS id_156 ,
s20_ . title AS title_157 ,
s20_ . subtitle AS subtitle_158 ,
s20_ . created_at AS created_at_159 ,
s20_ . updated_at AS updated_at_160 ,
s20_ . id AS id_161 ,
i21_ . name AS name_162 ,
i21_ . original_name AS original_name_163 ,
i21_ . size AS size_164 ,
i21_ . alt AS alt_165 ,
i21_ . source AS source_166 ,
i21_ . created_at AS created_at_167 ,
i21_ . updated_at AS updated_at_168 ,
i21_ . id AS id_169 ,
l22_ . text AS text_170 ,
l22_ . link AS link_171 ,
l22_ . created_at AS created_at_172 ,
l22_ . updated_at AS updated_at_173 ,
l22_ . id AS id_174 ,
v23_ . text AS text_175 ,
v23_ . link AS link_176 ,
v23_ . source AS source_177 ,
v23_ . created_at AS created_at_178 ,
v23_ . updated_at AS updated_at_179 ,
v23_ . id AS id_180 ,
f24_ . code AS code_181 ,
f24_ . created_at AS created_at_182 ,
f24_ . updated_at AS updated_at_183 ,
f24_ . id AS id_184 ,
p25_ . reference AS reference_185 ,
p25_ . created_at AS created_at_186 ,
p25_ . updated_at AS updated_at_187 ,
p25_ . id AS id_188 ,
p0_ . basis_id AS basis_id_189 ,
p0_ . family_id AS family_id_190 ,
p0_ . product_id AS product_id_191 ,
p0_ . banner_id AS banner_id_192 ,
p0_ . meta_id AS meta_id_193 ,
p0_ . slug_id AS slug_id_194 ,
m4_ . og_image_id AS og_image_id_195 ,
m4_ . twitter_image_id AS twitter_image_id_196 ,
b7_ . image_id AS image_id_197 ,
b7_ . link_id AS link_id_198 ,
b7_ . video_id AS video_id_199 ,
b7_ . basis_id AS basis_id_200 ,
b7_ . page_id AS page_id_201 ,
b8_ . image_id AS image_id_202 ,
b13_ . block_id AS block_id_203 ,
b13_ . download_id AS download_id_204 ,
b15_ . block_id AS block_id_205 ,
b15_ . image_id AS image_id_206 ,
b17_ . block_id AS block_id_207 ,
b17_ . link_id AS link_id_208 ,
p19_ . page_id AS page_id_209 ,
p19_ . slide_id AS slide_id_210 ,
s20_ . image_id AS image_id_211 ,
s20_ . link_id AS link_id_212 ,
s20_ . video_id AS video_id_213 ,
f24_ . page_id AS page_id_214 ,
p25_ . family_id AS family_id_215 ,
p25_ . page_id AS page_id_216
FROM
PAGE p0_
LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id
AND (p1_ . deleted_at IS NULL )
LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id
LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id
LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id
LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id
LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id
LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id
LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id
LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id
LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id
LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id
LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id
LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id
LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id
LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id
LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id
LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id
LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id
LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id
LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id
LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id
LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id
LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id
LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id
LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id
WHERE
(
p1_ . template = ?
AND p1_ . static_page = 'yes'
)
AND (p0_ . deleted_at IS NULL )
ORDER BY
b7_ . position ASC ,
b13_ . position ASC ,
b15_ . position ASC ,
b17_ . position ASC ,
p19_ . position ASC
LIMIT
1
Copy
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , p1_ . title AS title_11 , p1_ . template AS template_12 , p1_ . allow_blocks AS allow_blocks_13 , p1_ . allow_categories AS allow_categories_14 , p1_ . static_page AS static_page_15 , p1_ . banner_image AS banner_image_16 , p1_ . slider AS slider_17 , p1_ . content AS content_18 , p1_ . duplicable AS duplicable_19 , p1_ . deletable AS deletable_20 , p1_ . searchable AS searchable_21 , p1_ . featurable AS featurable_22 , p1_ . sortable AS sortable_23 , p1_ . exportable AS exportable_24 , p1_ . has_downloads AS has_downloads_25 , p1_ . has_images AS has_images_26 , p1_ . family AS family_27 , p1_ . product AS product_28 , p1_ . publishable AS publishable_29 , p1_ . tagged AS tagged_30 , p1_ . meta_title AS meta_title_31 , p1_ . meta_description AS meta_description_32 , p1_ . deleted_at AS deleted_at_33 , p1_ . created_at AS created_at_34 , p1_ . updated_at AS updated_at_35 , p1_ . id AS id_36 , i2_ . name AS name_37 , i2_ . original_name AS original_name_38 , i2_ . size AS size_39 , i2_ . alt AS alt_40 , i2_ . source AS source_41 , i2_ . created_at AS created_at_42 , i2_ . updated_at AS updated_at_43 , i2_ . id AS id_44 , s3_ . slug AS slug_45 , s3_ . class_name AS class_name_46 , s3_ . content_updated_at AS content_updated_at_47 , s3_ . created_at AS created_at_48 , s3_ . updated_at AS updated_at_49 , s3_ . id AS id_50 , m4_ . keywords AS keywords_51 , m4_ . meta_title AS meta_title_52 , m4_ . meta_description AS meta_description_53 , m4_ . og_title AS og_title_54 , m4_ . og_description AS og_description_55 , m4_ . twitter_title AS twitter_title_56 , m4_ . twitter_description AS twitter_description_57 , m4_ . robots_index AS robots_index_58 , m4_ . created_at AS created_at_59 , m4_ . updated_at AS updated_at_60 , m4_ . id AS id_61 , i5_ . name AS name_62 , i5_ . original_name AS original_name_63 , i5_ . size AS size_64 , i5_ . alt AS alt_65 , i5_ . source AS source_66 , i5_ . created_at AS created_at_67 , i5_ . updated_at AS updated_at_68 , i5_ . id AS id_69 , i6_ . name AS name_70 , i6_ . original_name AS original_name_71 , i6_ . size AS size_72 , i6_ . alt AS alt_73 , i6_ . source AS source_74 , i6_ . created_at AS created_at_75 , i6_ . updated_at AS updated_at_76 , i6_ . id AS id_77 , b7_ . is_wide AS is_wide_78 , b7_ . title AS title_79 , b7_ . content AS content_80 , b7_ . deleted_at AS deleted_at_81 , b7_ . position AS position_82 , b7_ . created_at AS created_at_83 , b7_ . updated_at AS updated_at_84 , b7_ . active AS active_85 , b7_ . id AS id_86 , b8_ . name AS name_87 , b8_ . template AS template_88 , b8_ . has_wide AS has_wide_89 , b8_ . has_title AS has_title_90 , b8_ . has_content AS has_content_91 , b8_ . has_image AS has_image_92 , b8_ . has_link AS has_link_93 , b8_ . has_video AS has_video_94 , b8_ . has_downloads AS has_downloads_95 , b8_ . has_images AS has_images_96 , b8_ . has_links AS has_links_97 , b8_ . created_at AS created_at_98 , b8_ . updated_at AS updated_at_99 , b8_ . active AS active_100 , b8_ . id AS id_101 , a9_ . name AS name_102 , a9_ . original_name AS original_name_103 , a9_ . size AS size_104 , a9_ . alt AS alt_105 , a9_ . source AS source_106 , a9_ . created_at AS created_at_107 , a9_ . updated_at AS updated_at_108 , a9_ . id AS id_109 , i10_ . name AS name_110 , i10_ . original_name AS original_name_111 , i10_ . size AS size_112 , i10_ . alt AS alt_113 , i10_ . source AS source_114 , i10_ . created_at AS created_at_115 , i10_ . updated_at AS updated_at_116 , i10_ . id AS id_117 , l11_ . text AS text_118 , l11_ . link AS link_119 , l11_ . created_at AS created_at_120 , l11_ . updated_at AS updated_at_121 , l11_ . id AS id_122 , v12_ . text AS text_123 , v12_ . link AS link_124 , v12_ . source AS source_125 , v12_ . created_at AS created_at_126 , v12_ . updated_at AS updated_at_127 , v12_ . id AS id_128 , b13_ . position AS position_129 , b13_ . id AS id_130 , d14_ . name AS name_131 , d14_ . original_name AS original_name_132 , d14_ . size AS size_133 , d14_ . text AS text_134 , d14_ . created_at AS created_at_135 , d14_ . updated_at AS updated_at_136 , d14_ . id AS id_137 , b15_ . position AS position_138 , b15_ . id AS id_139 , i16_ . name AS name_140 , i16_ . original_name AS original_name_141 , i16_ . size AS size_142 , i16_ . alt AS alt_143 , i16_ . source AS source_144 , i16_ . created_at AS created_at_145 , i16_ . updated_at AS updated_at_146 , i16_ . id AS id_147 , b17_ . position AS position_148 , b17_ . id AS id_149 , l18_ . text AS text_150 , l18_ . link AS link_151 , l18_ . created_at AS created_at_152 , l18_ . updated_at AS updated_at_153 , l18_ . id AS id_154 , p19_ . position AS position_155 , p19_ . id AS id_156 , s20_ . title AS title_157 , s20_ . subtitle AS subtitle_158 , s20_ . created_at AS created_at_159 , s20_ . updated_at AS updated_at_160 , s20_ . id AS id_161 , i21_ . name AS name_162 , i21_ . original_name AS original_name_163 , i21_ . size AS size_164 , i21_ . alt AS alt_165 , i21_ . source AS source_166 , i21_ . created_at AS created_at_167 , i21_ . updated_at AS updated_at_168 , i21_ . id AS id_169 , l22_ . text AS text_170 , l22_ . link AS link_171 , l22_ . created_at AS created_at_172 , l22_ . updated_at AS updated_at_173 , l22_ . id AS id_174 , v23_ . text AS text_175 , v23_ . link AS link_176 , v23_ . source AS source_177 , v23_ . created_at AS created_at_178 , v23_ . updated_at AS updated_at_179 , v23_ . id AS id_180 , f24_ . code AS code_181 , f24_ . created_at AS created_at_182 , f24_ . updated_at AS updated_at_183 , f24_ . id AS id_184 , p25_ . reference AS reference_185 , p25_ . created_at AS created_at_186 , p25_ . updated_at AS updated_at_187 , p25_ . id AS id_188 , p0_ . basis_id AS basis_id_189 , p0_ . family_id AS family_id_190 , p0_ . product_id AS product_id_191 , p0_ . banner_id AS banner_id_192 , p0_ . meta_id AS meta_id_193 , p0_ . slug_id AS slug_id_194 , m4_ . og_image_id AS og_image_id_195 , m4_ . twitter_image_id AS twitter_image_id_196 , b7_ . image_id AS image_id_197 , b7_ . link_id AS link_id_198 , b7_ . video_id AS video_id_199 , b7_ . basis_id AS basis_id_200 , b7_ . page_id AS page_id_201 , b8_ . image_id AS image_id_202 , b13_ . block_id AS block_id_203 , b13_ . download_id AS download_id_204 , b15_ . block_id AS block_id_205 , b15_ . image_id AS image_id_206 , b17_ . block_id AS block_id_207 , b17_ . link_id AS link_id_208 , p19_ . page_id AS page_id_209 , p19_ . slide_id AS slide_id_210 , s20_ . image_id AS image_id_211 , s20_ . link_id AS link_id_212 , s20_ . video_id AS video_id_213 , f24_ . page_id AS page_id_214 , p25_ . family_id AS family_id_215 , p25_ . page_id AS page_id_216 FROM PAGE p0_ LEFT JOIN page_basis p1_ ON p0_ . basis_id = p1_ . id AND (p1_ . deleted_at IS NULL ) LEFT JOIN image i2_ ON p0_ . banner_id = i2_ . id LEFT JOIN slug s3_ ON p0_ . slug_id = s3_ . id LEFT JOIN meta m4_ ON p0_ . meta_id = m4_ . id LEFT JOIN image i5_ ON m4_ . og_image_id = i5_ . id LEFT JOIN image i6_ ON m4_ . twitter_image_id = i6_ . id LEFT JOIN block b7_ ON p0_ . id = b7_ . page_id LEFT JOIN block_basis b8_ ON b7_ . basis_id = b8_ . id LEFT JOIN admin_image a9_ ON b8_ . image_id = a9_ . id LEFT JOIN image i10_ ON b7_ . image_id = i10_ . id LEFT JOIN link l11_ ON b7_ . link_id = l11_ . id LEFT JOIN video v12_ ON b7_ . video_id = v12_ . id LEFT JOIN block_download b13_ ON b7_ . id = b13_ . block_id LEFT JOIN download d14_ ON b13_ . download_id = d14_ . id LEFT JOIN block_image b15_ ON b7_ . id = b15_ . block_id LEFT JOIN image i16_ ON b15_ . image_id = i16_ . id LEFT JOIN block_link b17_ ON b7_ . id = b17_ . block_id LEFT JOIN link l18_ ON b17_ . link_id = l18_ . id LEFT JOIN page_slide p19_ ON p0_ . id = p19_ . page_id LEFT JOIN slide s20_ ON p19_ . slide_id = s20_ . id LEFT JOIN image i21_ ON s20_ . image_id = i21_ . id LEFT JOIN link l22_ ON s20_ . link_id = l22_ . id LEFT JOIN video v23_ ON s20_ . video_id = v23_ . id LEFT JOIN family f24_ ON p0_ . family_id = f24_ . id LEFT JOIN product p25_ ON p0_ . product_id = p25_ . id WHERE (p1_ . template = 'search' AND p1_ . static_page = 'yes' ) AND (p0_ . deleted_at IS NULL ) ORDER BY b7_ . position ASC , b13_ . position ASC , b15_ . position ASC , b17_ . position ASC , p19_ . position ASC LIMIT 1 ;
Copy
10
13.90 ms
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , s1_ . slug AS slug_11 , s1_ . class_name AS class_name_12 , s1_ . content_updated_at AS content_updated_at_13 , s1_ . created_at AS created_at_14 , s1_ . updated_at AS updated_at_15 , s1_ . id AS id_16 , p0_ . basis_id AS basis_id_17 , p0_ . family_id AS family_id_18 , p0_ . product_id AS product_id_19 , p0_ . banner_id AS banner_id_20 , p0_ . meta_id AS meta_id_21 , p0_ . slug_id AS slug_id_22 FROM PAGE p0_ LEFT JOIN slug s1_ ON p0_ . slug_id = s1_ . id LEFT JOIN page_basis p2_ ON p0_ . basis_id = p2_ . id AND (p2_ . deleted_at IS NULL ) WHERE (p0_ . active = ? AND p2_ . searchable = ? ) AND (p0_ . deleted_at IS NULL ) ORDER BY p0_ . title ASC
SELECT p0_ . title AS title_0 , p0_ . menu_title AS menu_title_1 , p0_ . content AS content_2 , p0_ . feature AS feature_3 , p0_ . published_at AS published_at_4 , p0_ . deleted_at AS deleted_at_5 , p0_ . position AS position_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . active AS active_9 , p0_ . id AS id_10 , s1_ . slug AS slug_11 , s1_ . class_name AS class_name_12 , s1_ . content_updated_at AS content_updated_at_13 , s1_ . created_at AS created_at_14 , s1_ . updated_at AS updated_at_15 , s1_ . id AS id_16 , p0_ . basis_id AS basis_id_17 , p0_ . family_id AS family_id_18 , p0_ . product_id AS product_id_19 , p0_ . banner_id AS banner_id_20 , p0_ . meta_id AS meta_id_21 , p0_ . slug_id AS slug_id_22 FROM PAGE p0_ LEFT JOIN slug s1_ ON p0_ . slug_id = s1_ . id LEFT JOIN page_basis p2_ ON p0_ . basis_id = p2_ . id AND (p2_ . deleted_at IS NULL ) WHERE (p0_ . active = 1 AND p2_ . searchable = 1 ) AND (p0_ . deleted_at IS NULL ) ORDER BY p0_ . title ASC ;
Copy
11
1.19 ms
SELECT t0 . title AS title_1 , t0 . template AS template_2 , t0 . allow_blocks AS allow_blocks_3 , t0 . allow_categories AS allow_categories_4 , t0 . static_page AS static_page_5 , t0 . banner_image AS banner_image_6 , t0 . slider AS slider_7 , t0 . content AS content_8 , t0 . duplicable AS duplicable_9 , t0 . deletable AS deletable_10 , t0 . searchable AS searchable_11 , t0 . featurable AS featurable_12 , t0 . sortable AS sortable_13 , t0 . exportable AS exportable_14 , t0 . has_downloads AS has_downloads_15 , t0 . has_images AS has_images_16 , t0 . family AS family_17 , t0 . product AS product_18 , t0 . publishable AS publishable_19 , t0 . tagged AS tagged_20 , t0 . meta_title AS meta_title_21 , t0 . meta_description AS meta_description_22 , t0 . deleted_at AS deleted_at_23 , t0 . created_at AS created_at_24 , t0 . updated_at AS updated_at_25 , t0 . id AS id_26 FROM page_basis t0 WHERE t0 . template = ? AND ((t0 . deleted_at IS NULL )) LIMIT 1
Parameters :
[
"legalpage "
]
SELECT t0 . title AS title_1 , t0 . template AS template_2 , t0 . allow_blocks AS allow_blocks_3 , t0 . allow_categories AS allow_categories_4 , t0 . static_page AS static_page_5 , t0 . banner_image AS banner_image_6 , t0 . slider AS slider_7 , t0 . content AS content_8 , t0 . duplicable AS duplicable_9 , t0 . deletable AS deletable_10 , t0 . searchable AS searchable_11 , t0 . featurable AS featurable_12 , t0 . sortable AS sortable_13 , t0 . exportable AS exportable_14 , t0 . has_downloads AS has_downloads_15 , t0 . has_images AS has_images_16 , t0 . family AS family_17 , t0 . product AS product_18 , t0 . publishable AS publishable_19 , t0 . tagged AS tagged_20 , t0 . meta_title AS meta_title_21 , t0 . meta_description AS meta_description_22 , t0 . deleted_at AS deleted_at_23 , t0 . created_at AS created_at_24 , t0 . updated_at AS updated_at_25 , t0 . id AS id_26 FROM page_basis t0 WHERE t0 . template = 'legalpage' AND ((t0 . deleted_at IS NULL )) LIMIT 1 ;
Copy
12
1.29 ms
SELECT t0 . title AS title_1 , t0 . menu_title AS menu_title_2 , t0 . content AS content_3 , t0 . feature AS feature_4 , t0 . published_at AS published_at_5 , t0 . deleted_at AS deleted_at_6 , t0 . position AS position_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . active AS active_10 , t0 . id AS id_11 , t0 . basis_id AS basis_id_12 , t0 . family_id AS family_id_13 , t0 . product_id AS product_id_14 , t0 . banner_id AS banner_id_15 , t0 . meta_id AS meta_id_16 , t0 . slug_id AS slug_id_17 FROM PAGE t0 WHERE t0 . active = ? AND t0 . basis_id = ? AND ((t0 . deleted_at IS NULL )) ORDER BY t0 . title ASC
Parameters :
[
1
"018ee149-8e70-7161-ad87-f467f08549f2 "
]
SELECT t0 . title AS title_1 , t0 . menu_title AS menu_title_2 , t0 . content AS content_3 , t0 . feature AS feature_4 , t0 . published_at AS published_at_5 , t0 . deleted_at AS deleted_at_6 , t0 . position AS position_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . active AS active_10 , t0 . id AS id_11 , t0 . basis_id AS basis_id_12 , t0 . family_id AS family_id_13 , t0 . product_id AS product_id_14 , t0 . banner_id AS banner_id_15 , t0 . meta_id AS meta_id_16 , t0 . slug_id AS slug_id_17 FROM PAGE t0 WHERE t0 . active = 1 AND t0 . basis_id = '018ee149-8e70-7161-ad87-f467f08549f2' AND ((t0 . deleted_at IS NULL )) ORDER BY t0 . title ASC ;
Copy
13
1.07 ms
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = ?
Parameters :
[
"018ee149-9ff0-70df-9a1d-d5417acc1624 "
]
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = '018ee149-9ff0-70df-9a1d-d5417acc1624' ;
Copy
14
0.87 ms
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = ?
Parameters :
[
"018ee149-9ff1-7e1b-8ea3-d44f3f2a435e "
]
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = '018ee149-9ff1-7e1b-8ea3-d44f3f2a435e' ;
Copy
15
0.79 ms
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = ?
Parameters :
[
"018ee149-9fee-7568-aa9c-0ceaba38923a "
]
SELECT t0 . slug AS slug_1 , t0 . class_name AS class_name_2 , t0 . content_updated_at AS content_updated_at_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . id AS id_6 FROM slug t0 WHERE t0 . id = '018ee149-9fee-7568-aa9c-0ceaba38923a' ;
Copy
16
1.35 ms
SELECT t0 . text AS text_1 , t0 . link AS link_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . id AS id_5 , t0 . deleted_at AS deleted_at_6 , t0 . position AS position_7 , t0 . active AS active_8 FROM seolink t0 WHERE t0 . active = ? AND ((t0 . deleted_at IS NULL )) ORDER BY t0 . position ASC
SELECT t0 . text AS text_1 , t0 . link AS link_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . id AS id_5 , t0 . deleted_at AS deleted_at_6 , t0 . position AS position_7 , t0 . active AS active_8 FROM seolink t0 WHERE t0 . active = 1 AND ((t0 . deleted_at IS NULL )) ORDER BY t0 . position ASC ;
Copy