Symfony Profiler

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  og_conseils o0_
  LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id
  LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id
  LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id
  LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id
  LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id
  LEFT JOIN og_entreprises_og_codepostaux o7_ ON o2_.id = o7_.og_entreprises_id
  LEFT JOIN og_codepostaux o6_ ON o6_.id = o7_.og_codepostaux_id
  LEFT JOIN og_entreprises_staff_og_entreprises o9_ ON o2_.id = o9_.og_entreprises_id
  LEFT JOIN og_entreprises_staff o8_ ON o8_.id = o9_.og_entreprises_staff_id
  LEFT JOIN og_entreprises_notifications o10_ ON o2_.id = o10_.entreprise_id
  LEFT JOIN og_entreprises_images o11_ ON o2_.id = o11_.entreprise_id
WHERE
  o0_.active = ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM og_conseils o0_ LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id LEFT JOIN og_entreprises_og_codepostaux o7_ ON o2_.id = o7_.og_entreprises_id LEFT JOIN og_codepostaux o6_ ON o6_.id = o7_.og_codepostaux_id LEFT JOIN og_entreprises_staff_og_entreprises o9_ ON o2_.id = o9_.og_entreprises_id LEFT JOIN og_entreprises_staff o8_ ON o8_.id = o9_.og_entreprises_staff_id LEFT JOIN og_entreprises_notifications o10_ ON o2_.id = o10_.entreprise_id LEFT JOIN og_entreprises_images o11_ ON o2_.id = o11_.entreprise_id WHERE o0_.active = 1;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.id AS id_1
FROM
  og_conseils o0_
  LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id
  LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id
  LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id
  LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id
  LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id
  LEFT JOIN og_entreprises_og_codepostaux o7_ ON o2_.id = o7_.og_entreprises_id
  LEFT JOIN og_codepostaux o6_ ON o6_.id = o7_.og_codepostaux_id
  LEFT JOIN og_entreprises_staff_og_entreprises o9_ ON o2_.id = o9_.og_entreprises_id
  LEFT JOIN og_entreprises_staff o8_ ON o8_.id = o9_.og_entreprises_staff_id
  LEFT JOIN og_entreprises_notifications o10_ ON o2_.id = o10_.entreprise_id
  LEFT JOIN og_entreprises_images o11_ ON o2_.id = o11_.entreprise_id
WHERE
  o0_.active = ?
ORDER BY
  o0_.id DESC
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM og_conseils o0_ LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id LEFT JOIN og_entreprises_og_codepostaux o7_ ON o2_.id = o7_.og_entreprises_id LEFT JOIN og_codepostaux o6_ ON o6_.id = o7_.og_codepostaux_id LEFT JOIN og_entreprises_staff_og_entreprises o9_ ON o2_.id = o9_.og_entreprises_id LEFT JOIN og_entreprises_staff o8_ ON o8_.id = o9_.og_entreprises_staff_id LEFT JOIN og_entreprises_notifications o10_ ON o2_.id = o10_.entreprise_id LEFT JOIN og_entreprises_images o11_ ON o2_.id = o11_.entreprise_id WHERE o0_.active = 1 ORDER BY o0_.id DESC LIMIT 30;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.description AS description_2,
  o0_.image AS image_3,
  o0_.active AS active_4,
  o0_.created_at AS created_at_5,
  o0_.buttonperso AS buttonperso_6,
  o0_.buttonpersolink AS buttonpersolink_7,
  o0_.buttonpersoname AS buttonpersoname_8,
  o1_.id AS id_9,
  o1_.name AS name_10,
  o1_.description AS description_11,
  o2_.id AS id_12,
  o2_.name AS name_13,
  o2_.description AS description_14,
  o2_.created_at AS created_at_15,
  o2_.active AS active_16,
  o2_.phone AS phone_17,
  o2_.email AS email_18,
  o2_.fax AS fax_19,
  o2_.tvanumber AS tvanumber_20,
  o2_.linkfacebook AS linkfacebook_21,
  o2_.linkinstagram AS linkinstagram_22,
  o2_.linklinkedin AS linklinkedin_23,
  o2_.linkyoutube AS linkyoutube_24,
  o2_.linktiktok AS linktiktok_25,
  o2_.image AS image_26,
  o2_.adresse AS adresse_27,
  o2_.adresselat AS adresselat_28,
  o2_.adresselong AS adresselong_29,
  o2_.linktwitter AS linktwitter_30,
  o2_.histoire AS histoire_31,
  o2_.activemap AS activemap_32,
  o2_.premium AS premium_33,
  o2_.localite AS localite_34,
  o2_.siteinternet AS siteinternet_35,
  o3_.id AS id_36,
  o3_.name AS name_37,
  o3_.description AS description_38,
  o4_.id AS id_39,
  o4_.name AS name_40,
  o4_.description AS description_41,
  o4_.image AS image_42,
  o4_.active AS active_43,
  o4_.created_at AS created_at_44,
  o4_.buttonperso AS buttonperso_45,
  o4_.buttonpersolink AS buttonpersolink_46,
  o4_.buttonpersoname AS buttonpersoname_47,
  o5_.id AS id_48,
  o5_.name AS name_49,
  o5_.description AS description_50,
  o6_.id AS id_51,
  o6_.ville AS ville_52,
  o6_.cp AS cp_53,
  o7_.id AS id_54,
  o7_.nom AS nom_55,
  o7_.prenom AS prenom_56,
  o7_.email AS email_57,
  o7_.image AS image_58,
  o7_.fonction AS fonction_59,
  o7_.active AS active_60,
  o8_.id AS id_61,
  o8_.plateform AS plateform_62,
  o8_.token AS token_63,
  o8_.createdat AS createdat_64,
  o9_.id AS id_65,
  o9_.name AS name_66,
  o9_.createdat AS createdat_67,
  o9_.image AS image_68,
  o0_.created_by_id AS created_by_id_69,
  o0_.entreprise_id AS entreprise_id_70,
  o1_.og_conseils_id AS og_conseils_id_71,
  o2_.created_by_id AS created_by_id_72,
  o2_.category_id AS category_id_73,
  o4_.created_by_id AS created_by_id_74,
  o4_.entreprise_id AS entreprise_id_75,
  o5_.og_conseils_id AS og_conseils_id_76,
  o8_.entreprise_id AS entreprise_id_77,
  o8_.user_id AS user_id_78,
  o9_.entreprise_id AS entreprise_id_79
FROM
  og_conseils o0_
  LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id
  LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id
  LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id
  LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id
  LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id
  LEFT JOIN og_entreprises_og_codepostaux o10_ ON o2_.id = o10_.og_entreprises_id
  LEFT JOIN og_codepostaux o6_ ON o6_.id = o10_.og_codepostaux_id
  LEFT JOIN og_entreprises_staff_og_entreprises o11_ ON o2_.id = o11_.og_entreprises_id
  LEFT JOIN og_entreprises_staff o7_ ON o7_.id = o11_.og_entreprises_staff_id
  LEFT JOIN og_entreprises_notifications o8_ ON o2_.id = o8_.entreprise_id
  LEFT JOIN og_entreprises_images o9_ ON o2_.id = o9_.entreprise_id
WHERE
  o0_.active = ?
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.description AS description_2, o0_.image AS image_3, o0_.active AS active_4, o0_.created_at AS created_at_5, o0_.buttonperso AS buttonperso_6, o0_.buttonpersolink AS buttonpersolink_7, o0_.buttonpersoname AS buttonpersoname_8, o1_.id AS id_9, o1_.name AS name_10, o1_.description AS description_11, o2_.id AS id_12, o2_.name AS name_13, o2_.description AS description_14, o2_.created_at AS created_at_15, o2_.active AS active_16, o2_.phone AS phone_17, o2_.email AS email_18, o2_.fax AS fax_19, o2_.tvanumber AS tvanumber_20, o2_.linkfacebook AS linkfacebook_21, o2_.linkinstagram AS linkinstagram_22, o2_.linklinkedin AS linklinkedin_23, o2_.linkyoutube AS linkyoutube_24, o2_.linktiktok AS linktiktok_25, o2_.image AS image_26, o2_.adresse AS adresse_27, o2_.adresselat AS adresselat_28, o2_.adresselong AS adresselong_29, o2_.linktwitter AS linktwitter_30, o2_.histoire AS histoire_31, o2_.activemap AS activemap_32, o2_.premium AS premium_33, o2_.localite AS localite_34, o2_.siteinternet AS siteinternet_35, o3_.id AS id_36, o3_.name AS name_37, o3_.description AS description_38, o4_.id AS id_39, o4_.name AS name_40, o4_.description AS description_41, o4_.image AS image_42, o4_.active AS active_43, o4_.created_at AS created_at_44, o4_.buttonperso AS buttonperso_45, o4_.buttonpersolink AS buttonpersolink_46, o4_.buttonpersoname AS buttonpersoname_47, o5_.id AS id_48, o5_.name AS name_49, o5_.description AS description_50, o6_.id AS id_51, o6_.ville AS ville_52, o6_.cp AS cp_53, o7_.id AS id_54, o7_.nom AS nom_55, o7_.prenom AS prenom_56, o7_.email AS email_57, o7_.image AS image_58, o7_.fonction AS fonction_59, o7_.active AS active_60, o8_.id AS id_61, o8_.plateform AS plateform_62, o8_.token AS token_63, o8_.createdat AS createdat_64, o9_.id AS id_65, o9_.name AS name_66, o9_.createdat AS createdat_67, o9_.image AS image_68, o0_.created_by_id AS created_by_id_69, o0_.entreprise_id AS entreprise_id_70, o1_.og_conseils_id AS og_conseils_id_71, o2_.created_by_id AS created_by_id_72, o2_.category_id AS category_id_73, o4_.created_by_id AS created_by_id_74, o4_.entreprise_id AS entreprise_id_75, o5_.og_conseils_id AS og_conseils_id_76, o8_.entreprise_id AS entreprise_id_77, o8_.user_id AS user_id_78, o9_.entreprise_id AS entreprise_id_79 FROM og_conseils o0_ LEFT JOIN og_category_conseils o1_ ON o0_.id = o1_.og_conseils_id LEFT JOIN og_entreprises o2_ ON o0_.entreprise_id = o2_.id LEFT JOIN og_entreprises_category o3_ ON o2_.category_id = o3_.id LEFT JOIN og_conseils o4_ ON o2_.id = o4_.entreprise_id LEFT JOIN og_category_conseils o5_ ON o4_.id = o5_.og_conseils_id LEFT JOIN og_entreprises_og_codepostaux o10_ ON o2_.id = o10_.og_entreprises_id LEFT JOIN og_codepostaux o6_ ON o6_.id = o10_.og_codepostaux_id LEFT JOIN og_entreprises_staff_og_entreprises o11_ ON o2_.id = o11_.og_entreprises_id LEFT JOIN og_entreprises_staff o7_ ON o7_.id = o11_.og_entreprises_staff_id LEFT JOIN og_entreprises_notifications o8_ ON o2_.id = o8_.entreprise_id LEFT JOIN og_entreprises_images o9_ ON o2_.id = o9_.entreprise_id WHERE o0_.active = 1 AND o0_.id IN (85, 84, 83, 82, 81, 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 58, 57, 56, 55) ORDER BY o0_.id DESC;