1
0.23 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . image_name AS image_name_4 , t0 . author AS author_5 , t0 . summary AS summary_6 , t0 . content AS content_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . state AS state_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_canonical AS seo_canonical_13 , t0 . seo_indexed AS seo_indexed_14 , t0 . category_id AS category_id_15 FROM article t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"10-idees-de-contenus-pour-mettre-en-valeur-votre-activite-locale-sur-les-reseaux-sociaux "
]
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . image_name AS image_name_4 , t0 . author AS author_5 , t0 . summary AS summary_6 , t0 . content AS content_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . state AS state_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_canonical AS seo_canonical_13 , t0 . seo_indexed AS seo_indexed_14 , t0 . category_id AS category_id_15 FROM article t0 WHERE t0 . slug = '10-idees-de-contenus-pour-mettre-en-valeur-votre-activite-locale-sur-les-reseaux-sociaux' LIMIT 1 ;
Copy
2
0.29 ms
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 . sub_title AS sub_title_18 , t0 . show_on_home_page AS show_on_home_page_19 , t0 . format AS format_20 , t0 . collective_face_to_face_hours AS collective_face_to_face_hours_21 , t0 . individual_face_to_face_hours AS individual_face_to_face_hours_22 , t0 . individual_videoconference_hours AS individual_videoconference_hours_23 , t0 . collective_videoconference_hours AS collective_videoconference_hours_24 , t0 . elearning_hours AS elearning_hours_25 , t0 . face_to_face_hours_text AS face_to_face_hours_text_26 , t0 . min_period AS min_period_27 , t0 . max_period AS max_period_28 , t0 . public AS public_29 , t0 . prerequisites AS prerequisites_30 , t0 . cpf AS cpf_31 , t0 . cpf_link AS cpf_link_32 , t0 . pdf_name AS pdf_name_33 , t0 . pdf_mime_type AS pdf_mime_type_34 , t0 . created_by_id AS created_by_id_35 , t0 . category_id AS category_id_36 , t0 . certification_id AS certification_id_37 , t0 . type FROM training t0 INNER JOIN article_training_professional ON t0 . id = article_training_professional . training_professional_id WHERE article_training_professional . article_id = ? AND t0 . type IN ('professional' )
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 . sub_title AS sub_title_18 , t0 . show_on_home_page AS show_on_home_page_19 , t0 . format AS format_20 , t0 . collective_face_to_face_hours AS collective_face_to_face_hours_21 , t0 . individual_face_to_face_hours AS individual_face_to_face_hours_22 , t0 . individual_videoconference_hours AS individual_videoconference_hours_23 , t0 . collective_videoconference_hours AS collective_videoconference_hours_24 , t0 . elearning_hours AS elearning_hours_25 , t0 . face_to_face_hours_text AS face_to_face_hours_text_26 , t0 . min_period AS min_period_27 , t0 . max_period AS max_period_28 , t0 . public AS public_29 , t0 . prerequisites AS prerequisites_30 , t0 . cpf AS cpf_31 , t0 . cpf_link AS cpf_link_32 , t0 . pdf_name AS pdf_name_33 , t0 . pdf_mime_type AS pdf_mime_type_34 , t0 . created_by_id AS created_by_id_35 , t0 . category_id AS category_id_36 , t0 . certification_id AS certification_id_37 , t0 . type FROM training t0 INNER JOIN article_training_professional ON t0 . id = article_training_professional . training_professional_id WHERE article_training_professional . article_id = 39 AND t0 . type IN ('professional' );
Copy
4
0.88 ms
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . image_name AS image_name_3 , a0_ . author AS author_4 , a0_ . summary AS summary_5 , a0_ . content AS content_6 , a0_ . created_at AS created_at_7 , a0_ . updated_at AS updated_at_8 , a0_ . state AS state_9 , a0_ . seo_title AS seo_title_10 , a0_ . seo_description AS seo_description_11 , a0_ . seo_canonical AS seo_canonical_12 , a0_ . seo_indexed AS seo_indexed_13 , a0_ . category_id AS category_id_14 FROM article a0_ INNER JOIN article_category a1_ ON a0_ . category_id = a1_ . id AND (a1_ . id = ? ) WHERE a0_ . id < > ? AND a0_ . state = ? ORDER BY RANDOM () ASC LIMIT 3
Parameters :
[
6
39
"ONLINE "
]
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . image_name AS image_name_3 , a0_ . author AS author_4 , a0_ . summary AS summary_5 , a0_ . content AS content_6 , a0_ . created_at AS created_at_7 , a0_ . updated_at AS updated_at_8 , a0_ . state AS state_9 , a0_ . seo_title AS seo_title_10 , a0_ . seo_description AS seo_description_11 , a0_ . seo_canonical AS seo_canonical_12 , a0_ . seo_indexed AS seo_indexed_13 , a0_ . category_id AS category_id_14 FROM article a0_ INNER JOIN article_category a1_ ON a0_ . category_id = a1_ . id AND (a1_ . id = 6 ) WHERE a0_ . id < > 39 AND a0_ . state = 'ONLINE' ORDER BY RANDOM () ASC LIMIT 3 ;
Copy