Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.slug AS slug_4,
  t0.actif AS actif_5,
  t0.created_at AS created_at_6
FROM
  tag t0
  INNER JOIN offre_tag ON t0.id = offre_tag.tag_id
WHERE
  offre_tag.offre_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.slug AS slug_4, t0.actif AS actif_5, t0.created_at AS created_at_6 FROM tag t0 INNER JOIN offre_tag ON t0.id = offre_tag.tag_id WHERE offre_tag.offre_id = 7331;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN source s1_ ON o0_.source_id = s1_.id
  LEFT JOIN entreprise e2_ ON o0_.entreprise_id = e2_.id
  LEFT JOIN ville v3_ ON o0_.ville_id = v3_.id
  LEFT JOIN country c4_ ON o0_.country_id = c4_.id
  LEFT JOIN secteur_famille s5_ ON o0_.secteur_famille_id = s5_.id

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN source s1_ ON o0_.source_id = s1_.id LEFT JOIN entreprise e2_ ON o0_.entreprise_id = e2_.id LEFT JOIN ville v3_ ON o0_.ville_id = v3_.id LEFT JOIN country c4_ ON o0_.country_id = c4_.id LEFT JOIN secteur_famille s5_ ON o0_.secteur_famille_id = s5_.id;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.slug AS slug_4,
  t0.actif AS actif_5,
  t0.created_at AS created_at_6
FROM
  competence_technique t0
  INNER JOIN offre_competence_technique ON t0.id = offre_competence_technique.competence_technique_id
WHERE
  offre_competence_technique.offre_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.slug AS slug_4, t0.actif AS actif_5, t0.created_at AS created_at_6 FROM competence_technique t0 INNER JOIN offre_competence_technique ON t0.id = offre_competence_technique.competence_technique_id WHERE offre_competence_technique.offre_id = 7331;

SELECT
  o0_.id AS id_0,
  o0_.code AS code_1,
  o0_.url_originale AS url_originale_2,
  o0_.dedupe_key AS dedupe_key_3,
  o0_.id_annonce AS id_annonce_4,
  o0_.recruteur_id AS recruteur_id_5,
  o0_.texte_breut AS texte_breut_6,
  o0_.titre AS titre_7,
  o0_.description AS description_8,
  o0_.profil AS profil_9,
  o0_.reference AS reference_10,
  o0_.ville_raw AS ville_raw_11,
  o0_.competences AS competences_12,
  o0_.tags AS tags_13,
  o0_.urgent AS urgent_14,
  o0_.embedding AS embedding_15,
  o0_.actif AS actif_16,
  o0_.detail_status AS detail_status_17,
  o0_.embedding_generated_at AS embedding_generated_at_18,
  o0_.embedding_text_hash AS embedding_text_hash_19,
  o0_.expire_at AS expire_at_20,
  o0_.published_at AS published_at_21,
  o0_.published_at_iso AS published_at_iso_22,
  o0_.created_at AS created_at_23,
  o0_.updated_at AS updated_at_24,
  s1_.id AS id_25,
  s1_.code AS code_26,
  s1_.designation AS designation_27,
  s1_.url_base AS url_base_28,
  s1_.actif AS actif_29,
  s1_.needs_extraction AS needs_extraction_30,
  s1_.scrape_interval_heures AS scrape_interval_heures_31,
  s1_.derniere_scrape_at AS derniere_scrape_at_32,
  s1_.offres_total_count AS offres_total_count_33,
  s1_.offres_actives_count AS offres_actives_count_34,
  s1_.created_at AS created_at_35,
  e2_.id AS id_36,
  e2_.code AS code_37,
  e2_.designation AS designation_38,
  e2_.activite_entreprise AS activite_entreprise_39,
  e2_.created_at AS created_at_40,
  v3_.id AS id_41,
  v3_.code AS code_42,
  v3_.designation AS designation_43,
  v3_.designation_en AS designation_en_44,
  v3_.designation_mg AS designation_mg_45,
  v3_.latitude AS latitude_46,
  v3_.longitude AS longitude_47,
  v3_.actif AS actif_48,
  v3_.total_offre AS total_offre_49,
  v3_.created_at AS created_at_50,
  c4_.id AS id_51,
  c4_.code AS code_52,
  c4_.designation AS designation_53,
  c4_.created_at AS created_at_54,
  s5_.id AS id_55,
  s5_.code AS code_56,
  s5_.designation AS designation_57,
  s5_.designation_en AS designation_en_58,
  s5_.designation_mg AS designation_mg_59,
  s5_.icon AS icon_60,
  s5_.ordre AS ordre_61,
  s5_.actif AS actif_62,
  s5_.created_at AS created_at_63,
  o0_.source_id AS source_id_64,
  o0_.entreprise_id AS entreprise_id_65,
  o0_.ville_id AS ville_id_66,
  o0_.country_id AS country_id_67,
  o0_.secteur_famille_id AS secteur_famille_id_68,
  o0_.type_contrat_id AS type_contrat_id_69,
  o0_.mode_travail_id AS mode_travail_id_70,
  o0_.niveau_experience_id AS niveau_experience_id_71,
  v3_.region_id AS region_id_72,
  v3_.country_id AS country_id_73
FROM
  offre o0_
  INNER JOIN source s1_ ON o0_.source_id = s1_.id
  LEFT JOIN entreprise e2_ ON o0_.entreprise_id = e2_.id
  LEFT JOIN ville v3_ ON o0_.ville_id = v3_.id
  LEFT JOIN country c4_ ON o0_.country_id = c4_.id
  LEFT JOIN secteur_famille s5_ ON o0_.secteur_famille_id = s5_.id
ORDER BY
  o0_.published_at DESC
LIMIT
  20

SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.url_originale AS url_originale_2, o0_.dedupe_key AS dedupe_key_3, o0_.id_annonce AS id_annonce_4, o0_.recruteur_id AS recruteur_id_5, o0_.texte_breut AS texte_breut_6, o0_.titre AS titre_7, o0_.description AS description_8, o0_.profil AS profil_9, o0_.reference AS reference_10, o0_.ville_raw AS ville_raw_11, o0_.competences AS competences_12, o0_.tags AS tags_13, o0_.urgent AS urgent_14, o0_.embedding AS embedding_15, o0_.actif AS actif_16, o0_.detail_status AS detail_status_17, o0_.embedding_generated_at AS embedding_generated_at_18, o0_.embedding_text_hash AS embedding_text_hash_19, o0_.expire_at AS expire_at_20, o0_.published_at AS published_at_21, o0_.published_at_iso AS published_at_iso_22, o0_.created_at AS created_at_23, o0_.updated_at AS updated_at_24, s1_.id AS id_25, s1_.code AS code_26, s1_.designation AS designation_27, s1_.url_base AS url_base_28, s1_.actif AS actif_29, s1_.needs_extraction AS needs_extraction_30, s1_.scrape_interval_heures AS scrape_interval_heures_31, s1_.derniere_scrape_at AS derniere_scrape_at_32, s1_.offres_total_count AS offres_total_count_33, s1_.offres_actives_count AS offres_actives_count_34, s1_.created_at AS created_at_35, e2_.id AS id_36, e2_.code AS code_37, e2_.designation AS designation_38, e2_.activite_entreprise AS activite_entreprise_39, e2_.created_at AS created_at_40, v3_.id AS id_41, v3_.code AS code_42, v3_.designation AS designation_43, v3_.designation_en AS designation_en_44, v3_.designation_mg AS designation_mg_45, v3_.latitude AS latitude_46, v3_.longitude AS longitude_47, v3_.actif AS actif_48, v3_.total_offre AS total_offre_49, v3_.created_at AS created_at_50, c4_.id AS id_51, c4_.code AS code_52, c4_.designation AS designation_53, c4_.created_at AS created_at_54, s5_.id AS id_55, s5_.code AS code_56, s5_.designation AS designation_57, s5_.designation_en AS designation_en_58, s5_.designation_mg AS designation_mg_59, s5_.icon AS icon_60, s5_.ordre AS ordre_61, s5_.actif AS actif_62, s5_.created_at AS created_at_63, o0_.source_id AS source_id_64, o0_.entreprise_id AS entreprise_id_65, o0_.ville_id AS ville_id_66, o0_.country_id AS country_id_67, o0_.secteur_famille_id AS secteur_famille_id_68, o0_.type_contrat_id AS type_contrat_id_69, o0_.mode_travail_id AS mode_travail_id_70, o0_.niveau_experience_id AS niveau_experience_id_71, v3_.region_id AS region_id_72, v3_.country_id AS country_id_73 FROM offre o0_ INNER JOIN source s1_ ON o0_.source_id = s1_.id LEFT JOIN entreprise e2_ ON o0_.entreprise_id = e2_.id LEFT JOIN ville v3_ ON o0_.ville_id = v3_.id LEFT JOIN country c4_ ON o0_.country_id = c4_.id LEFT JOIN secteur_famille s5_ ON o0_.secteur_famille_id = s5_.id ORDER BY o0_.published_at DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.actif AS actif_6,
  t0.created_at AS created_at_7,
  t0.last_login_at AS last_login_at_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.nom_prenom AS nom_prenom_10,
  t0.verified_at AS verified_at_11,
  t0.is_enabled AS is_enabled_12,
  t0.last_updated_at AS last_updated_at_13,
  t14.id AS id_15,
  t14.code AS code_16,
  t14.onboarding_completed_at AS onboarding_completed_at_17,
  t14.onboarding_completed AS onboarding_completed_18,
  t14.locale AS locale_19,
  t14.nom AS nom_20,
  t14.prenom AS prenom_21,
  t14.metier_principal AS metier_principal_22,
  t14.specialite AS specialite_23,
  t14.ville AS ville_24,
  t14.disponible AS disponible_25,
  t14.experience_annees AS experience_annees_26,
  t14.salaire_min AS salaire_min_27,
  t14.devise AS devise_28,
  t14.niveau_etudes AS niveau_etudes_29,
  t14.competences AS competences_30,
  t14.langues AS langues_31,
  t14.filtres_strict AS filtres_strict_32,
  t14.preferences AS preferences_33,
  t14.score_completion AS score_completion_34,
  t14.prochaine_question AS prochaine_question_35,
  t14.embedding AS embedding_36,
  t14.embedding_updated_at AS embedding_updated_at_37,
  t14.latitude AS latitude_38,
  t14.longitude AS longitude_39,
  t14.created_at AS created_at_40,
  t14.updated_at AS updated_at_41,
  t14.utilisateur_id AS utilisateur_id_42,
  t14.intent_id AS intent_id_43,
  t14.disponibilite_id AS disponibilite_id_44,
  t14.location_scope_id AS location_scope_id_45,
  t0.utilisateur_role_id AS utilisateur_role_id_46
FROM
  utilisateur t0
  LEFT JOIN profile t14 ON t14.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8, t0.last_activity_at AS last_activity_at_9, t0.nom_prenom AS nom_prenom_10, t0.verified_at AS verified_at_11, t0.is_enabled AS is_enabled_12, t0.last_updated_at AS last_updated_at_13, t14.id AS id_15, t14.code AS code_16, t14.onboarding_completed_at AS onboarding_completed_at_17, t14.onboarding_completed AS onboarding_completed_18, t14.locale AS locale_19, t14.nom AS nom_20, t14.prenom AS prenom_21, t14.metier_principal AS metier_principal_22, t14.specialite AS specialite_23, t14.ville AS ville_24, t14.disponible AS disponible_25, t14.experience_annees AS experience_annees_26, t14.salaire_min AS salaire_min_27, t14.devise AS devise_28, t14.niveau_etudes AS niveau_etudes_29, t14.competences AS competences_30, t14.langues AS langues_31, t14.filtres_strict AS filtres_strict_32, t14.preferences AS preferences_33, t14.score_completion AS score_completion_34, t14.prochaine_question AS prochaine_question_35, t14.embedding AS embedding_36, t14.embedding_updated_at AS embedding_updated_at_37, t14.latitude AS latitude_38, t14.longitude AS longitude_39, t14.created_at AS created_at_40, t14.updated_at AS updated_at_41, t14.utilisateur_id AS utilisateur_id_42, t14.intent_id AS intent_id_43, t14.disponibilite_id AS disponibilite_id_44, t14.location_scope_id AS location_scope_id_45, t0.utilisateur_role_id AS utilisateur_role_id_46 FROM utilisateur t0 LEFT JOIN profile t14 ON t14.utilisateur_id = t0.id WHERE t0.id = 1;