0.61 ms (38.85%)
1
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . code AS code_3 , t0 . slug_history AS slug_history_4 , t0 . description AS description_5 , t0 . price AS price_6 , t0 . status AS status_7 , t0 . satisfaction_rate AS satisfaction_rate_8 , t0 . completion_rate AS completion_rate_9 , t0 . featured_on_search AS featured_on_search_10 , t0 . pixels AS pixels_11 , t0 . updated_at AS updated_at_12 , t0 . seo_title AS seo_title_13 , t0 . seo_description AS seo_description_14 , t0 . seo_canonical AS seo_canonical_15 , t0 . seo_indexed AS seo_indexed_16 , t0 . slug AS slug_17 , t0 . level AS level_18 , t0 . language AS language_19 , t0 . hours AS hours_20 , t0 . additional_students AS additional_students_21 , t0 . listing_image_name AS listing_image_name_22 , t0 . show_image_name AS show_image_name_23 , t0 . created_by_id AS created_by_id_24 , t0 . category_id AS category_id_25 , t0 . type FROM training t0 WHERE t0 . slug = ? AND t0 . type IN ('elearning' ) LIMIT 1
Parameters :
[
"formation-ia-dfefef "
]
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . code AS code_3 , t0 . slug_history AS slug_history_4 , t0 . description AS description_5 , t0 . price AS price_6 , t0 . status AS status_7 , t0 . satisfaction_rate AS satisfaction_rate_8 , t0 . completion_rate AS completion_rate_9 , t0 . featured_on_search AS featured_on_search_10 , t0 . pixels AS pixels_11 , t0 . updated_at AS updated_at_12 , t0 . seo_title AS seo_title_13 , t0 . seo_description AS seo_description_14 , t0 . seo_canonical AS seo_canonical_15 , t0 . seo_indexed AS seo_indexed_16 , t0 . slug AS slug_17 , t0 . level AS level_18 , t0 . language AS language_19 , t0 . hours AS hours_20 , t0 . additional_students AS additional_students_21 , t0 . listing_image_name AS listing_image_name_22 , t0 . show_image_name AS show_image_name_23 , t0 . created_by_id AS created_by_id_24 , t0 . category_id AS category_id_25 , t0 . type FROM training t0 WHERE t0 . slug = 'formation-ia-dfefef' AND t0 . type IN ('elearning' ) LIMIT 1 ;
Copy
0.30 ms (18.81%)
1
SELECT f . id , f . question , f . answer , f . category_id , c . label AS category_label
FROM faq f
LEFT JOIN faqcategory c ON f . category_id = c . id
WHERE (f . training_id = ? OR f . training_id IS NULL )
AND (
c . type IS NULL
OR c . type = ?
OR c . type = ?
)
ORDER BY c . id , f . question
Parameters :
[
383
"BOTH "
"E_LEARNING "
]
SELECT f . id , f . question , f . answer , f . category_id , c . label AS category_label
FROM faq f
LEFT JOIN faqcategory c ON f . category_id = c . id
WHERE (f . training_id = 383 OR f . training_id IS NULL )
AND (
c . type IS NULL
OR c . type = 'BOTH'
OR c . type = 'E_LEARNING'
)
ORDER BY c . id , f . question ;
Copy
0.19 ms (11.79%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . enable AS enable_4 , t0 . updated_at AS updated_at_5 , t0 . seo_title AS seo_title_6 , t0 . seo_description AS seo_description_7 , t0 . seo_canonical AS seo_canonical_8 , t0 . seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0 . enable = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . enable AS enable_4 , t0 . updated_at AS updated_at_5 , t0 . seo_title AS seo_title_6 , t0 . seo_description AS seo_description_7 , t0 . seo_canonical AS seo_canonical_8 , t0 . seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0 . enable = 1 ;
Copy
0.11 ms (7.04%)
1
SELECT t0 . id AS id_1 , t0 . firstname AS firstname_2 , t0 . lastname AS lastname_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . certifications AS certifications_6 , t0 . status AS status_7 , t0 . image_name AS image_name_8 , t0 . updated_at AS updated_at_9 , t0 . available AS available_10 , t0 . nda_status AS nda_status_11 , t0 . joined_at AS joined_at_12 , t0 . is_senza_trainer AS is_senza_trainer_13 , t0 . data_gouv_link AS data_gouv_link_14 , t0 . level AS level_15 , t0 . languages AS languages_16 , t0 . total_trainings AS total_trainings_17 , t0 . quality_chart_signed AS quality_chart_signed_18 , t0 . senza_training_validated AS senza_training_validated_19 , t0 . expert AS expert_20 , t0 . siret AS siret_21 , t0 . nda_number AS nda_number_22 , t0 . email_hash AS email_hash_23 , t0 . user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0 . id = training_trainer . trainer_id WHERE training_trainer . training_id = ?
SELECT t0 . id AS id_1 , t0 . firstname AS firstname_2 , t0 . lastname AS lastname_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . certifications AS certifications_6 , t0 . status AS status_7 , t0 . image_name AS image_name_8 , t0 . updated_at AS updated_at_9 , t0 . available AS available_10 , t0 . nda_status AS nda_status_11 , t0 . joined_at AS joined_at_12 , t0 . is_senza_trainer AS is_senza_trainer_13 , t0 . data_gouv_link AS data_gouv_link_14 , t0 . level AS level_15 , t0 . languages AS languages_16 , t0 . total_trainings AS total_trainings_17 , t0 . quality_chart_signed AS quality_chart_signed_18 , t0 . senza_training_validated AS senza_training_validated_19 , t0 . expert AS expert_20 , t0 . siret AS siret_21 , t0 . nda_number AS nda_number_22 , t0 . email_hash AS email_hash_23 , t0 . user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0 . id = training_trainer . trainer_id WHERE training_trainer . training_id = 383 ;
Copy