Query Metrics
29
Database Queries
19
Different statements
10.52 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.83 ms (17.39%) |
1 |
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC
Parameters:
[ 14 "2024-11-21 07:26:28" ] |
0.88 ms (8.40%) |
4 |
SELECT DATABASE()
Parameters:
[] |
0.85 ms (8.05%) |
1 |
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree < ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC
Parameters:
[ 7 "2024-11-21 07:26:28" ] |
0.80 ms (7.63%) |
2 |
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC
Parameters:
[ 7 "2024-11-22 07:26:28" "2024-12-06 07:26:28" ] |
0.75 ms (7.13%) |
1 |
SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'migration_versions'
Parameters:
[] |
0.68 ms (6.51%) |
5 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
0.67 ms (6.39%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.etat AS etat_4 FROM pays t0 WHERE t0.id = ?
Parameters:
[
79
]
|
0.64 ms (6.08%) |
2 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
0.56 ms (5.29%) |
1 |
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'migration_versions' AND k.TABLE_SCHEMA = 'ateya_preprod' /*!50116 AND c.CONSTRAINT_SCHEMA = 'ateya_preprod' */ORDER BY k.ORDINAL_POSITION
Parameters:
[] |
0.52 ms (4.90%) |
1 |
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ateya_preprod' AND TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[] |
0.51 ms (4.84%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM promo p0_ WHERE p0_.date_debut >= ?
Parameters:
[
"2024-11-22 07:26:28"
]
|
0.34 ms (3.28%) |
2 |
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ?
Parameters:
[
1
]
|
0.25 ms (2.42%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'ateya_preprod' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[] |
0.25 ms (2.37%) |
1 |
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? AND p0_.environnement = ? ORDER BY p0_.prix_total ASC
Parameters:
[ 7 "2024-11-01 00:00:00" "2025-04-30 00:00:00" "montagne" ] |
0.25 ms (2.35%) |
1 |
SELECT d0_.id AS id_0, d0_.id_iresa AS id_iresa_1, d0_.code_traduction AS code_traduction_2, d0_.titre_court AS titre_court_3, d0_.titre_long AS titre_long_4, d0_.introduction AS introduction_5, d0_.slug AS slug_6, d0_.etat AS etat_7, d0_.level AS level_8, d0_.meta_title AS meta_title_9, d0_.meta_description AS meta_description_10, d0_.seo_title AS seo_title_11, d0_.seo_content AS seo_content_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.is_translated AS is_translated_15, d0_.parent_id AS parent_id_16, d0_.lang_id AS lang_id_17 FROM destination d0_ LEFT JOIN residence r1_ ON (r1_.lieu_id = d0_.id_iresa) LEFT JOIN option_residence o2_ ON r1_.id = o2_.residence_id WHERE d0_.etat = 1 AND d0_.lang_id = ? AND (((o2_.etat = 1 AND o2_.lang_id = ?) OR (o2_.etat IS NULL AND o2_.lang_id IS NULL))) ORDER BY d0_.id ASC
Parameters:
[ 1 1 ] |
0.24 ms (2.25%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.nom AS nom_2, p0_.etat AS etat_3 FROM pays p0_ WHERE p0_.etat = 1
Parameters:
[] |
0.20 ms (1.92%) |
1 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ?
Parameters:
[ "19" 1 ] |
0.16 ms (1.53%) |
1 |
SELECT * FROM migration_versions
Parameters:
[] |
0.13 ms (1.26%) |
1 |
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_translated AS is_translated_12, t0.lang_id AS lang_id_13 FROM theme t0 WHERE t0.lang_id = ? AND t0.etat = ? ORDER BY t0.ordre ASC
Parameters:
[ 1 1 ] |
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\pays | No errors. |
App\Entity\Language | No errors. |
App\Entity\media | No errors. |
App\Entity\Page | No errors. |
App\Entity\TypologieMedia | No errors. |
App\Entity\CatalogOrder | No errors. |
App\Entity\echeancier | No errors. |
App\Entity\InfosEvent | No errors. |
App\Entity\Service | No errors. |
App\Entity\Theme | No errors. |
App\Entity\Package | No errors. |
App\Entity\dateoffre | No errors. |
App\Entity\slider | No errors. |
App\Entity\InfosDiscoverLink | No errors. |
App\Entity\Catalog | No errors. |
App\Entity\typeoffre | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\mediaResidence | No errors. |
App\Entity\fiche | No errors. |
App\Entity\nomfiche | No errors. |
App\Entity\Promo | No errors. |
App\Entity\InfosResidence | No errors. |
App\Entity\depot | No errors. |
App\Entity\Destination | No errors. |
App\Entity\miseenavant | No errors. |
App\Entity\compte | No errors. |
App\Entity\partenaire | No errors. |
App\Entity\MediaHebergement | No errors. |
App\Entity\InfosFormuleBase | No errors. |
App\Entity\Typologie | No errors. |
App\Entity\User | No errors. |
App\Entity\offre | No errors. |
App\Entity\commande | No errors. |
App\Entity\blog | No errors. |
App\Entity\Residence | No errors. |
App\Entity\InscritNewsletter | No errors. |
App\Entity\OptionResidence | No errors. |
App\Entity\assurance | No errors. |
App\Entity\InfosDiscover | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |