| 1 |
9.69 ms |
SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC
SELECT
c0_.name AS name_0,
c0_.host AS host_1,
c0_.class AS class_2,
c0_.main AS main_3,
c0_.order_code AS order_code_4,
c0_.messages AS messages_5,
c0_.sections AS sections_6,
c0_.deleted_at AS deleted_at_7,
c0_.created_at AS created_at_8,
c0_.updated_at AS updated_at_9,
c0_.id AS id_10,
p1_.name AS name_11,
p1_.full_name AS full_name_12,
p1_.content AS content_13,
p1_.description AS description_14,
p1_.initial_price AS initial_price_15,
p1_.recurring_price AS recurring_price_16,
p1_.color AS color_17,
p1_.initial AS initial_18,
p1_.nutriwell AS nutriwell_19,
p1_.chronotype AS chronotype_20,
p1_.recipes AS recipes_21,
p1_.tips AS tips_22,
p1_.nutritional_program AS nutritional_program_23,
p1_.supplementation_program AS supplementation_program_24,
p1_.nutritionist AS nutritionist_25,
p1_.inbody AS inbody_26,
p1_.ages AS ages_27,
p1_.lipidomic AS lipidomic_28,
p1_.vital_status AS vital_status_29,
p1_.contact AS contact_30,
p1_.duration AS duration_31,
p1_.needs_blood_extraction AS needs_blood_extraction_32,
p1_.has_appointments AS has_appointments_33,
p1_.lipiwell_id AS lipiwell_id_34,
p1_.position AS position_35,
p1_.created_at AS created_at_36,
p1_.updated_at AS updated_at_37,
p1_.active AS active_38,
p1_.id AS id_39,
p2_.title AS title_40,
p2_.menu_title AS menu_title_41,
p2_.content AS content_42,
p2_.feature AS feature_43,
p2_.published_at AS published_at_44,
p2_.deleted_at AS deleted_at_45,
p2_.position AS position_46,
p2_.created_at AS created_at_47,
p2_.updated_at AS updated_at_48,
p2_.active AS active_49,
p2_.id AS id_50,
s3_.slug AS slug_51,
s3_.class_name AS class_name_52,
s3_.content_updated_at AS content_updated_at_53,
s3_.created_at AS created_at_54,
s3_.updated_at AS updated_at_55,
s3_.id AS id_56,
p1_.basis_id AS basis_id_57,
p1_.image_id AS image_id_58,
p1_.page_id AS page_id_59,
p2_.basis_id AS basis_id_60,
p2_.banner_id AS banner_id_61,
p2_.company_id AS company_id_62,
p2_.plan_id AS plan_id_63,
p2_.meta_id AS meta_id_64,
p2_.slug_id AS slug_id_65
FROM
company c0_
LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id
LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id
LEFT JOIN page p2_ ON p1_.page_id = p2_.id
AND (p2_.deleted_at IS NULL)
LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id
ORDER BY
p1_.lipiwell_id ASC
SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC;
|
| 2 |
19.17 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 = 'pro' LIMIT 1;
|
| 3 |
980.63 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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p0_.slug_id = ?) AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.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_.publishable AS publishable_27,
p1_.planable AS planable_28,
p1_.meta_title AS meta_title_29,
p1_.meta_description AS meta_description_30,
p1_.deleted_at AS deleted_at_31,
p1_.created_at AS created_at_32,
p1_.updated_at AS updated_at_33,
p1_.id AS id_34,
i2_.name AS name_35,
i2_.original_name AS original_name_36,
i2_.size AS size_37,
i2_.alt AS alt_38,
i2_.source AS source_39,
i2_.created_at AS created_at_40,
i2_.updated_at AS updated_at_41,
i2_.id AS id_42,
s3_.slug AS slug_43,
s3_.class_name AS class_name_44,
s3_.content_updated_at AS content_updated_at_45,
s3_.created_at AS created_at_46,
s3_.updated_at AS updated_at_47,
s3_.id AS id_48,
m4_.keywords AS keywords_49,
m4_.meta_title AS meta_title_50,
m4_.meta_description AS meta_description_51,
m4_.og_title AS og_title_52,
m4_.og_description AS og_description_53,
m4_.twitter_title AS twitter_title_54,
m4_.twitter_description AS twitter_description_55,
m4_.robots_index AS robots_index_56,
m4_.created_at AS created_at_57,
m4_.updated_at AS updated_at_58,
m4_.id AS id_59,
i5_.name AS name_60,
i5_.original_name AS original_name_61,
i5_.size AS size_62,
i5_.alt AS alt_63,
i5_.source AS source_64,
i5_.created_at AS created_at_65,
i5_.updated_at AS updated_at_66,
i5_.id AS id_67,
i6_.name AS name_68,
i6_.original_name AS original_name_69,
i6_.size AS size_70,
i6_.alt AS alt_71,
i6_.source AS source_72,
i6_.created_at AS created_at_73,
i6_.updated_at AS updated_at_74,
i6_.id AS id_75,
b7_.is_wide AS is_wide_76,
b7_.title AS title_77,
b7_.content AS content_78,
b7_.numbered AS numbered_79,
b7_.anchor AS anchor_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_background AS has_background_92,
b8_.has_image AS has_image_93,
b8_.has_link AS has_link_94,
b8_.has_video AS has_video_95,
b8_.has_downloads AS has_downloads_96,
b8_.has_images AS has_images_97,
b8_.has_links AS has_links_98,
b8_.has_subsections AS has_subsections_99,
b8_.has_three_columns AS has_three_columns_100,
b8_.has_anchor AS has_anchor_101,
b8_.created_at AS created_at_102,
b8_.updated_at AS updated_at_103,
b8_.active AS active_104,
b8_.id AS id_105,
i9_.name AS name_106,
i9_.original_name AS original_name_107,
i9_.size AS size_108,
i9_.alt AS alt_109,
i9_.source AS source_110,
i9_.created_at AS created_at_111,
i9_.updated_at AS updated_at_112,
i9_.id AS id_113,
i10_.name AS name_114,
i10_.original_name AS original_name_115,
i10_.size AS size_116,
i10_.alt AS alt_117,
i10_.source AS source_118,
i10_.created_at AS created_at_119,
i10_.updated_at AS updated_at_120,
i10_.id AS id_121,
i11_.name AS name_122,
i11_.original_name AS original_name_123,
i11_.size AS size_124,
i11_.alt AS alt_125,
i11_.source AS source_126,
i11_.created_at AS created_at_127,
i11_.updated_at AS updated_at_128,
i11_.id AS id_129,
l12_.text AS text_130,
l12_.link AS link_131,
l12_.created_at AS created_at_132,
l12_.updated_at AS updated_at_133,
l12_.id AS id_134,
v13_.text AS text_135,
v13_.link AS link_136,
v13_.source AS source_137,
v13_.created_at AS created_at_138,
v13_.updated_at AS updated_at_139,
v13_.id AS id_140,
b14_.position AS position_141,
b14_.id AS id_142,
d15_.name AS name_143,
d15_.original_name AS original_name_144,
d15_.size AS size_145,
d15_.text AS text_146,
d15_.created_at AS created_at_147,
d15_.updated_at AS updated_at_148,
d15_.id AS id_149,
b16_.position AS position_150,
b16_.id AS id_151,
i17_.name AS name_152,
i17_.original_name AS original_name_153,
i17_.size AS size_154,
i17_.alt AS alt_155,
i17_.source AS source_156,
i17_.created_at AS created_at_157,
i17_.updated_at AS updated_at_158,
i17_.id AS id_159,
b18_.position AS position_160,
b18_.id AS id_161,
l19_.text AS text_162,
l19_.link AS link_163,
l19_.created_at AS created_at_164,
l19_.updated_at AS updated_at_165,
l19_.id AS id_166,
p20_.position AS position_167,
p20_.id AS id_168,
s21_.title AS title_169,
s21_.subtitle AS subtitle_170,
s21_.created_at AS created_at_171,
s21_.updated_at AS updated_at_172,
s21_.id AS id_173,
i22_.name AS name_174,
i22_.original_name AS original_name_175,
i22_.size AS size_176,
i22_.alt AS alt_177,
i22_.source AS source_178,
i22_.created_at AS created_at_179,
i22_.updated_at AS updated_at_180,
i22_.id AS id_181,
l23_.text AS text_182,
l23_.link AS link_183,
l23_.created_at AS created_at_184,
l23_.updated_at AS updated_at_185,
l23_.id AS id_186,
v24_.text AS text_187,
v24_.link AS link_188,
v24_.source AS source_189,
v24_.created_at AS created_at_190,
v24_.updated_at AS updated_at_191,
v24_.id AS id_192,
p0_.basis_id AS basis_id_193,
p0_.banner_id AS banner_id_194,
p0_.company_id AS company_id_195,
p0_.plan_id AS plan_id_196,
p0_.meta_id AS meta_id_197,
p0_.slug_id AS slug_id_198,
m4_.og_image_id AS og_image_id_199,
m4_.twitter_image_id AS twitter_image_id_200,
b7_.background_id AS background_id_201,
b7_.image_id AS image_id_202,
b7_.link_id AS link_id_203,
b7_.video_id AS video_id_204,
b7_.basis_id AS basis_id_205,
b7_.page_id AS page_id_206,
b7_.lipiwell_content_id AS lipiwell_content_id_207,
b8_.image_id AS image_id_208,
b14_.block_id AS block_id_209,
b14_.download_id AS download_id_210,
b16_.block_id AS block_id_211,
b16_.image_id AS image_id_212,
b18_.block_id AS block_id_213,
b18_.link_id AS link_id_214,
p20_.page_id AS page_id_215,
p20_.slide_id AS slide_id_216,
s21_.image_id AS image_id_217,
s21_.link_id AS link_id_218,
s21_.video_id AS video_id_219
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 image i9_ ON b8_.image_id = i9_.id
LEFT JOIN image i10_ ON b7_.background_id = i10_.id
LEFT JOIN image i11_ ON b7_.image_id = i11_.id
LEFT JOIN link l12_ ON b7_.link_id = l12_.id
LEFT JOIN video v13_ ON b7_.video_id = v13_.id
LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id
LEFT JOIN download d15_ ON b14_.download_id = d15_.id
LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id
LEFT JOIN image i17_ ON b16_.image_id = i17_.id
LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id
LEFT JOIN link l19_ ON b18_.link_id = l19_.id
LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id
LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id
LEFT JOIN image i22_ ON s21_.image_id = i22_.id
LEFT JOIN link l23_ ON s21_.link_id = l23_.id
LEFT JOIN video v24_ ON s21_.video_id = v24_.id
WHERE
(p0_.slug_id = ?)
AND (p0_.deleted_at IS NULL)
ORDER BY
b7_.position ASC,
b14_.position ASC,
b16_.position ASC,
b18_.position ASC,
p20_.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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p0_.slug_id = '0193c01e-3977-76f1-82ad-d3ad167e24e5') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.position ASC;
|
| 4 |
108.76 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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p1_.template = ? AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.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_.publishable AS publishable_27,
p1_.planable AS planable_28,
p1_.meta_title AS meta_title_29,
p1_.meta_description AS meta_description_30,
p1_.deleted_at AS deleted_at_31,
p1_.created_at AS created_at_32,
p1_.updated_at AS updated_at_33,
p1_.id AS id_34,
i2_.name AS name_35,
i2_.original_name AS original_name_36,
i2_.size AS size_37,
i2_.alt AS alt_38,
i2_.source AS source_39,
i2_.created_at AS created_at_40,
i2_.updated_at AS updated_at_41,
i2_.id AS id_42,
s3_.slug AS slug_43,
s3_.class_name AS class_name_44,
s3_.content_updated_at AS content_updated_at_45,
s3_.created_at AS created_at_46,
s3_.updated_at AS updated_at_47,
s3_.id AS id_48,
m4_.keywords AS keywords_49,
m4_.meta_title AS meta_title_50,
m4_.meta_description AS meta_description_51,
m4_.og_title AS og_title_52,
m4_.og_description AS og_description_53,
m4_.twitter_title AS twitter_title_54,
m4_.twitter_description AS twitter_description_55,
m4_.robots_index AS robots_index_56,
m4_.created_at AS created_at_57,
m4_.updated_at AS updated_at_58,
m4_.id AS id_59,
i5_.name AS name_60,
i5_.original_name AS original_name_61,
i5_.size AS size_62,
i5_.alt AS alt_63,
i5_.source AS source_64,
i5_.created_at AS created_at_65,
i5_.updated_at AS updated_at_66,
i5_.id AS id_67,
i6_.name AS name_68,
i6_.original_name AS original_name_69,
i6_.size AS size_70,
i6_.alt AS alt_71,
i6_.source AS source_72,
i6_.created_at AS created_at_73,
i6_.updated_at AS updated_at_74,
i6_.id AS id_75,
b7_.is_wide AS is_wide_76,
b7_.title AS title_77,
b7_.content AS content_78,
b7_.numbered AS numbered_79,
b7_.anchor AS anchor_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_background AS has_background_92,
b8_.has_image AS has_image_93,
b8_.has_link AS has_link_94,
b8_.has_video AS has_video_95,
b8_.has_downloads AS has_downloads_96,
b8_.has_images AS has_images_97,
b8_.has_links AS has_links_98,
b8_.has_subsections AS has_subsections_99,
b8_.has_three_columns AS has_three_columns_100,
b8_.has_anchor AS has_anchor_101,
b8_.created_at AS created_at_102,
b8_.updated_at AS updated_at_103,
b8_.active AS active_104,
b8_.id AS id_105,
i9_.name AS name_106,
i9_.original_name AS original_name_107,
i9_.size AS size_108,
i9_.alt AS alt_109,
i9_.source AS source_110,
i9_.created_at AS created_at_111,
i9_.updated_at AS updated_at_112,
i9_.id AS id_113,
i10_.name AS name_114,
i10_.original_name AS original_name_115,
i10_.size AS size_116,
i10_.alt AS alt_117,
i10_.source AS source_118,
i10_.created_at AS created_at_119,
i10_.updated_at AS updated_at_120,
i10_.id AS id_121,
i11_.name AS name_122,
i11_.original_name AS original_name_123,
i11_.size AS size_124,
i11_.alt AS alt_125,
i11_.source AS source_126,
i11_.created_at AS created_at_127,
i11_.updated_at AS updated_at_128,
i11_.id AS id_129,
l12_.text AS text_130,
l12_.link AS link_131,
l12_.created_at AS created_at_132,
l12_.updated_at AS updated_at_133,
l12_.id AS id_134,
v13_.text AS text_135,
v13_.link AS link_136,
v13_.source AS source_137,
v13_.created_at AS created_at_138,
v13_.updated_at AS updated_at_139,
v13_.id AS id_140,
b14_.position AS position_141,
b14_.id AS id_142,
d15_.name AS name_143,
d15_.original_name AS original_name_144,
d15_.size AS size_145,
d15_.text AS text_146,
d15_.created_at AS created_at_147,
d15_.updated_at AS updated_at_148,
d15_.id AS id_149,
b16_.position AS position_150,
b16_.id AS id_151,
i17_.name AS name_152,
i17_.original_name AS original_name_153,
i17_.size AS size_154,
i17_.alt AS alt_155,
i17_.source AS source_156,
i17_.created_at AS created_at_157,
i17_.updated_at AS updated_at_158,
i17_.id AS id_159,
b18_.position AS position_160,
b18_.id AS id_161,
l19_.text AS text_162,
l19_.link AS link_163,
l19_.created_at AS created_at_164,
l19_.updated_at AS updated_at_165,
l19_.id AS id_166,
p20_.position AS position_167,
p20_.id AS id_168,
s21_.title AS title_169,
s21_.subtitle AS subtitle_170,
s21_.created_at AS created_at_171,
s21_.updated_at AS updated_at_172,
s21_.id AS id_173,
i22_.name AS name_174,
i22_.original_name AS original_name_175,
i22_.size AS size_176,
i22_.alt AS alt_177,
i22_.source AS source_178,
i22_.created_at AS created_at_179,
i22_.updated_at AS updated_at_180,
i22_.id AS id_181,
l23_.text AS text_182,
l23_.link AS link_183,
l23_.created_at AS created_at_184,
l23_.updated_at AS updated_at_185,
l23_.id AS id_186,
v24_.text AS text_187,
v24_.link AS link_188,
v24_.source AS source_189,
v24_.created_at AS created_at_190,
v24_.updated_at AS updated_at_191,
v24_.id AS id_192,
p0_.basis_id AS basis_id_193,
p0_.banner_id AS banner_id_194,
p0_.company_id AS company_id_195,
p0_.plan_id AS plan_id_196,
p0_.meta_id AS meta_id_197,
p0_.slug_id AS slug_id_198,
m4_.og_image_id AS og_image_id_199,
m4_.twitter_image_id AS twitter_image_id_200,
b7_.background_id AS background_id_201,
b7_.image_id AS image_id_202,
b7_.link_id AS link_id_203,
b7_.video_id AS video_id_204,
b7_.basis_id AS basis_id_205,
b7_.page_id AS page_id_206,
b7_.lipiwell_content_id AS lipiwell_content_id_207,
b8_.image_id AS image_id_208,
b14_.block_id AS block_id_209,
b14_.download_id AS download_id_210,
b16_.block_id AS block_id_211,
b16_.image_id AS image_id_212,
b18_.block_id AS block_id_213,
b18_.link_id AS link_id_214,
p20_.page_id AS page_id_215,
p20_.slide_id AS slide_id_216,
s21_.image_id AS image_id_217,
s21_.link_id AS link_id_218,
s21_.video_id AS video_id_219
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 image i9_ ON b8_.image_id = i9_.id
LEFT JOIN image i10_ ON b7_.background_id = i10_.id
LEFT JOIN image i11_ ON b7_.image_id = i11_.id
LEFT JOIN link l12_ ON b7_.link_id = l12_.id
LEFT JOIN video v13_ ON b7_.video_id = v13_.id
LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id
LEFT JOIN download d15_ ON b14_.download_id = d15_.id
LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id
LEFT JOIN image i17_ ON b16_.image_id = i17_.id
LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id
LEFT JOIN link l19_ ON b18_.link_id = l19_.id
LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id
LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id
LEFT JOIN image i22_ ON s21_.image_id = i22_.id
LEFT JOIN link l23_ ON s21_.link_id = l23_.id
LEFT JOIN video v24_ ON s21_.video_id = v24_.id
WHERE
(
p1_.template = ?
AND p1_.static_page = 'yes'
)
AND (p0_.deleted_at IS NULL)
ORDER BY
b7_.position ASC,
b14_.position ASC,
b16_.position ASC,
b18_.position ASC,
p20_.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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p1_.template = 'home' AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.position ASC LIMIT 1;
|
| 5 |
100.87 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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p1_.template = ? AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.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_.publishable AS publishable_27,
p1_.planable AS planable_28,
p1_.meta_title AS meta_title_29,
p1_.meta_description AS meta_description_30,
p1_.deleted_at AS deleted_at_31,
p1_.created_at AS created_at_32,
p1_.updated_at AS updated_at_33,
p1_.id AS id_34,
i2_.name AS name_35,
i2_.original_name AS original_name_36,
i2_.size AS size_37,
i2_.alt AS alt_38,
i2_.source AS source_39,
i2_.created_at AS created_at_40,
i2_.updated_at AS updated_at_41,
i2_.id AS id_42,
s3_.slug AS slug_43,
s3_.class_name AS class_name_44,
s3_.content_updated_at AS content_updated_at_45,
s3_.created_at AS created_at_46,
s3_.updated_at AS updated_at_47,
s3_.id AS id_48,
m4_.keywords AS keywords_49,
m4_.meta_title AS meta_title_50,
m4_.meta_description AS meta_description_51,
m4_.og_title AS og_title_52,
m4_.og_description AS og_description_53,
m4_.twitter_title AS twitter_title_54,
m4_.twitter_description AS twitter_description_55,
m4_.robots_index AS robots_index_56,
m4_.created_at AS created_at_57,
m4_.updated_at AS updated_at_58,
m4_.id AS id_59,
i5_.name AS name_60,
i5_.original_name AS original_name_61,
i5_.size AS size_62,
i5_.alt AS alt_63,
i5_.source AS source_64,
i5_.created_at AS created_at_65,
i5_.updated_at AS updated_at_66,
i5_.id AS id_67,
i6_.name AS name_68,
i6_.original_name AS original_name_69,
i6_.size AS size_70,
i6_.alt AS alt_71,
i6_.source AS source_72,
i6_.created_at AS created_at_73,
i6_.updated_at AS updated_at_74,
i6_.id AS id_75,
b7_.is_wide AS is_wide_76,
b7_.title AS title_77,
b7_.content AS content_78,
b7_.numbered AS numbered_79,
b7_.anchor AS anchor_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_background AS has_background_92,
b8_.has_image AS has_image_93,
b8_.has_link AS has_link_94,
b8_.has_video AS has_video_95,
b8_.has_downloads AS has_downloads_96,
b8_.has_images AS has_images_97,
b8_.has_links AS has_links_98,
b8_.has_subsections AS has_subsections_99,
b8_.has_three_columns AS has_three_columns_100,
b8_.has_anchor AS has_anchor_101,
b8_.created_at AS created_at_102,
b8_.updated_at AS updated_at_103,
b8_.active AS active_104,
b8_.id AS id_105,
i9_.name AS name_106,
i9_.original_name AS original_name_107,
i9_.size AS size_108,
i9_.alt AS alt_109,
i9_.source AS source_110,
i9_.created_at AS created_at_111,
i9_.updated_at AS updated_at_112,
i9_.id AS id_113,
i10_.name AS name_114,
i10_.original_name AS original_name_115,
i10_.size AS size_116,
i10_.alt AS alt_117,
i10_.source AS source_118,
i10_.created_at AS created_at_119,
i10_.updated_at AS updated_at_120,
i10_.id AS id_121,
i11_.name AS name_122,
i11_.original_name AS original_name_123,
i11_.size AS size_124,
i11_.alt AS alt_125,
i11_.source AS source_126,
i11_.created_at AS created_at_127,
i11_.updated_at AS updated_at_128,
i11_.id AS id_129,
l12_.text AS text_130,
l12_.link AS link_131,
l12_.created_at AS created_at_132,
l12_.updated_at AS updated_at_133,
l12_.id AS id_134,
v13_.text AS text_135,
v13_.link AS link_136,
v13_.source AS source_137,
v13_.created_at AS created_at_138,
v13_.updated_at AS updated_at_139,
v13_.id AS id_140,
b14_.position AS position_141,
b14_.id AS id_142,
d15_.name AS name_143,
d15_.original_name AS original_name_144,
d15_.size AS size_145,
d15_.text AS text_146,
d15_.created_at AS created_at_147,
d15_.updated_at AS updated_at_148,
d15_.id AS id_149,
b16_.position AS position_150,
b16_.id AS id_151,
i17_.name AS name_152,
i17_.original_name AS original_name_153,
i17_.size AS size_154,
i17_.alt AS alt_155,
i17_.source AS source_156,
i17_.created_at AS created_at_157,
i17_.updated_at AS updated_at_158,
i17_.id AS id_159,
b18_.position AS position_160,
b18_.id AS id_161,
l19_.text AS text_162,
l19_.link AS link_163,
l19_.created_at AS created_at_164,
l19_.updated_at AS updated_at_165,
l19_.id AS id_166,
p20_.position AS position_167,
p20_.id AS id_168,
s21_.title AS title_169,
s21_.subtitle AS subtitle_170,
s21_.created_at AS created_at_171,
s21_.updated_at AS updated_at_172,
s21_.id AS id_173,
i22_.name AS name_174,
i22_.original_name AS original_name_175,
i22_.size AS size_176,
i22_.alt AS alt_177,
i22_.source AS source_178,
i22_.created_at AS created_at_179,
i22_.updated_at AS updated_at_180,
i22_.id AS id_181,
l23_.text AS text_182,
l23_.link AS link_183,
l23_.created_at AS created_at_184,
l23_.updated_at AS updated_at_185,
l23_.id AS id_186,
v24_.text AS text_187,
v24_.link AS link_188,
v24_.source AS source_189,
v24_.created_at AS created_at_190,
v24_.updated_at AS updated_at_191,
v24_.id AS id_192,
p0_.basis_id AS basis_id_193,
p0_.banner_id AS banner_id_194,
p0_.company_id AS company_id_195,
p0_.plan_id AS plan_id_196,
p0_.meta_id AS meta_id_197,
p0_.slug_id AS slug_id_198,
m4_.og_image_id AS og_image_id_199,
m4_.twitter_image_id AS twitter_image_id_200,
b7_.background_id AS background_id_201,
b7_.image_id AS image_id_202,
b7_.link_id AS link_id_203,
b7_.video_id AS video_id_204,
b7_.basis_id AS basis_id_205,
b7_.page_id AS page_id_206,
b7_.lipiwell_content_id AS lipiwell_content_id_207,
b8_.image_id AS image_id_208,
b14_.block_id AS block_id_209,
b14_.download_id AS download_id_210,
b16_.block_id AS block_id_211,
b16_.image_id AS image_id_212,
b18_.block_id AS block_id_213,
b18_.link_id AS link_id_214,
p20_.page_id AS page_id_215,
p20_.slide_id AS slide_id_216,
s21_.image_id AS image_id_217,
s21_.link_id AS link_id_218,
s21_.video_id AS video_id_219
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 image i9_ ON b8_.image_id = i9_.id
LEFT JOIN image i10_ ON b7_.background_id = i10_.id
LEFT JOIN image i11_ ON b7_.image_id = i11_.id
LEFT JOIN link l12_ ON b7_.link_id = l12_.id
LEFT JOIN video v13_ ON b7_.video_id = v13_.id
LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id
LEFT JOIN download d15_ ON b14_.download_id = d15_.id
LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id
LEFT JOIN image i17_ ON b16_.image_id = i17_.id
LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id
LEFT JOIN link l19_ ON b18_.link_id = l19_.id
LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id
LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id
LEFT JOIN image i22_ ON s21_.image_id = i22_.id
LEFT JOIN link l23_ ON s21_.link_id = l23_.id
LEFT JOIN video v24_ ON s21_.video_id = v24_.id
WHERE
(
p1_.template = ?
AND p1_.static_page = 'yes'
)
AND (p0_.deleted_at IS NULL)
ORDER BY
b7_.position ASC,
b14_.position ASC,
b16_.position ASC,
b18_.position ASC,
p20_.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_.publishable AS publishable_27, p1_.planable AS planable_28, p1_.meta_title AS meta_title_29, p1_.meta_description AS meta_description_30, p1_.deleted_at AS deleted_at_31, p1_.created_at AS created_at_32, p1_.updated_at AS updated_at_33, p1_.id AS id_34, i2_.name AS name_35, i2_.original_name AS original_name_36, i2_.size AS size_37, i2_.alt AS alt_38, i2_.source AS source_39, i2_.created_at AS created_at_40, i2_.updated_at AS updated_at_41, i2_.id AS id_42, s3_.slug AS slug_43, s3_.class_name AS class_name_44, s3_.content_updated_at AS content_updated_at_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s3_.id AS id_48, m4_.keywords AS keywords_49, m4_.meta_title AS meta_title_50, m4_.meta_description AS meta_description_51, m4_.og_title AS og_title_52, m4_.og_description AS og_description_53, m4_.twitter_title AS twitter_title_54, m4_.twitter_description AS twitter_description_55, m4_.robots_index AS robots_index_56, m4_.created_at AS created_at_57, m4_.updated_at AS updated_at_58, m4_.id AS id_59, i5_.name AS name_60, i5_.original_name AS original_name_61, i5_.size AS size_62, i5_.alt AS alt_63, i5_.source AS source_64, i5_.created_at AS created_at_65, i5_.updated_at AS updated_at_66, i5_.id AS id_67, i6_.name AS name_68, i6_.original_name AS original_name_69, i6_.size AS size_70, i6_.alt AS alt_71, i6_.source AS source_72, i6_.created_at AS created_at_73, i6_.updated_at AS updated_at_74, i6_.id AS id_75, b7_.is_wide AS is_wide_76, b7_.title AS title_77, b7_.content AS content_78, b7_.numbered AS numbered_79, b7_.anchor AS anchor_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_background AS has_background_92, b8_.has_image AS has_image_93, b8_.has_link AS has_link_94, b8_.has_video AS has_video_95, b8_.has_downloads AS has_downloads_96, b8_.has_images AS has_images_97, b8_.has_links AS has_links_98, b8_.has_subsections AS has_subsections_99, b8_.has_three_columns AS has_three_columns_100, b8_.has_anchor AS has_anchor_101, b8_.created_at AS created_at_102, b8_.updated_at AS updated_at_103, b8_.active AS active_104, b8_.id AS id_105, i9_.name AS name_106, i9_.original_name AS original_name_107, i9_.size AS size_108, i9_.alt AS alt_109, i9_.source AS source_110, i9_.created_at AS created_at_111, i9_.updated_at AS updated_at_112, i9_.id AS id_113, i10_.name AS name_114, i10_.original_name AS original_name_115, i10_.size AS size_116, i10_.alt AS alt_117, i10_.source AS source_118, i10_.created_at AS created_at_119, i10_.updated_at AS updated_at_120, i10_.id AS id_121, i11_.name AS name_122, i11_.original_name AS original_name_123, i11_.size AS size_124, i11_.alt AS alt_125, i11_.source AS source_126, i11_.created_at AS created_at_127, i11_.updated_at AS updated_at_128, i11_.id AS id_129, l12_.text AS text_130, l12_.link AS link_131, l12_.created_at AS created_at_132, l12_.updated_at AS updated_at_133, l12_.id AS id_134, v13_.text AS text_135, v13_.link AS link_136, v13_.source AS source_137, v13_.created_at AS created_at_138, v13_.updated_at AS updated_at_139, v13_.id AS id_140, b14_.position AS position_141, b14_.id AS id_142, d15_.name AS name_143, d15_.original_name AS original_name_144, d15_.size AS size_145, d15_.text AS text_146, d15_.created_at AS created_at_147, d15_.updated_at AS updated_at_148, d15_.id AS id_149, b16_.position AS position_150, b16_.id AS id_151, i17_.name AS name_152, i17_.original_name AS original_name_153, i17_.size AS size_154, i17_.alt AS alt_155, i17_.source AS source_156, i17_.created_at AS created_at_157, i17_.updated_at AS updated_at_158, i17_.id AS id_159, b18_.position AS position_160, b18_.id AS id_161, l19_.text AS text_162, l19_.link AS link_163, l19_.created_at AS created_at_164, l19_.updated_at AS updated_at_165, l19_.id AS id_166, p20_.position AS position_167, p20_.id AS id_168, s21_.title AS title_169, s21_.subtitle AS subtitle_170, s21_.created_at AS created_at_171, s21_.updated_at AS updated_at_172, s21_.id AS id_173, i22_.name AS name_174, i22_.original_name AS original_name_175, i22_.size AS size_176, i22_.alt AS alt_177, i22_.source AS source_178, i22_.created_at AS created_at_179, i22_.updated_at AS updated_at_180, i22_.id AS id_181, l23_.text AS text_182, l23_.link AS link_183, l23_.created_at AS created_at_184, l23_.updated_at AS updated_at_185, l23_.id AS id_186, v24_.text AS text_187, v24_.link AS link_188, v24_.source AS source_189, v24_.created_at AS created_at_190, v24_.updated_at AS updated_at_191, v24_.id AS id_192, p0_.basis_id AS basis_id_193, p0_.banner_id AS banner_id_194, p0_.company_id AS company_id_195, p0_.plan_id AS plan_id_196, p0_.meta_id AS meta_id_197, p0_.slug_id AS slug_id_198, m4_.og_image_id AS og_image_id_199, m4_.twitter_image_id AS twitter_image_id_200, b7_.background_id AS background_id_201, b7_.image_id AS image_id_202, b7_.link_id AS link_id_203, b7_.video_id AS video_id_204, b7_.basis_id AS basis_id_205, b7_.page_id AS page_id_206, b7_.lipiwell_content_id AS lipiwell_content_id_207, b8_.image_id AS image_id_208, b14_.block_id AS block_id_209, b14_.download_id AS download_id_210, b16_.block_id AS block_id_211, b16_.image_id AS image_id_212, b18_.block_id AS block_id_213, b18_.link_id AS link_id_214, p20_.page_id AS page_id_215, p20_.slide_id AS slide_id_216, s21_.image_id AS image_id_217, s21_.link_id AS link_id_218, s21_.video_id AS video_id_219 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 image i9_ ON b8_.image_id = i9_.id LEFT JOIN image i10_ ON b7_.background_id = i10_.id LEFT JOIN image i11_ ON b7_.image_id = i11_.id LEFT JOIN link l12_ ON b7_.link_id = l12_.id LEFT JOIN video v13_ ON b7_.video_id = v13_.id LEFT JOIN block_download b14_ ON b7_.id = b14_.block_id LEFT JOIN download d15_ ON b14_.download_id = d15_.id LEFT JOIN block_image b16_ ON b7_.id = b16_.block_id LEFT JOIN image i17_ ON b16_.image_id = i17_.id LEFT JOIN block_link b18_ ON b7_.id = b18_.block_id LEFT JOIN link l19_ ON b18_.link_id = l19_.id LEFT JOIN page_slide p20_ ON p0_.id = p20_.page_id LEFT JOIN slide s21_ ON p20_.slide_id = s21_.id LEFT JOIN image i22_ ON s21_.image_id = i22_.id LEFT JOIN link l23_ ON s21_.link_id = l23_.id LEFT JOIN video v24_ ON s21_.video_id = v24_.id WHERE (p1_.template = 'prices' AND p1_.static_page = 'yes') AND (p0_.deleted_at IS NULL) ORDER BY b7_.position ASC, b14_.position ASC, b16_.position ASC, b18_.position ASC, p20_.position ASC LIMIT 1;
|
| 6 |
21.00 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.publishable AS publishable_17, t0.planable AS planable_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.deleted_at AS deleted_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.id AS id_24 FROM page_basis t0 WHERE t0.template = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters: [
"planpage"
]
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.publishable AS publishable_17, t0.planable AS planable_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.deleted_at AS deleted_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.id AS id_24 FROM page_basis t0 WHERE t0.template = 'planpage' AND ((t0.deleted_at IS NULL)) LIMIT 1;
|
| 7 |
13.75 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.id AS id_3, t0.plan_id AS plan_id_4 FROM plan_feature t0 WHERE t0.plan_id = ?
Parameters: [
"0193c01e-2018-7490-b167-be1ce7b53a23"
]
SELECT t0.title AS title_1, t0.content AS content_2, t0.id AS id_3, t0.plan_id AS plan_id_4 FROM plan_feature t0 WHERE t0.plan_id = '0193c01e-2018-7490-b167-be1ce7b53a23';
|
| 8 |
7.16 ms |
SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC
SELECT
c0_.name AS name_0,
c0_.host AS host_1,
c0_.class AS class_2,
c0_.main AS main_3,
c0_.order_code AS order_code_4,
c0_.messages AS messages_5,
c0_.sections AS sections_6,
c0_.deleted_at AS deleted_at_7,
c0_.created_at AS created_at_8,
c0_.updated_at AS updated_at_9,
c0_.id AS id_10,
p1_.name AS name_11,
p1_.full_name AS full_name_12,
p1_.content AS content_13,
p1_.description AS description_14,
p1_.initial_price AS initial_price_15,
p1_.recurring_price AS recurring_price_16,
p1_.color AS color_17,
p1_.initial AS initial_18,
p1_.nutriwell AS nutriwell_19,
p1_.chronotype AS chronotype_20,
p1_.recipes AS recipes_21,
p1_.tips AS tips_22,
p1_.nutritional_program AS nutritional_program_23,
p1_.supplementation_program AS supplementation_program_24,
p1_.nutritionist AS nutritionist_25,
p1_.inbody AS inbody_26,
p1_.ages AS ages_27,
p1_.lipidomic AS lipidomic_28,
p1_.vital_status AS vital_status_29,
p1_.contact AS contact_30,
p1_.duration AS duration_31,
p1_.needs_blood_extraction AS needs_blood_extraction_32,
p1_.has_appointments AS has_appointments_33,
p1_.lipiwell_id AS lipiwell_id_34,
p1_.position AS position_35,
p1_.created_at AS created_at_36,
p1_.updated_at AS updated_at_37,
p1_.active AS active_38,
p1_.id AS id_39,
p2_.title AS title_40,
p2_.menu_title AS menu_title_41,
p2_.content AS content_42,
p2_.feature AS feature_43,
p2_.published_at AS published_at_44,
p2_.deleted_at AS deleted_at_45,
p2_.position AS position_46,
p2_.created_at AS created_at_47,
p2_.updated_at AS updated_at_48,
p2_.active AS active_49,
p2_.id AS id_50,
s3_.slug AS slug_51,
s3_.class_name AS class_name_52,
s3_.content_updated_at AS content_updated_at_53,
s3_.created_at AS created_at_54,
s3_.updated_at AS updated_at_55,
s3_.id AS id_56,
p1_.basis_id AS basis_id_57,
p1_.image_id AS image_id_58,
p1_.page_id AS page_id_59,
p2_.basis_id AS basis_id_60,
p2_.banner_id AS banner_id_61,
p2_.company_id AS company_id_62,
p2_.plan_id AS plan_id_63,
p2_.meta_id AS meta_id_64,
p2_.slug_id AS slug_id_65
FROM
company c0_
LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id
LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id
LEFT JOIN page p2_ ON p1_.page_id = p2_.id
AND (p2_.deleted_at IS NULL)
LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id
ORDER BY
p1_.lipiwell_id ASC
SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC;
|
| 9 |
7.20 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.publishable AS publishable_17, t0.planable AS planable_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.deleted_at AS deleted_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.id AS id_24 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.publishable AS publishable_17, t0.planable AS planable_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.deleted_at AS deleted_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.id AS id_24 FROM page_basis t0 WHERE t0.template = 'legalpage' AND ((t0.deleted_at IS NULL)) LIMIT 1;
|