Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.description AS description_1,
  s0_.icon AS icon_2,
  COUNT(e1_.id) AS sclr_3
FROM
  secteur s0_
  LEFT JOIN emploie e1_ ON s0_.id = e1_.secteur_id
  AND (e1_.is_valid = 1)
GROUP BY
  s0_.id
ORDER BY
  sclr_3 DESC
LIMIT
  8

SELECT s0_.id AS id_0, s0_.description AS description_1, s0_.icon AS icon_2, COUNT(e1_.id) AS sclr_3 FROM secteur s0_ LEFT JOIN emploie e1_ ON s0_.id = e1_.secteur_id AND (e1_.is_valid = 1) GROUP BY s0_.id ORDER BY sclr_3 DESC LIMIT 8;

SELECT
  COUNT(*)
FROM
  emploie t0
WHERE
  t0.is_valid = ?

SELECT COUNT(*) FROM emploie t0 WHERE t0.is_valid = 1;

SELECT
  COUNT(*)
FROM
  user_follow

SELECT COUNT(*) FROM user_follow;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenom AS prenom_5,
  u0_.username AS username_6,
  u0_.telephone AS telephone_7,
  u0_.organisation AS organisation_8,
  u0_.created_at AS created_at_9,
  u0_.updated_at AS updated_at_10,
  u0_.description AS description_11,
  u0_.avatar AS avatar_12,
  u0_.logo AS logo_13,
  u0_.age AS age_14,
  u0_.date_naissance AS date_naissance_15,
  u0_.is_approuved AS is_approuved_16,
  u0_.titre_emploie AS titre_emploie_17,
  u0_.other_metier AS other_metier_18,
  u0_.facebook AS facebook_19,
  u0_.twitter AS twitter_20,
  u0_.linkedin AS linkedin_21,
  u0_.etat AS etat_22,
  u0_.code_postal AS code_postal_23,
  u0_.latitude AS latitude_24,
  u0_.longitude AS longitude_25,
  u0_.zoom AS zoom_26,
  u0_.image_couverture AS image_couverture_27,
  u0_.slug AS slug_28,
  u0_.website AS website_29,
  u0_.date_creation AS date_creation_30,
  u0_.adresse AS adresse_31,
  u0_.tags AS tags_32,
  u0_.is_valid AS is_valid_33,
  u0_.is_urgent AS is_urgent_34,
  u0_.google_id AS google_id_35,
  u0_.is_notification AS is_notification_36,
  u0_.is_hidden_email AS is_hidden_email_37,
  u0_.metier_id AS metier_id_38,
  u0_.expertise_id AS expertise_id_39,
  u0_.niveau_id AS niveau_id_40,
  u0_.secteur_id AS secteur_id_41,
  u0_.genre_id AS genre_id_42
FROM
  user u0_
WHERE
  u0_.roles LIKE ?
  AND u0_.is_valid = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.username AS username_6, u0_.telephone AS telephone_7, u0_.organisation AS organisation_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.description AS description_11, u0_.avatar AS avatar_12, u0_.logo AS logo_13, u0_.age AS age_14, u0_.date_naissance AS date_naissance_15, u0_.is_approuved AS is_approuved_16, u0_.titre_emploie AS titre_emploie_17, u0_.other_metier AS other_metier_18, u0_.facebook AS facebook_19, u0_.twitter AS twitter_20, u0_.linkedin AS linkedin_21, u0_.etat AS etat_22, u0_.code_postal AS code_postal_23, u0_.latitude AS latitude_24, u0_.longitude AS longitude_25, u0_.zoom AS zoom_26, u0_.image_couverture AS image_couverture_27, u0_.slug AS slug_28, u0_.website AS website_29, u0_.date_creation AS date_creation_30, u0_.adresse AS adresse_31, u0_.tags AS tags_32, u0_.is_valid AS is_valid_33, u0_.is_urgent AS is_urgent_34, u0_.google_id AS google_id_35, u0_.is_notification AS is_notification_36, u0_.is_hidden_email AS is_hidden_email_37, u0_.metier_id AS metier_id_38, u0_.expertise_id AS expertise_id_39, u0_.niveau_id AS niveau_id_40, u0_.secteur_id AS secteur_id_41, u0_.genre_id AS genre_id_42 FROM user u0_ WHERE u0_.roles LIKE '%\"ROLE_CANDIDAT\"%' AND u0_.is_valid = 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenom AS prenom_5,
  u0_.username AS username_6,
  u0_.telephone AS telephone_7,
  u0_.organisation AS organisation_8,
  u0_.created_at AS created_at_9,
  u0_.updated_at AS updated_at_10,
  u0_.description AS description_11,
  u0_.avatar AS avatar_12,
  u0_.logo AS logo_13,
  u0_.age AS age_14,
  u0_.date_naissance AS date_naissance_15,
  u0_.is_approuved AS is_approuved_16,
  u0_.titre_emploie AS titre_emploie_17,
  u0_.other_metier AS other_metier_18,
  u0_.facebook AS facebook_19,
  u0_.twitter AS twitter_20,
  u0_.linkedin AS linkedin_21,
  u0_.etat AS etat_22,
  u0_.code_postal AS code_postal_23,
  u0_.latitude AS latitude_24,
  u0_.longitude AS longitude_25,
  u0_.zoom AS zoom_26,
  u0_.image_couverture AS image_couverture_27,
  u0_.slug AS slug_28,
  u0_.website AS website_29,
  u0_.date_creation AS date_creation_30,
  u0_.adresse AS adresse_31,
  u0_.tags AS tags_32,
  u0_.is_valid AS is_valid_33,
  u0_.is_urgent AS is_urgent_34,
  u0_.google_id AS google_id_35,
  u0_.is_notification AS is_notification_36,
  u0_.is_hidden_email AS is_hidden_email_37,
  u0_.metier_id AS metier_id_38,
  u0_.expertise_id AS expertise_id_39,
  u0_.niveau_id AS niveau_id_40,
  u0_.secteur_id AS secteur_id_41,
  u0_.genre_id AS genre_id_42
FROM
  user u0_
  LEFT JOIN emploie e1_ ON u0_.id = e1_.user_id
WHERE
  u0_.roles LIKE ?
GROUP BY
  u0_.id
ORDER BY
  COUNT(e1_.id) DESC
LIMIT
  4

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.username AS username_6, u0_.telephone AS telephone_7, u0_.organisation AS organisation_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.description AS description_11, u0_.avatar AS avatar_12, u0_.logo AS logo_13, u0_.age AS age_14, u0_.date_naissance AS date_naissance_15, u0_.is_approuved AS is_approuved_16, u0_.titre_emploie AS titre_emploie_17, u0_.other_metier AS other_metier_18, u0_.facebook AS facebook_19, u0_.twitter AS twitter_20, u0_.linkedin AS linkedin_21, u0_.etat AS etat_22, u0_.code_postal AS code_postal_23, u0_.latitude AS latitude_24, u0_.longitude AS longitude_25, u0_.zoom AS zoom_26, u0_.image_couverture AS image_couverture_27, u0_.slug AS slug_28, u0_.website AS website_29, u0_.date_creation AS date_creation_30, u0_.adresse AS adresse_31, u0_.tags AS tags_32, u0_.is_valid AS is_valid_33, u0_.is_urgent AS is_urgent_34, u0_.google_id AS google_id_35, u0_.is_notification AS is_notification_36, u0_.is_hidden_email AS is_hidden_email_37, u0_.metier_id AS metier_id_38, u0_.expertise_id AS expertise_id_39, u0_.niveau_id AS niveau_id_40, u0_.secteur_id AS secteur_id_41, u0_.genre_id AS genre_id_42 FROM user u0_ LEFT JOIN emploie e1_ ON u0_.id = e1_.user_id WHERE u0_.roles LIKE '%\"ROLE_EMPLOYEUR\"%' GROUP BY u0_.id ORDER BY COUNT(e1_.id) DESC LIMIT 4;

SELECT
  e.*,
  COUNT(ue.user_id) AS favCount,
  u.id AS user_id,
  u.nom AS user_nom,
  u.email AS user_email,
  u.organisation AS user_organisation,
  u.logo AS user_logo,
  u.slug AS user_slug
FROM
  emploie e
  LEFT JOIN user_emploie ue ON ue.emploie_id = e.id
  LEFT JOIN user u ON e.user_id = u.id
WHERE
  e.is_valid = 1
GROUP BY
  e.id,
  u.id
ORDER BY
  favCount DESC
LIMIT
  :limit

SELECT e.*, COUNT(ue.user_id) AS favCount, u.id AS user_id, u.nom AS user_nom, u.email AS user_email, u.organisation AS user_organisation, u.logo AS user_logo, u.slug AS user_slug
            FROM emploie e
            LEFT JOIN user_emploie ue ON ue.emploie_id = e.id
            LEFT JOIN user u ON e.user_id = u.id
            WHERE e.is_valid = 1
            GROUP BY e.id, u.id
            ORDER BY favCount DESC
            LIMIT 6
        ;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.lien AS lien_7
FROM
  partenaire t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.lien AS lien_7 FROM partenaire t0;

SELECT
  m0_.id AS id_0,
  m0_.description AS description_1
FROM
  metier m0_

SELECT m0_.id AS id_0, m0_.description AS description_1 FROM metier m0_;

SELECT
  s0_.id AS id_0,
  s0_.descripption AS descripption_1
FROM
  secteur_entreprise s0_

SELECT s0_.id AS id_0, s0_.descripption AS descripption_1 FROM secteur_entreprise s0_;

SELECT
  s0_.id AS id_0,
  s0_.description AS description_1,
  s0_.icon AS icon_2
FROM
  secteur s0_

SELECT s0_.id AS id_0, s0_.description AS description_1, s0_.icon AS icon_2 FROM secteur s0_;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date_limite_candidature AS date_limite_candidature_4,
  t0.voie_application AS voie_application_5,
  t0.type_voie_application AS type_voie_application_6,
  t0.genre AS genre_7,
  t0.fichier AS fichier_8,
  t0.etat AS etat_9,
  t0.code_postal AS code_postal_10,
  t0.adresse AS adresse_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.zoom AS zoom_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.reference AS reference_18,
  t0.competence AS competence_19,
  t0.is_valid AS is_valid_20,
  t0.is_urgent AS is_urgent_21,
  t0.is_vedette AS is_vedette_22,
  t0.type_emploie_id AS type_emploie_id_23,
  t0.experience_id AS experience_id_24,
  t0.metier_id AS metier_id_25,
  t0.niveau_id AS niveau_id_26,
  t0.secteur_id AS secteur_id_27,
  t0.expertise_id AS expertise_id_28,
  t0.user_id AS user_id_29
FROM
  emploie t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = 13;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date_limite_candidature AS date_limite_candidature_4,
  t0.voie_application AS voie_application_5,
  t0.type_voie_application AS type_voie_application_6,
  t0.genre AS genre_7,
  t0.fichier AS fichier_8,
  t0.etat AS etat_9,
  t0.code_postal AS code_postal_10,
  t0.adresse AS adresse_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.zoom AS zoom_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.reference AS reference_18,
  t0.competence AS competence_19,
  t0.is_valid AS is_valid_20,
  t0.is_urgent AS is_urgent_21,
  t0.is_vedette AS is_vedette_22,
  t0.type_emploie_id AS type_emploie_id_23,
  t0.experience_id AS experience_id_24,
  t0.metier_id AS metier_id_25,
  t0.niveau_id AS niveau_id_26,
  t0.secteur_id AS secteur_id_27,
  t0.expertise_id AS expertise_id_28,
  t0.user_id AS user_id_29
FROM
  emploie t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = 220;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date_limite_candidature AS date_limite_candidature_4,
  t0.voie_application AS voie_application_5,
  t0.type_voie_application AS type_voie_application_6,
  t0.genre AS genre_7,
  t0.fichier AS fichier_8,
  t0.etat AS etat_9,
  t0.code_postal AS code_postal_10,
  t0.adresse AS adresse_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.zoom AS zoom_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.reference AS reference_18,
  t0.competence AS competence_19,
  t0.is_valid AS is_valid_20,
  t0.is_urgent AS is_urgent_21,
  t0.is_vedette AS is_vedette_22,
  t0.type_emploie_id AS type_emploie_id_23,
  t0.experience_id AS experience_id_24,
  t0.metier_id AS metier_id_25,
  t0.niveau_id AS niveau_id_26,
  t0.secteur_id AS secteur_id_27,
  t0.expertise_id AS expertise_id_28,
  t0.user_id AS user_id_29
FROM
  emploie t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = 15;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date_limite_candidature AS date_limite_candidature_4,
  t0.voie_application AS voie_application_5,
  t0.type_voie_application AS type_voie_application_6,
  t0.genre AS genre_7,
  t0.fichier AS fichier_8,
  t0.etat AS etat_9,
  t0.code_postal AS code_postal_10,
  t0.adresse AS adresse_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.zoom AS zoom_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.reference AS reference_18,
  t0.competence AS competence_19,
  t0.is_valid AS is_valid_20,
  t0.is_urgent AS is_urgent_21,
  t0.is_vedette AS is_vedette_22,
  t0.type_emploie_id AS type_emploie_id_23,
  t0.experience_id AS experience_id_24,
  t0.metier_id AS metier_id_25,
  t0.niveau_id AS niveau_id_26,
  t0.secteur_id AS secteur_id_27,
  t0.expertise_id AS expertise_id_28,
  t0.user_id AS user_id_29
FROM
  emploie t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = 27;