Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.parents AS parents_4,
  t0.etat AS etat_5,
  t0.niveau AS niveau_6,
  t0.token AS token_7,
  t0.date_creation AS date_creation_8,
  t0.date_update AS date_update_9,
  t0.type AS type_10,
  t0.image AS image_11,
  t0.dir AS dir_12,
  t0.pays AS pays_13,
  t0.departements AS departements_14,
  t0.topbar AS topbar_15,
  t0.sidebar AS sidebar_16,
  t0.id_topbar AS id_topbar_17,
  t0.libelle AS libelle_18,
  t0.super_parents AS super_parents_19,
  t0.synonymes AS synonymes_20,
  t0.num_competence AS num_competence_21,
  t0.num_parent AS num_parent_22,
  t0.url AS url_23,
  t0.nom_fr AS nom_fr_24,
  t0.nom_en AS nom_en_25,
  t0.nom_de AS nom_de_26,
  t0.nom_be AS nom_be_27,
  t0.restriction_pays AS restriction_pays_28,
  t0.arr_questions AS arr_questions_29,
  t0.cout AS cout_30,
  t0.abreviation_type AS abreviation_type_31,
  t0.is_expert AS is_expert_32,
  t0.is_interest AS is_interest_33,
  t0.group_type AS group_type_34,
  t0.expert_attributes AS expert_attributes_35,
  t0.interest_attributes AS interest_attributes_36,
  t0.code_ape AS code_ape_37,
  t0.abt_nr AS abt_nr_38,
  t0.num_unique AS num_unique_39,
  t0.designation_originale AS designation_originale_40,
  t0.uvp AS uvp_41,
  t0.pvs AS pvs_42,
  t0.obra AS obra_43,
  t0.ref_enfants AS ref_enfants_44,
  t0.mitih_wz AS mitih_wz_45,
  t0.index_num_0001 AS index_num_0001_46,
  t0.index_num_group AS index_num_group_47,
  t0.aqs AS aqs_48,
  t0.ape_id AS ape_id_49,
  t0.demandeur_entreprise_id AS demandeur_entreprise_id_50
FROM
  competences t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.parents AS parents_4, t0.etat AS etat_5, t0.niveau AS niveau_6, t0.token AS token_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9, t0.type AS type_10, t0.image AS image_11, t0.dir AS dir_12, t0.pays AS pays_13, t0.departements AS departements_14, t0.topbar AS topbar_15, t0.sidebar AS sidebar_16, t0.id_topbar AS id_topbar_17, t0.libelle AS libelle_18, t0.super_parents AS super_parents_19, t0.synonymes AS synonymes_20, t0.num_competence AS num_competence_21, t0.num_parent AS num_parent_22, t0.url AS url_23, t0.nom_fr AS nom_fr_24, t0.nom_en AS nom_en_25, t0.nom_de AS nom_de_26, t0.nom_be AS nom_be_27, t0.restriction_pays AS restriction_pays_28, t0.arr_questions AS arr_questions_29, t0.cout AS cout_30, t0.abreviation_type AS abreviation_type_31, t0.is_expert AS is_expert_32, t0.is_interest AS is_interest_33, t0.group_type AS group_type_34, t0.expert_attributes AS expert_attributes_35, t0.interest_attributes AS interest_attributes_36, t0.code_ape AS code_ape_37, t0.abt_nr AS abt_nr_38, t0.num_unique AS num_unique_39, t0.designation_originale AS designation_originale_40, t0.uvp AS uvp_41, t0.pvs AS pvs_42, t0.obra AS obra_43, t0.ref_enfants AS ref_enfants_44, t0.mitih_wz AS mitih_wz_45, t0.index_num_0001 AS index_num_0001_46, t0.index_num_group AS index_num_group_47, t0.aqs AS aqs_48, t0.ape_id AS ape_id_49, t0.demandeur_entreprise_id AS demandeur_entreprise_id_50 FROM competences t0 ORDER BY t0.nom ASC;

SELECT
  t0.id AS id_1,
  t0.code_ape AS code_ape_2,
  t0.level1_nr AS level1_nr_3,
  t0.level1_fr AS level1_fr_4,
  t0.level1_en AS level1_en_5,
  t0.level1_de AS level1_de_6,
  t0.obra_key AS obra_key_7,
  t0.level2_nr AS level2_nr_8,
  t0.level2_fr AS level2_fr_9,
  t0.level2_en AS level2_en_10,
  t0.level2_de AS level2_de_11,
  t0.ubra_key AS ubra_key_12,
  t0.designation_comptable AS designation_comptable_13,
  t0.classe_technique AS classe_technique_14,
  t0.label_ape_fr AS label_ape_fr_15,
  t0.label_ape_de AS label_ape_de_16,
  t0.label_ape_en AS label_ape_en_17
FROM
  ape2 t0
ORDER BY
  t0.code_ape ASC

SELECT t0.id AS id_1, t0.code_ape AS code_ape_2, t0.level1_nr AS level1_nr_3, t0.level1_fr AS level1_fr_4, t0.level1_en AS level1_en_5, t0.level1_de AS level1_de_6, t0.obra_key AS obra_key_7, t0.level2_nr AS level2_nr_8, t0.level2_fr AS level2_fr_9, t0.level2_en AS level2_en_10, t0.level2_de AS level2_de_11, t0.ubra_key AS ubra_key_12, t0.designation_comptable AS designation_comptable_13, t0.classe_technique AS classe_technique_14, t0.label_ape_fr AS label_ape_fr_15, t0.label_ape_de AS label_ape_de_16, t0.label_ape_en AS label_ape_en_17 FROM ape2 t0 ORDER BY t0.code_ape ASC;

SELECT
  t0.id AS id_1,
  t0.pays AS pays_2,
  t0.code AS code_3,
  t0.langue AS langue_4,
  t0.encodage AS encodage_5,
  t0.img AS img_6,
  t0.dir AS dir_7,
  t0.date_creation AS date_creation_8
FROM
  langue t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = 'FR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.route AS route_2,
  t0.date_creation AS date_creation_3,
  t0.date_update AS date_update_4,
  t0.libelles_traduits AS libelles_traduits_5,
  t0.langue_id AS langue_id_6
FROM
  traduction t0
WHERE
  t0.route = ?
  AND t0.langue_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = 'accueil' AND t0.langue_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.titre_accroche AS titre_accroche_4,
  t0.description AS description_5,
  t0.menu_links AS menu_links_6,
  t0.horaire_mairie AS horaire_mairie_7,
  t0.liens_demarches AS liens_demarches_8,
  t0.liens_agenda AS liens_agenda_9,
  t0.background_image AS background_image_10,
  t0.dir_bg AS dir_bg_11,
  t0.image AS image_12,
  t0.dir_image AS dir_image_13,
  t0.date_creation AS date_creation_14,
  t0.services_lateraux AS services_lateraux_15,
  t0.commune_id AS commune_id_16,
  t0.gestionnaire_id AS gestionnaire_id_17
FROM
  ville t0
ORDER BY
  t0.nom ASC
LIMIT
  200

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.titre_accroche AS titre_accroche_4, t0.description AS description_5, t0.menu_links AS menu_links_6, t0.horaire_mairie AS horaire_mairie_7, t0.liens_demarches AS liens_demarches_8, t0.liens_agenda AS liens_agenda_9, t0.background_image AS background_image_10, t0.dir_bg AS dir_bg_11, t0.image AS image_12, t0.dir_image AS dir_image_13, t0.date_creation AS date_creation_14, t0.services_lateraux AS services_lateraux_15, t0.commune_id AS commune_id_16, t0.gestionnaire_id AS gestionnaire_id_17 FROM ville t0 ORDER BY t0.nom ASC LIMIT 200;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.nom AS nom_3,
  t0.cp AS cp_4,
  t0.date_creation AS date_creation_5,
  t0.date_update AS date_update_6,
  t0.pays_id AS pays_id_7,
  t0.region_id AS region_id_8
FROM
  departement t0
WHERE
  t0.pays_id = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nom AS nom_3, t0.cp AS cp_4, t0.date_creation AS date_creation_5, t0.date_update AS date_update_6, t0.pays_id AS pays_id_7, t0.region_id AS region_id_8 FROM departement t0 WHERE t0.pays_id = 75 ORDER BY t0.nom ASC;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.alpha2 AS alpha2_2,
  p0_.alpha3 AS alpha3_3,
  p0_.nom_en_gb AS nom_en_gb_4,
  p0_.nom_fr_fr AS nom_fr_fr_5,
  p0_.tva AS tva_6
FROM
  pays p0_
WHERE
  p0_.tva IS NOT NULL
  AND p0_.tva <> ?
ORDER BY
  p0_.nom_fr_fr ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.alpha2 AS alpha2_2, p0_.alpha3 AS alpha3_3, p0_.nom_en_gb AS nom_en_gb_4, p0_.nom_fr_fr AS nom_fr_fr_5, p0_.tva AS tva_6 FROM pays p0_ WHERE p0_.tva IS NOT NULL AND p0_.tva <> '' ORDER BY p0_.nom_fr_fr ASC;

SELECT
  t0.id AS id_1,
  t0.display_position AS display_position_2,
  t0.titre AS titre_3,
  t0.link AS link_4,
  t0.status AS status_5,
  t0.date_creation AS date_creation_6,
  t0.date_update AS date_update_7,
  t0.titre_fr AS titre_fr_8,
  t0.titre_en AS titre_en_9,
  t0.titre_de AS titre_de_10,
  t0.titre_be AS titre_be_11
FROM
  menu_links t0
WHERE
  t0.display_position = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.display_position AS display_position_2, t0.titre AS titre_3, t0.link AS link_4, t0.status AS status_5, t0.date_creation AS date_creation_6, t0.date_update AS date_update_7, t0.titre_fr AS titre_fr_8, t0.titre_en AS titre_en_9, t0.titre_de AS titre_de_10, t0.titre_be AS titre_be_11 FROM menu_links t0 WHERE t0.display_position = 'footer_centre' AND t0.status = 'Actif';

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.date_creation AS date_creation_3,
  t0.date_update AS date_update_4,
  t0.display_position AS display_position_5,
  t0.langue_id AS langue_id_6
FROM
  mentions_legales t0
WHERE
  t0.langue_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM mentions_legales t0 WHERE t0.langue_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.pays AS pays_2,
  t0.code AS code_3,
  t0.langue AS langue_4,
  t0.encodage AS encodage_5,
  t0.img AS img_6,
  t0.dir AS dir_7,
  t0.date_creation AS date_creation_8
FROM
  langue t0

SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.icon AS icon_3,
  t0.dir AS dir_4,
  t0.link AS link_5,
  t0.status AS status_6,
  t0.display_position AS display_position_7,
  t0.date_creation AS date_creation_8,
  t0.date_update AS date_update_9
FROM
  social_links t0
WHERE
  t0.link IS NULL

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.link IS NULL;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.alpha2 AS alpha2_3,
  t0.alpha3 AS alpha3_4,
  t0.nom_en_gb AS nom_en_gb_5,
  t0.nom_fr_fr AS nom_fr_fr_6,
  t0.tva AS tva_7
FROM
  pays t0
WHERE
  t0.alpha2 = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6, t0.tva AS tva_7 FROM pays t0 WHERE t0.alpha2 = 'FR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.taille AS taille_2,
  t0.date_creation AS date_creation_3,
  t0.date_update AS date_update_4
FROM
  taille_entreprise t0

SELECT t0.id AS id_1, t0.taille AS taille_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4 FROM taille_entreprise t0;

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.date_creation AS date_creation_3,
  t0.date_update AS date_update_4,
  t0.display_position AS display_position_5,
  t0.langue_id AS langue_id_6
FROM
  cgi t0
WHERE
  t0.langue_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM cgi t0 WHERE t0.langue_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.icon AS icon_3,
  t0.dir AS dir_4,
  t0.link AS link_5,
  t0.status AS status_6,
  t0.display_position AS display_position_7,
  t0.date_creation AS date_creation_8,
  t0.date_update AS date_update_9
FROM
  social_links t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.status = 'Actif';

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.date_creation AS date_creation_3,
  t0.date_update AS date_update_4,
  t0.display_position AS display_position_5,
  t0.langue_id AS langue_id_6
FROM
  condition_generale t0
WHERE
  t0.langue_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM condition_generale t0 WHERE t0.langue_id = 1 LIMIT 1;