Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_copyrights AS site_copyrights_3,
  t0.site_email AS site_email_4,
  t0.site_description AS site_description_5,
  t0.contact_phone AS contact_phone_6,
  t0.support_email AS support_email_7,
  t0.contact_address AS contact_address_8,
  t0.main_site_url AS main_site_url_9,
  t0.is_maintenance_mode AS is_maintenance_mode_10,
  t0.maintenance_text AS maintenance_text_11
FROM
  site_setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.icon AS icon_4
FROM
  social_setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.description AS description_5,
  t0.is_published AS is_published_6,
  t0.is_free AS is_free_7,
  t0.niveau_difficulte AS niveau_difficulte_8,
  t0.duree_apprentissage AS duree_apprentissage_9,
  t0.created_at AS created_at_10,
  t0.vues AS vues_11,
  t0.is_validated AS is_validated_12,
  t0.montant_abonnement AS montant_abonnement_13,
  t0.language AS language_14,
  t0.number_of_lessons AS number_of_lessons_15,
  t0.tags AS tags_16,
  t0.is_rejected AS is_rejected_17,
  t0.review AS review_18,
  t0.updated_at AS updated_at_19,
  t0.published_at AS published_at_20,
  t0.enseignant_id AS enseignant_id_21,
  t0.categorie_id AS categorie_id_22,
  t23.id AS id_24,
  t23.video_url AS video_url_25,
  t23.mp4_file AS mp4_file_26,
  t23.web_mfile AS web_mfile_27,
  t23.ogg_file AS ogg_file_28,
  t23.image_file AS image_file_29,
  t23.cours_id AS cours_id_30,
  t31.id AS id_32,
  t31.cours_id AS cours_id_33,
  t0.skill_level_id AS skill_level_id_34
FROM
  cours t0
  LEFT JOIN media t23 ON t23.cours_id = t0.id
  LEFT JOIN forum t31 ON t31.cours_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.slug AS slug_3, t0.content AS content_4, t0.description AS description_5, t0.is_published AS is_published_6, t0.is_free AS is_free_7, t0.niveau_difficulte AS niveau_difficulte_8, t0.duree_apprentissage AS duree_apprentissage_9, t0.created_at AS created_at_10, t0.vues AS vues_11, t0.is_validated AS is_validated_12, t0.montant_abonnement AS montant_abonnement_13, t0.language AS language_14, t0.number_of_lessons AS number_of_lessons_15, t0.tags AS tags_16, t0.is_rejected AS is_rejected_17, t0.review AS review_18, t0.updated_at AS updated_at_19, t0.published_at AS published_at_20, t0.enseignant_id AS enseignant_id_21, t0.categorie_id AS categorie_id_22, t23.id AS id_24, t23.video_url AS video_url_25, t23.mp4_file AS mp4_file_26, t23.web_mfile AS web_mfile_27, t23.ogg_file AS ogg_file_28, t23.image_file AS image_file_29, t23.cours_id AS cours_id_30, t31.id AS id_32, t31.cours_id AS cours_id_33, t0.skill_level_id AS skill_level_id_34 FROM cours t0 LEFT JOIN media t23 ON t23.cours_id = t0.id LEFT JOIN forum t31 ON t31.cours_id = t0.id WHERE t0.slug = '1691170397-Langue-francaise' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2,
  l0_.content AS content_3,
  l0_.video_link AS video_link_4,
  l0_.numero AS numero_5,
  l0_.poster AS poster_6,
  l0_.updated_at AS updated_at_7,
  l0_.chapitre_id AS chapitre_id_8
FROM
  lesson l0_
  INNER JOIN lecture l1_ ON l0_.id = l1_.lesson_id
  INNER JOIN chapitre c2_ ON l0_.chapitre_id = c2_.id
WHERE
  c2_.cours_id = ?
ORDER BY
  l0_.numero ASC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.video_link AS video_link_4, l0_.numero AS numero_5, l0_.poster AS poster_6, l0_.updated_at AS updated_at_7, l0_.chapitre_id AS chapitre_id_8 FROM lesson l0_ INNER JOIN lecture l1_ ON l0_.id = l1_.lesson_id INNER JOIN chapitre c2_ ON l0_.chapitre_id = c2_.id WHERE c2_.cours_id = 21 ORDER BY l0_.numero ASC;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.join_at AS join_at_3,
  t0.is_premium AS is_premium_4,
  t0.classe_id AS classe_id_5,
  t0.utilisateur_id AS utilisateur_id_6,
  t0.etablissement_id AS etablissement_id_7
FROM
  eleve t0
WHERE
  t0.utilisateur_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 WHERE t0.utilisateur_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.utilisateur_id AS utilisateur_id_2
FROM
  membre t0
WHERE
  t0.utilisateur_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2 FROM membre t0 WHERE t0.utilisateur_id IS NULL LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cours
SET
  vues = ?
WHERE
  id = ?

UPDATE cours SET vues = 345 WHERE id = 21;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?
  AND t0.rating = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21 AND t0.rating = 5;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?
  AND t0.rating = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21 AND t0.rating = 4;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?
  AND t0.rating = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21 AND t0.rating = 3;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?
  AND t0.rating = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21 AND t0.rating = 2;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?
  AND t0.rating = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21 AND t0.rating = 1;

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.message AS message_4,
  t0.cours_id AS cours_id_5,
  t0.eleve_id AS eleve_id_6
FROM
  review t0
WHERE
  t0.cours_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = 21;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.description AS description_5,
  t0.is_published AS is_published_6,
  t0.is_free AS is_free_7,
  t0.niveau_difficulte AS niveau_difficulte_8,
  t0.duree_apprentissage AS duree_apprentissage_9,
  t0.created_at AS created_at_10,
  t0.vues AS vues_11,
  t0.is_validated AS is_validated_12,
  t0.montant_abonnement AS montant_abonnement_13,
  t0.language AS language_14,
  t0.number_of_lessons AS number_of_lessons_15,
  t0.tags AS tags_16,
  t0.is_rejected AS is_rejected_17,
  t0.review AS review_18,
  t0.updated_at AS updated_at_19,
  t0.published_at AS published_at_20,
  t0.enseignant_id AS enseignant_id_21,
  t0.categorie_id AS categorie_id_22,
  t23.id AS id_24,
  t23.video_url AS video_url_25,
  t23.mp4_file AS mp4_file_26,
  t23.web_mfile AS web_mfile_27,
  t23.ogg_file AS ogg_file_28,
  t23.image_file AS image_file_29,
  t23.cours_id AS cours_id_30,
  t31.id AS id_32,
  t31.cours_id AS cours_id_33,
  t0.skill_level_id AS skill_level_id_34
FROM
  cours t0
  LEFT JOIN media t23 ON t23.cours_id = t0.id
  LEFT JOIN forum t31 ON t31.cours_id = t0.id
WHERE
  t0.is_validated = ?
ORDER BY
  t0.review DESC,
  t0.created_at DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.slug AS slug_3, t0.content AS content_4, t0.description AS description_5, t0.is_published AS is_published_6, t0.is_free AS is_free_7, t0.niveau_difficulte AS niveau_difficulte_8, t0.duree_apprentissage AS duree_apprentissage_9, t0.created_at AS created_at_10, t0.vues AS vues_11, t0.is_validated AS is_validated_12, t0.montant_abonnement AS montant_abonnement_13, t0.language AS language_14, t0.number_of_lessons AS number_of_lessons_15, t0.tags AS tags_16, t0.is_rejected AS is_rejected_17, t0.review AS review_18, t0.updated_at AS updated_at_19, t0.published_at AS published_at_20, t0.enseignant_id AS enseignant_id_21, t0.categorie_id AS categorie_id_22, t23.id AS id_24, t23.video_url AS video_url_25, t23.mp4_file AS mp4_file_26, t23.web_mfile AS web_mfile_27, t23.ogg_file AS ogg_file_28, t23.image_file AS image_file_29, t23.cours_id AS cours_id_30, t31.id AS id_32, t31.cours_id AS cours_id_33, t0.skill_level_id AS skill_level_id_34 FROM cours t0 LEFT JOIN media t23 ON t23.cours_id = t0.id LEFT JOIN forum t31 ON t31.cours_id = t0.id WHERE t0.is_validated = 1 ORDER BY t0.review DESC, t0.created_at DESC LIMIT 8;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2,
  l0_.content AS content_3,
  l0_.video_link AS video_link_4,
  l0_.numero AS numero_5,
  l0_.poster AS poster_6,
  l0_.updated_at AS updated_at_7,
  l0_.chapitre_id AS chapitre_id_8
FROM
  lesson l0_
  INNER JOIN chapitre c1_ ON l0_.chapitre_id = c1_.id
WHERE
  c1_.cours_id = ?
ORDER BY
  l0_.numero ASC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.video_link AS video_link_4, l0_.numero AS numero_5, l0_.poster AS poster_6, l0_.updated_at AS updated_at_7, l0_.chapitre_id AS chapitre_id_8 FROM lesson l0_ INNER JOIN chapitre c1_ ON l0_.chapitre_id = c1_.id WHERE c1_.cours_id = 21 ORDER BY l0_.numero ASC;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_copyrights AS site_copyrights_3,
  t0.site_email AS site_email_4,
  t0.site_description AS site_description_5,
  t0.contact_phone AS contact_phone_6,
  t0.support_email AS support_email_7,
  t0.contact_address AS contact_address_8,
  t0.main_site_url AS main_site_url_9,
  t0.is_maintenance_mode AS is_maintenance_mode_10,
  t0.maintenance_text AS maintenance_text_11
FROM
  site_setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.icon AS icon_4
FROM
  social_setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.is_sub_category = ?
ORDER BY
  t0.name ASC
LIMIT
  11

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.is_sub_category = 0 ORDER BY t0.name ASC LIMIT 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 25;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = 11;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_copyrights AS site_copyrights_3,
  t0.site_email AS site_email_4,
  t0.site_description AS site_description_5,
  t0.contact_phone AS contact_phone_6,
  t0.support_email AS support_email_7,
  t0.contact_address AS contact_address_8,
  t0.main_site_url AS main_site_url_9,
  t0.is_maintenance_mode AS is_maintenance_mode_10,
  t0.maintenance_text AS maintenance_text_11
FROM
  site_setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.icon AS icon_4
FROM
  social_setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_file AS image_file_4,
  t0.is_sub_category AS is_sub_category_5,
  t0.category_id AS category_id_6
FROM
  categorie t0
WHERE
  t0.is_sub_category = ?
ORDER BY
  t0.name ASC
LIMIT
  12

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.is_sub_category = 0 ORDER BY t0.name ASC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.description AS description_5,
  t0.is_published AS is_published_6,
  t0.is_free AS is_free_7,
  t0.niveau_difficulte AS niveau_difficulte_8,
  t0.duree_apprentissage AS duree_apprentissage_9,
  t0.created_at AS created_at_10,
  t0.vues AS vues_11,
  t0.is_validated AS is_validated_12,
  t0.montant_abonnement AS montant_abonnement_13,
  t0.language AS language_14,
  t0.number_of_lessons AS number_of_lessons_15,
  t0.tags AS tags_16,
  t0.is_rejected AS is_rejected_17,
  t0.review AS review_18,
  t0.updated_at AS updated_at_19,
  t0.published_at AS published_at_20,
  t0.enseignant_id AS enseignant_id_21,
  t0.categorie_id AS categorie_id_22,
  t23.id AS id_24,
  t23.video_url AS video_url_25,
  t23.mp4_file AS mp4_file_26,
  t23.web_mfile AS web_mfile_27,
  t23.ogg_file AS ogg_file_28,
  t23.image_file AS image_file_29,
  t23.cours_id AS cours_id_30,
  t31.id AS id_32,
  t31.cours_id AS cours_id_33,
  t0.skill_level_id AS skill_level_id_34
FROM
  cours t0
  LEFT JOIN media t23 ON t23.cours_id = t0.id
  LEFT JOIN forum t31 ON t31.cours_id = t0.id
WHERE
  t0.is_validated = ?
ORDER BY
  t0.created_at DESC,
  t0.vues DESC
LIMIT
  8