1 |
88.88 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_.name AS name_40, p2_.free AS free_41, p2_.single AS single_42, p2_.monthly AS monthly_43, p2_.deleted_at AS deleted_at_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, p2_.id AS id_47, i3_.name AS name_48, i3_.original_name AS original_name_49, i3_.size AS size_50, i3_.alt AS alt_51, i3_.source AS source_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, i3_.id AS id_55, p4_.title AS title_56, p4_.content AS content_57, p4_.id AS id_58, c5_.position AS position_59, c5_.id AS id_60, p1_.basis_id AS basis_id_61, p1_.image_id AS image_id_62, p1_.page_id AS page_id_63, p4_.plan_id AS plan_id_64, c5_.company_id AS company_id_65, c5_.slide_id AS slide_id_66 FROM company c0_ LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id LEFT JOIN image i3_ ON p1_.image_id = i3_.id LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id ORDER BY c0_.id ASC, p1_.lipiwell_id ASC, c5_.position 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_.name AS name_40,
p2_.free AS free_41,
p2_.single AS single_42,
p2_.monthly AS monthly_43,
p2_.deleted_at AS deleted_at_44,
p2_.created_at AS created_at_45,
p2_.updated_at AS updated_at_46,
p2_.id AS id_47,
i3_.name AS name_48,
i3_.original_name AS original_name_49,
i3_.size AS size_50,
i3_.alt AS alt_51,
i3_.source AS source_52,
i3_.created_at AS created_at_53,
i3_.updated_at AS updated_at_54,
i3_.id AS id_55,
p4_.title AS title_56,
p4_.content AS content_57,
p4_.id AS id_58,
c5_.position AS position_59,
c5_.id AS id_60,
p1_.basis_id AS basis_id_61,
p1_.image_id AS image_id_62,
p1_.page_id AS page_id_63,
p4_.plan_id AS plan_id_64,
c5_.company_id AS company_id_65,
c5_.slide_id AS slide_id_66
FROM
company c0_
LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id
LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id
LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id
LEFT JOIN image i3_ ON p1_.image_id = i3_.id
LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id
LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id
ORDER BY
c0_.id ASC,
p1_.lipiwell_id ASC,
c5_.position 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_.name AS name_40, p2_.free AS free_41, p2_.single AS single_42, p2_.monthly AS monthly_43, p2_.deleted_at AS deleted_at_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, p2_.id AS id_47, i3_.name AS name_48, i3_.original_name AS original_name_49, i3_.size AS size_50, i3_.alt AS alt_51, i3_.source AS source_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, i3_.id AS id_55, p4_.title AS title_56, p4_.content AS content_57, p4_.id AS id_58, c5_.position AS position_59, c5_.id AS id_60, p1_.basis_id AS basis_id_61, p1_.image_id AS image_id_62, p1_.page_id AS page_id_63, p4_.plan_id AS plan_id_64, c5_.company_id AS company_id_65, c5_.slide_id AS slide_id_66 FROM company c0_ LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id LEFT JOIN image i3_ ON p1_.image_id = i3_.id LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id ORDER BY c0_.id ASC, p1_.lipiwell_id ASC, c5_.position ASC;
|
2 |
2.60 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;
|