Query Metrics
1299
Database Queries
23
Different statements
1289.79 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
631.69 ms (48.98%) |
559 |
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 WHERE t0.code_ape = ? LIMIT 1
Parameters:
[
"9001"
]
|
||||||||||||||||||||||||||||
|
485.16 ms (37.62%) |
559 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.pseudo AS pseudo_5, t0.code_postal AS code_postal_6, t0.competences AS competences_7, t0.password AS password_8, t0.civilite AS civilite_9, t0.code_pays_dep AS code_pays_dep_10, t0.image AS image_11, t0.dir AS dir_12, t0.date_creation AS date_creation_13, t0.date_update AS date_update_14, t0.langues AS langues_15, t0.moyens_communication AS moyens_communication_16, t0.geo AS geo_17, t0.pays_id AS pays_id_18, t0.departement_id AS departement_id_19, t0.etat_id AS etat_id_20, t0.filiale_id AS filiale_id_21, t0.entreprise_id AS entreprise_id_22, t0.user_id AS user_id_23, t0.langue_id AS langue_id_24 FROM agent t0 WHERE t0.entreprise_id = ? AND t0.etat_id = ?
Parameters:
[ 200 1 ]
|
||||||||||||||||||||||||||||
|
95.65 ms (7.42%) |
154 |
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 WHERE t0.id = ?
Parameters:
[
476
]
|
||||||||||||||||||||||||||||
|
36.66 ms (2.84%) |
1 |
SELECT a0_.level1_nr AS level1_nr_0, a0_.level1_fr AS level1_fr_1, a0_.level1_en AS level1_en_2, a0_.level1_de AS level1_de_3, a0_.obra_key AS obra_key_4, a0_.level2_nr AS level2_nr_5, a0_.level2_fr AS level2_fr_6, a0_.level2_en AS level2_en_7, a0_.level2_de AS level2_de_8, a0_.ubra_key AS ubra_key_9, a0_.code_ape AS code_ape_10 FROM ape2 a0_ ORDER BY a0_.level1_nr ASC, a0_.level2_nr ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
7.29 ms (0.57%) |
2 |
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 = ?
Parameters:
[ "footer_centre" "Actif" ]
|
||||||||||||||||||||||||||||
|
6.88 ms (0.53%) |
1 |
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.siren AS siren_3, t0.ape AS ape_4, t0.taille AS taille_5, t0.nom_entreprise AS nom_entreprise_6, t0.dir AS dir_7, t0.image AS image_8, t0.description AS description_9, t0.date_creation_compte AS date_creation_compte_10, t0.date_update AS date_update_11, t0.code_postal AS code_postal_12, t0.num_voie AS num_voie_13, t0.type_voie AS type_voie_14, t0.nom_voie AS nom_voie_15, t0.ville AS ville_16, t0.accord_consultation AS accord_consultation_17, t0.document_apres AS document_apres_18, t0.code_pays_dep AS code_pays_dep_19, t0.prix_formule_ttc AS prix_formule_ttc_20, t0.prix_formule_ht AS prix_formule_ht_21, t0.tva_formule AS tva_formule_22, t0.telephone AS telephone_23, t0.date_creation_entreprise AS date_creation_entreprise_24, t0.portable AS portable_25, t0.site AS site_26, t0.services AS services_27, t0.moyens_communication AS moyens_communication_28, t0.social_links AS social_links_29, t0.email AS email_30, t0.dernier_update_departement AS dernier_update_departement_31, t0.agent_require_email AS agent_require_email_32, t0.agent_unique_email AS agent_unique_email_33, t0.search_agent_limit_to_top AS search_agent_limit_to_top_34, t0.langues AS langues_35, t0.geo AS geo_36, t0.url_events AS url_events_37, t0.description_events AS description_events_38, t0.route_url AS route_url_39, t0.dep_exclu AS dep_exclu_40, t0.numero_tva AS numero_tva_41, t0.type_activite AS type_activite_42, t0.adresse2 AS adresse2_43, t0.forme_juridique AS forme_juridique_44, t0.type_activite_de AS type_activite_de_45, t0.type_activite_en AS type_activite_en_46, t0.code_abreviation AS code_abreviation_47, t0.num_unique AS num_unique_48, t0.departement_id AS departement_id_49, t0.etat_id AS etat_id_50, t0.niveau_id AS niveau_id_51, t0.gestionnaire_entreprise_id AS gestionnaire_entreprise_id_52, t0.pays_id AS pays_id_53, t0.formule_id AS formule_id_54, t0.entreprise_racine_id AS entreprise_racine_id_55, t0.entreprise_parent_id AS entreprise_parent_id_56, t0.type_compte_id AS type_compte_id_57, t0.communes_id AS communes_id_58, t0.ref_ape_id AS ref_ape_id_59, t0.region_id AS region_id_60 FROM entreprise t0 WHERE t0.code_postal = ? AND t0.etat_id = ?
Parameters:
[ "78120" 1 ]
|
||||||||||||||||||||||||||||
|
3.99 ms (0.31%) |
1 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.date_debut AS date_debut_3, p0_.date_fin AS date_fin_4, p0_.date_creation AS date_creation_5, p0_.date_update AS date_update_6, p0_.mots_cles AS mots_cles_7, p0_.date_validation AS date_validation_8, p0_.url AS url_9, p0_.cout_total AS cout_total_10, p0_.duree AS duree_11, p0_.meta_description AS meta_description_12, p0_.cp AS cp_13, p0_.services AS services_14, p0_.entreprise_id AS entreprise_id_15, p0_.etat_id AS etat_id_16, p0_.cout_journalier_id AS cout_journalier_id_17, p0_.proprietaire_id AS proprietaire_id_18, p0_.filiale_id AS filiale_id_19, p0_.departement_id AS departement_id_20 FROM publicite p0_ WHERE p0_.etat_id = ? ORDER BY RAND() ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
3.53 ms (0.27%) |
4 |
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
Parameters:
[
"FR"
]
|
||||||||||||||||||||||||||||
|
2.70 ms (0.21%) |
4 |
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
Parameters:
[ "annuaire-entreprise" 1 ]
|
||||||||||||||||||||||||||||
|
2.21 ms (0.17%) |
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 = ? LIMIT 1
Parameters:
[
"fr"
]
|
||||||||||||||||||||||||||||
|
2.12 ms (0.16%) |
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 = ?
Parameters:
[
"Actif"
]
|
||||||||||||||||||||||||||||
|
1.79 ms (0.14%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.45 ms (0.11%) |
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 = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.35 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.nom AS nom_3, t0.type AS type_4, t0.competences AS competences_5, t0.dir AS dir_6, t0.image AS image_7, t0.description AS description_8, t0.date_creation AS date_creation_9, t0.date_update AS date_update_10, t0.code_postal AS code_postal_11, t0.num_voie AS num_voie_12, t0.type_voie AS type_voie_13, t0.nom_voie AS nom_voie_14, t0.ville AS ville_15, t0.code_pays_dep AS code_pays_dep_16, t0.prix_formule_ttc AS prix_formule_ttc_17, t0.prix_formule_ht AS prix_formule_ht_18, t0.tva_formule AS tva_formule_19, t0.date_creation_filiale AS date_creation_filiale_20, t0.portable AS portable_21, t0.telephone AS telephone_22, t0.site AS site_23, t0.services AS services_24, t0.moyens_communication AS moyens_communication_25, t0.use_parent_manager AS use_parent_manager_26, t0.social_links AS social_links_27, t0.email AS email_28, t0.dernier_update_departement AS dernier_update_departement_29, t0.langues AS langues_30, t0.geo AS geo_31, t0.url_events AS url_events_32, t0.description_events AS description_events_33, t0.route_url AS route_url_34, t0.dep_exclu AS dep_exclu_35, t0.num_unique AS num_unique_36, t0.gestionnaire_id AS gestionnaire_id_37, t0.filiale_parent_id AS filiale_parent_id_38, t0.niveau_id AS niveau_id_39, t0.entreprise_id AS entreprise_id_40, t0.pays_id AS pays_id_41, t0.departement_id AS departement_id_42, t0.formule_id AS formule_id_43, t0.modified_by_id AS modified_by_id_44, t0.etat_id AS etat_id_45, t0.region_id AS region_id_46 FROM filiale t0 WHERE t0.code_postal = ? AND t0.etat_id = ?
Parameters:
[ "78120" 1 ]
|
||||||||||||||||||||||||||||
|
1.21 ms (0.09%) |
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 = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.04 ms (0.08%) |
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 = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.00 ms (0.08%) |
1 |
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 = ?
Parameters:
[
75
]
|
||||||||||||||||||||||||||||
|
0.86 ms (0.07%) |
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.link IS NULL
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.77 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.pays AS pays_4, t0.population_total AS population_total_5, t0.nom_url AS nom_url_6 FROM communes t0 WHERE t0.code_postal = ? AND t0.nom_url = ? LIMIT 1
Parameters:
[ "78120" "rambouillet" ]
|
||||||||||||||||||||||||||||
|
0.71 ms (0.05%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.67 ms (0.05%) |
1 |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.status AS status_4, t0.dir AS dir_5, t0.date_creation AS date_creation_6, t0.date_update AS date_update_7, t0.type AS type_8 FROM comm_media t0 WHERE t0.status = ?
Parameters:
[
"Actif"
]
|
||||||||||||||||||||||||||||
|
0.55 ms (0.04%) |
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 WHERE t0.commune_id = ? LIMIT 1
Parameters:
[
31084
]
|
||||||||||||||||||||||||||||
|
0.50 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.pays AS pays_4, t0.population_total AS population_total_5, t0.nom_url AS nom_url_6 FROM communes t0 WHERE t0.code_postal = ?
Parameters:
[
"78120"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Entreprise | No errors. |
| App\Entity\Filiale |
|
| App\Entity\Langue |
|
| App\Entity\Ape2 | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Communes | No errors. |
| App\Entity\Ville | No errors. |
| App\Entity\GestionnaireVille | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Etat | No errors. |
| App\Entity\Niveau | No errors. |
| App\Entity\GestionnaireEntreprise | No errors. |
| App\Entity\Formules | No errors. |
| App\Entity\TypeCompte | No errors. |
| App\Entity\Ape | No errors. |
| App\Entity\Region |
|
| App\Entity\GestionnaireFiliale | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Traduction | No errors. |
| App\Entity\Competences | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\CommMedia | No errors. |
| App\Entity\Publicite | No errors. |
| App\Entity\CoutJournalier | No errors. |
| App\Entity\MenuLinks | No errors. |
| App\Entity\SocialLinks | No errors. |
| App\Entity\ConditionGenerale | No errors. |
| App\Entity\Cgi | No errors. |
| App\Entity\MentionsLegales | No errors. |