0.84 ms (20.04%)
|
1 |
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.image_key AS image_key_3, t0_.price_cents AS price_cents_4, t0_.currency AS currency_5, t0_.registration_email AS registration_email_6, t0_.registration_mode AS registration_mode_7, t0_.registration_url AS registration_url_8, t0_.video_url AS video_url_9, t0_.published_at AS published_at_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t1_.id AS id_13, t1_.locale AS locale_14, t1_.title AS title_15, t1_.slug AS slug_16, t1_.subtitle AS subtitle_17, t1_.summary AS summary_18, t1_.description AS description_19, t1_.content_items AS content_items_20, t1_.learning_outcomes AS learning_outcomes_21, t1_.schedule AS schedule_22, t1_.registration_instructions AS registration_instructions_23, t2_.id AS id_24, t2_.name AS name_25, t2_.logo_key AS logo_key_26, t2_.city AS city_27, t2_.address AS address_28, t2_.maps_url AS maps_url_29, t2_.photo_key AS photo_key_30, t3_.id AS id_31, t3_.color AS color_32, t4_.id AS id_33, t5_.id AS id_34, t5_.role AS role_35, t5_.position AS position_36, t6_.id AS id_37, t6_.name AS name_38, t6_.photo_key AS photo_key_39, t6_.cv_url AS cv_url_40, t6_.linkedin_url AS linkedin_url_41, t6_.kind AS kind_42, t6_.detail_photo_key AS detail_photo_key_43, t7_.id AS id_44, t7_.locale AS locale_45, t7_.bio AS bio_46, t7_.curriculum AS curriculum_47, t0_.predominant_specialty_id AS predominant_specialty_id_48, t0_.institution_id AS institution_id_49, t1_.workshop_id AS workshop_id_50, t5_.workshop_id AS workshop_id_51, t5_.instructor_id AS instructor_id_52, t6_.profession_id AS profession_id_53, t7_.instructor_id AS instructor_id_54 FROM training_workshops t0_ INNER JOIN training_workshop_translations t8_ ON t0_.id = t8_.workshop_id LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_workshop_specialties t9_ ON t0_.id = t9_.workshop_id LEFT JOIN training_specialties t3_ ON t3_.id = t9_.specialty_id LEFT JOIN training_workshop_professional_profiles t10_ ON t0_.id = t10_.workshop_id LEFT JOIN training_professional_profiles t4_ ON t4_.id = t10_.professional_profile_id LEFT JOIN training_workshop_instructors t5_ ON t0_.id = t5_.workshop_id LEFT JOIN training_instructors t6_ ON t5_.instructor_id = t6_.id LEFT JOIN training_instructor_translations t7_ ON t6_.id = t7_.instructor_id WHERE t0_.status = ? AND t8_.slug = ? ORDER BY t5_.position ASC
Parameters: [
"published"
"suturing-techniques-and-tissue-regeneration"
]
SELECT
t0_.id AS id_0,
t0_.status AS status_1,
t0_.modality AS modality_2,
t0_.image_key AS image_key_3,
t0_.price_cents AS price_cents_4,
t0_.currency AS currency_5,
t0_.registration_email AS registration_email_6,
t0_.registration_mode AS registration_mode_7,
t0_.registration_url AS registration_url_8,
t0_.video_url AS video_url_9,
t0_.published_at AS published_at_10,
t0_.created_at AS created_at_11,
t0_.updated_at AS updated_at_12,
t1_.id AS id_13,
t1_.locale AS locale_14,
t1_.title AS title_15,
t1_.slug AS slug_16,
t1_.subtitle AS subtitle_17,
t1_.summary AS summary_18,
t1_.description AS description_19,
t1_.content_items AS content_items_20,
t1_.learning_outcomes AS learning_outcomes_21,
t1_.schedule AS schedule_22,
t1_.registration_instructions AS registration_instructions_23,
t2_.id AS id_24,
t2_.name AS name_25,
t2_.logo_key AS logo_key_26,
t2_.city AS city_27,
t2_.address AS address_28,
t2_.maps_url AS maps_url_29,
t2_.photo_key AS photo_key_30,
t3_.id AS id_31,
t3_.color AS color_32,
t4_.id AS id_33,
t5_.id AS id_34,
t5_.role AS role_35,
t5_.position AS position_36,
t6_.id AS id_37,
t6_.name AS name_38,
t6_.photo_key AS photo_key_39,
t6_.cv_url AS cv_url_40,
t6_.linkedin_url AS linkedin_url_41,
t6_.kind AS kind_42,
t6_.detail_photo_key AS detail_photo_key_43,
t7_.id AS id_44,
t7_.locale AS locale_45,
t7_.bio AS bio_46,
t7_.curriculum AS curriculum_47,
t0_.predominant_specialty_id AS predominant_specialty_id_48,
t0_.institution_id AS institution_id_49,
t1_.workshop_id AS workshop_id_50,
t5_.workshop_id AS workshop_id_51,
t5_.instructor_id AS instructor_id_52,
t6_.profession_id AS profession_id_53,
t7_.instructor_id AS instructor_id_54
FROM
training_workshops t0_
INNER JOIN training_workshop_translations t8_ ON t0_.id = t8_.workshop_id
LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id
LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id
LEFT JOIN training_workshop_specialties t9_ ON t0_.id = t9_.workshop_id
LEFT JOIN training_specialties t3_ ON t3_.id = t9_.specialty_id
LEFT JOIN training_workshop_professional_profiles t10_ ON t0_.id = t10_.workshop_id
LEFT JOIN training_professional_profiles t4_ ON t4_.id = t10_.professional_profile_id
LEFT JOIN training_workshop_instructors t5_ ON t0_.id = t5_.workshop_id
LEFT JOIN training_instructors t6_ ON t5_.instructor_id = t6_.id
LEFT JOIN training_instructor_translations t7_ ON t6_.id = t7_.instructor_id
WHERE
t0_.status = ?
AND t8_.slug = ?
ORDER BY
t5_.position ASC
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.image_key AS image_key_3, t0_.price_cents AS price_cents_4, t0_.currency AS currency_5, t0_.registration_email AS registration_email_6, t0_.registration_mode AS registration_mode_7, t0_.registration_url AS registration_url_8, t0_.video_url AS video_url_9, t0_.published_at AS published_at_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t1_.id AS id_13, t1_.locale AS locale_14, t1_.title AS title_15, t1_.slug AS slug_16, t1_.subtitle AS subtitle_17, t1_.summary AS summary_18, t1_.description AS description_19, t1_.content_items AS content_items_20, t1_.learning_outcomes AS learning_outcomes_21, t1_.schedule AS schedule_22, t1_.registration_instructions AS registration_instructions_23, t2_.id AS id_24, t2_.name AS name_25, t2_.logo_key AS logo_key_26, t2_.city AS city_27, t2_.address AS address_28, t2_.maps_url AS maps_url_29, t2_.photo_key AS photo_key_30, t3_.id AS id_31, t3_.color AS color_32, t4_.id AS id_33, t5_.id AS id_34, t5_.role AS role_35, t5_.position AS position_36, t6_.id AS id_37, t6_.name AS name_38, t6_.photo_key AS photo_key_39, t6_.cv_url AS cv_url_40, t6_.linkedin_url AS linkedin_url_41, t6_.kind AS kind_42, t6_.detail_photo_key AS detail_photo_key_43, t7_.id AS id_44, t7_.locale AS locale_45, t7_.bio AS bio_46, t7_.curriculum AS curriculum_47, t0_.predominant_specialty_id AS predominant_specialty_id_48, t0_.institution_id AS institution_id_49, t1_.workshop_id AS workshop_id_50, t5_.workshop_id AS workshop_id_51, t5_.instructor_id AS instructor_id_52, t6_.profession_id AS profession_id_53, t7_.instructor_id AS instructor_id_54 FROM training_workshops t0_ INNER JOIN training_workshop_translations t8_ ON t0_.id = t8_.workshop_id LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_workshop_specialties t9_ ON t0_.id = t9_.workshop_id LEFT JOIN training_specialties t3_ ON t3_.id = t9_.specialty_id LEFT JOIN training_workshop_professional_profiles t10_ ON t0_.id = t10_.workshop_id LEFT JOIN training_professional_profiles t4_ ON t4_.id = t10_.professional_profile_id LEFT JOIN training_workshop_instructors t5_ ON t0_.id = t5_.workshop_id LEFT JOIN training_instructors t6_ ON t5_.instructor_id = t6_.id LEFT JOIN training_instructor_translations t7_ ON t6_.id = t7_.instructor_id WHERE t0_.status = 'published' AND t8_.slug = 'suturing-techniques-and-tissue-regeneration' ORDER BY t5_.position ASC;
|