Query Metrics
72
Database Queries
11
Different statements
24.65 ms
Query time
4
Invalid entities
860
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
15.44 ms (62.61%) |
61 |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.sync_exposant AS sync_exposant_3, t0.sync_conf AS sync_conf_4, t0.active AS active_5, t0.date AS date_6, t0.version AS version_7, t0.delta_img AS delta_img_8, t0.step AS step_9, t0.steplock AS steplock_10, t0.message AS message_11, t0.light AS light_12, t0.delta_sqlite_filename AS delta_sqlite_filename_13 FROM sync t0 WHERE t0.id = ? AND t0.active = ? LIMIT 1
Parameters:
[ 62 1 ] |
|
3.39 ms (13.74%) |
2 |
SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.vch_name AS vch_name_3, t0.vch_name_en AS vch_name_en_4, t0.vch_pays AS vch_pays_5, t0.vch_id_societe AS vch_id_societe_6, t0.vch_constructeur AS vch_constructeur_7, t0.vch_id_materiel_type AS vch_id_materiel_type_8, t0.vch_id_materiel_usage AS vch_id_materiel_usage_9, t0.vch_desc AS vch_desc_10, t0.vch_desc_en AS vch_desc_en_11, t0.vch_caracteristiques AS vch_caracteristiques_12, t0.vch_caracteristiques_en AS vch_caracteristiques_en_13, t0.vch_photo AS vch_photo_14, t0.vch_photo_url AS vch_photo_url_15, t0.vch_innovation AS vch_innovation_16, t0.visibility AS visibility_17, t0.vch_launch_year AS vch_launch_year_18, t0.qr_code AS qr_code_19, t0.total_votes AS total_votes_20, t0.identifiant_exhibitor AS identifiant_exhibitor_21, t0.type AS type_22 FROM produit t0
Parameters:
[] |
|
1.88 ms (7.62%) |
1 |
SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.idExt AS idExt_3, t0.vch_name AS vch_name_4, t0.vch_new AS vch_new_5, t0.vch_novelty AS vch_novelty_6, t0.vch_desc AS vch_desc_7, t0.vch_desc_EN AS vch_desc_EN_8, t0.vch_countryName AS vch_countryName_9, t0.vch_twitter AS vch_twitter_10, t0.dt_start AS dt_start_11, t0.dt_end AS dt_end_12, t0.dt_modif AS dt_modif_13, t0.b_active AS b_active_14, t0.hidden AS hidden_15, t0.vch_zone AS vch_zone_16, t0.vch_startup AS vch_startup_17, t0.vch_adresse AS vch_adresse_18, t0.vch_cp AS vch_cp_19, t0.vch_ville AS vch_ville_20, t0.vch_email AS vch_email_21, t0.vch_adresse2 AS vch_adresse2_22, t0.vch_tel AS vch_tel_23, t0.vch_fax AS vch_fax_24, t0.vch_web AS vch_web_25, t0.vch_nomcontact AS vch_nomcontact_26, t0.vch_prenomcontact AS vch_prenomcontact_27, t0.vch_telcontact AS vch_telcontact_28, t0.vch_faxcontact AS vch_faxcontact_29, t0.vch_emailcontact AS vch_emailcontact_30, t0.vch_functioncontact AS vch_functioncontact_31, t0.vch_facebook AS vch_facebook_32, t0.vch_linkedin AS vch_linkedin_33, t0.logo AS logo_34, t0.hostedById AS hostedById_35, t0.startupStand AS startupStand_36, t0.presence AS presence_37, t0.qrCode AS qrCode_38, t0.logoUrl AS logoUrl_39, t0.vch_stand AS vch_stand_40, t0.vch_stand_libelle AS vch_stand_libelle_41, t0.identifiant AS identifiant_42, t0.vch_option_gold AS vch_option_gold_43, t0.vch_option_feature AS vch_option_feature_44, t0.vch_reason_sociale AS vch_reason_sociale_45, t0.vch_short_description AS vch_short_description_46, t0.vch_short_description_en AS vch_short_description_en_47, t0.standOwner AS standOwner_48, t0.sponsor AS sponsor_49, t0.sponsor_order AS sponsor_order_50, t0.badge_rank AS badge_rank_51 FROM exposant t0
Parameters:
[] |
|
0.82 ms (3.34%) |
1 |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.sync_exposant AS sync_exposant_3, t0.sync_conf AS sync_conf_4, t0.active AS active_5, t0.date AS date_6, t0.version AS version_7, t0.delta_img AS delta_img_8, t0.step AS step_9, t0.steplock AS steplock_10, t0.message AS message_11, t0.light AS light_12, t0.delta_sqlite_filename AS delta_sqlite_filename_13 FROM sync t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
1
]
|
|
0.68 ms (2.77%) |
1 |
SELECT t0.id AS id_1, t0.vch_status AS vch_status_2, t0.vch_societe AS vch_societe_3, t0.vch_code_intervention AS vch_code_intervention_4, t0.date AS date_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.vch_titre AS vch_titre_8, t0.vch_titre_gb AS vch_titre_gb_9, t0.vch_mission AS vch_mission_10, t0.vch_description AS vch_description_11, t0.vch_description_gb AS vch_description_gb_12, t0.vch_logo AS vch_logo_13, t0.vch_access AS vch_access_14, t0.vch_public AS vch_public_15, t0.vch_static AS vch_static_16, t0.vch_exhibitor AS vch_exhibitor_17, t0.i_type AS i_type_18, t0.identifiant AS identifiant_19, t0.imageUrl AS imageUrl_20, t0.qr_code AS qr_code_21, t0.vch_picture_fullscreen AS vch_picture_fullscreen_22, t0.css_class_name AS css_class_name_23, t0.type AS type_24, t0.id_conferencetype_id AS id_conferencetype_id_25, t0.id_salle_id AS id_salle_id_26 FROM conference t0
Parameters:
[] |
|
0.54 ms (2.21%) |
1 |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.service_id AS service_id_3, t0.object_type AS object_type_4, t0.entity_ID AS entity_ID_5, t0.patrimony AS patrimony_6, t0.type AS type_7, t0.type_name AS type_name_8, t0.label AS label_9, t0.sub_label AS sub_label_10, t0.claimer AS claimer_11, t0.description AS description_12, t0.img AS img_13, t0.img_name AS img_name_14, t0.layout_template AS layout_template_15, t0.layout_img AS layout_img_16, t0.layout_img_name AS layout_img_name_17, t0.layout_call_to_action AS layout_call_to_action_18, t0.event_start_date AS event_start_date_19, t0.event_end_date AS event_end_date_20, t0.publication_start_date AS publication_start_date_21, t0.publication_end_date AS publication_end_date_22, t0.publication_date AS publication_date_23, t0.date_creation AS date_creation_24, t0.template AS template_25, t0.provider AS provider_26, t0.enabled AS enabled_27 FROM service_alyse t0
Parameters:
[] |
|
0.50 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stand_name AS stand_name_3, t0.map_name AS map_name_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.hall_name AS hall_name_8, t0.ordre AS ordre_9, t0.type AS type_10, t0.stand_id AS stand_id_11 FROM map_legende t0
Parameters:
[] |
|
0.47 ms (1.92%) |
1 |
SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.vch_name AS vch_name_3, t0.vch_name_en AS vch_name_en_4, t0.vch_pays AS vch_pays_5, t0.vch_id_societe AS vch_id_societe_6, t0.vch_constructeur AS vch_constructeur_7, t0.vch_id_materiel_type AS vch_id_materiel_type_8, t0.vch_id_materiel_usage AS vch_id_materiel_usage_9, t0.vch_desc AS vch_desc_10, t0.vch_desc_en AS vch_desc_en_11, t0.vch_caracteristiques AS vch_caracteristiques_12, t0.vch_caracteristiques_en AS vch_caracteristiques_en_13, t0.vch_photo AS vch_photo_14, t0.vch_photo_plan AS vch_photo_plan_15, t0.vch_photo_plan_en AS vch_photo_plan_en_16, t0.vch_photo_url AS vch_photo_url_17, t0.vch_photo_en AS vch_photo_en_18, t0.vch_photo_url_en AS vch_photo_url_en_19, t0.vch_photo_2 AS vch_photo_2_20, t0.vch_photo_url_2 AS vch_photo_url_2_21, t0.vch_photo_2_en AS vch_photo_2_en_22, t0.vch_photo_url_2_en AS vch_photo_url_2_en_23, t0.vch_photo_plan_url AS vch_photo_plan_url_24, t0.vch_photo_plan_url_en AS vch_photo_plan_url_en_25, t0.vch_innovation AS vch_innovation_26, t0.visibility AS visibility_27, t0.vch_launch_year AS vch_launch_year_28, t0.qr_code AS qr_code_29, t0.identifiant_exhibitor AS identifiant_exhibitor_30, t0.type AS type_31 FROM entity t0
Parameters:
[] |
|
0.34 ms (1.40%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.groupe AS groupe_5, t0.file AS file_6, t0.url AS url_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.ontop AS ontop_10, t0.product_id AS product_id_11, t0.job_id AS job_id_12 FROM media t0
Parameters:
[] |
|
0.32 ms (1.31%) |
1 |
SELECT t0.id AS id_1, t0.i_civilite AS i_civilite_2, t0.vch_nom AS vch_nom_3, t0.vch_prenom AS vch_prenom_4, t0.vch_nickname AS vch_nickname_5, t0.vch_fonction AS vch_fonction_6, t0.vch_linkedin AS vch_linkedin_7, t0.vch_tel AS vch_tel_8, t0.vch_photo AS vch_photo_9, t0.vch_client AS vch_client_10, t0.vch_email AS vch_email_11, t0.vch_logo AS vch_logo_12, t0.txt_biography AS txt_biography_13, t0.hidden AS hidden_14, t0.identifiant AS identifiant_15, t0.type AS type_16 FROM participant t0
Parameters:
[] |
|
0.26 ms (1.04%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.type AS type_4, t0.logo AS logo_5, t0.logoUrl AS logoUrl_6, t0.identifiant AS identifiant_7 FROM partenaire t0 ORDER BY t0.titre ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| urlappsalon | doctrine.dbal.urlappsalon_connection |
| sqlite | doctrine.dbal.sqlite_connection |
Entity Managers
| Name | Service |
|---|---|
| urlappsalon | doctrine.orm.urlappsalon_entity_manager |
| default | doctrine.orm.default_entity_manager |
| sqlite | doctrine.orm.sqlite_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
urlappsalon entity manager
| Class | Amount of managed objects |
|---|
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\TMateriel | 395 |
| App\Entity\TExhibitors | 234 |
| App\Entity\TIntervenat | 61 |
| App\Entity\Sync | 59 |
| App\Entity\TAtelier | 50 |
| App\Entity\Media | 25 |
| App\Entity\MapLegende | 16 |
| App\Entity\TExhibitionStand | 16 |
| App\Entity\TSalle | 4 |
sqlite entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
urlappsalon entity manager
No loaded entities.
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Sync | No errors. |
| App\Entity\TAtelier |
|
| App\Entity\TConferencetypeT | No errors. |
| App\Entity\TSalle | No errors. |
| App\Entity\TThematique | No errors. |
| App\Entity\Topic |
|
| App\Entity\TIntervenat | No errors. |
| App\Entity\Partenaire | No errors. |
| App\Entity\AppFilter | No errors. |
| App\Entity\Badge | No errors. |
| App\Entity\TMateriel | No errors. |
| App\Entity\Entity | No errors. |
| App\Entity\TExhibitors |
|
| App\Entity\TExhibitionStand | No errors. |
| App\Entity\TActivityArea | No errors. |
| App\Entity\Job | No errors. |
| App\Entity\ZoneGeoDev | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Nomenclature | No errors. |
| App\Entity\ApportPerso | No errors. |
| App\Entity\Commentaire | No errors. |
| App\Entity\Brand |
|
| App\Entity\BadgeExposant | No errors. |
| App\Entity\MapLegende | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Vote | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\ServiceAlyse | No errors. |
sqlite entity manager
No loaded entities.