Symfony Profiler

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.filiere_id AS filiere_id_4
FROM
  specialite t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.filiere_id AS filiere_id_4 FROM specialite t0 WHERE t0.slug IS NULL 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.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.specialite_id AS specialite_id_4,
  t0.skill_level_id AS skill_level_id_5,
  t0.sous_systeme_id AS sous_systeme_id_6
FROM
  classe t0
ORDER BY
  t0.specialite_id ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.specialite_id AS specialite_id_4, t0.skill_level_id AS skill_level_id_5, t0.sous_systeme_id AS sous_systeme_id_6 FROM classe t0 ORDER BY t0.specialite_id ASC, t0.name ASC;

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

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.created_at DESC, t0.vues DESC LIMIT 8;

SELECT
  c0_.id AS id_0,
  c0_.intitule AS intitule_1,
  c0_.slug AS slug_2,
  c0_.content AS content_3,
  c0_.description AS description_4,
  c0_.is_published AS is_published_5,
  c0_.is_free AS is_free_6,
  c0_.niveau_difficulte AS niveau_difficulte_7,
  c0_.duree_apprentissage AS duree_apprentissage_8,
  c0_.created_at AS created_at_9,
  c0_.vues AS vues_10,
  c0_.is_validated AS is_validated_11,
  c0_.montant_abonnement AS montant_abonnement_12,
  c0_.language AS language_13,
  c0_.number_of_lessons AS number_of_lessons_14,
  c0_.tags AS tags_15,
  c0_.is_rejected AS is_rejected_16,
  c0_.review AS review_17,
  c0_.updated_at AS updated_at_18,
  c0_.published_at AS published_at_19,
  c0_.enseignant_id AS enseignant_id_20,
  c0_.categorie_id AS categorie_id_21,
  c0_.skill_level_id AS skill_level_id_22
FROM
  cours c0_
  INNER JOIN categorie c1_ ON c0_.categorie_id = c1_.id
WHERE
  c0_.categorie_id = ?
  AND c0_.is_validated = ?

SELECT c0_.id AS id_0, c0_.intitule AS intitule_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.description AS description_4, c0_.is_published AS is_published_5, c0_.is_free AS is_free_6, c0_.niveau_difficulte AS niveau_difficulte_7, c0_.duree_apprentissage AS duree_apprentissage_8, c0_.created_at AS created_at_9, c0_.vues AS vues_10, c0_.is_validated AS is_validated_11, c0_.montant_abonnement AS montant_abonnement_12, c0_.language AS language_13, c0_.number_of_lessons AS number_of_lessons_14, c0_.tags AS tags_15, c0_.is_rejected AS is_rejected_16, c0_.review AS review_17, c0_.updated_at AS updated_at_18, c0_.published_at AS published_at_19, c0_.enseignant_id AS enseignant_id_20, c0_.categorie_id AS categorie_id_21, c0_.skill_level_id AS skill_level_id_22 FROM cours c0_ INNER JOIN categorie c1_ ON c0_.categorie_id = c1_.id WHERE c0_.categorie_id = 5 AND c0_.is_validated = 1;

SELECT
  t0.id AS id_1,
  t0.video_url AS video_url_2,
  t0.mp4_file AS mp4_file_3,
  t0.web_mfile AS web_mfile_4,
  t0.ogg_file AS ogg_file_5,
  t0.image_file AS image_file_6,
  t0.cours_id AS cours_id_7
FROM
  media t0
WHERE
  t0.cours_id = ?

SELECT t0.id AS id_1, t0.video_url AS video_url_2, t0.mp4_file AS mp4_file_3, t0.web_mfile AS web_mfile_4, t0.ogg_file AS ogg_file_5, t0.image_file AS image_file_6, t0.cours_id AS cours_id_7 FROM media t0 WHERE t0.cours_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type_enseignement_id AS type_enseignement_id_4
FROM
  filiere t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type_enseignement_id AS type_enseignement_id_4 FROM filiere t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.specialite_id AS specialite_id_4,
  t0.skill_level_id AS skill_level_id_5,
  t0.sous_systeme_id AS sous_systeme_id_6
FROM
  classe t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.specialite_id AS specialite_id_4, t0.skill_level_id AS skill_level_id_5, t0.sous_systeme_id AS sous_systeme_id_6 FROM classe t0 WHERE t0.slug IS NULL LIMIT 1;

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
ORDER BY
  t0.name ASC

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 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.cours_id AS cours_id_2
FROM
  forum t0
WHERE
  t0.cours_id = ?

SELECT t0.id AS id_1, t0.cours_id AS cours_id_2 FROM forum t0 WHERE t0.cours_id = 2;

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.slug = ?
LIMIT
  1

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.slug = 'CHIMIE' LIMIT 1;

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.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.name AS name_2,
  t0.slug AS slug_3,
  t0.type_enseignement_id AS type_enseignement_id_4
FROM
  filiere t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type_enseignement_id AS type_enseignement_id_4 FROM filiere t0 WHERE t0.slug IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.filiere_id AS filiere_id_4
FROM
  specialite t0
ORDER BY
  t0.filiere_id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.filiere_id AS filiere_id_4 FROM specialite t0 ORDER BY t0.filiere_id ASC;

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.slug IS NULL
LIMIT
  1

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.slug IS NULL LIMIT 1;