http://preprod.ateya-vacances.fr/fr/produit/le-domaine-des-dunes/www.mimizan-tourisme.com

Query Metrics

16 Database Queries
9 Different statements
5.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.14 ms
(20.30%)
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:
[]
1.07 ms
(18.93%)
4
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.76 ms
(13.52%)
2
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
0.67 ms
(11.96%)
4
SELECT DATABASE()
Parameters:
[]
0.63 ms
(11.13%)
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.62 ms
(11.02%)
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.38 ms
(6.74%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1
Parameters:
[
  "www.mimizan-tourisme.com"
]
0.23 ms
(4.03%)
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.13 ms
(2.36%)
1
SELECT * FROM migration_versions
Parameters:
[]

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\Language No errors.
App\Entity\media No errors.
App\Entity\Residence No errors.
App\Entity\depot No errors.
App\Entity\fiche No errors.
App\Entity\InfosFormuleBase No errors.
App\Entity\Package No errors.
App\Entity\mediaResidence No errors.
App\Entity\InfosResidence No errors.
App\Entity\InfosEvent No errors.
App\Entity\InfosDiscover No errors.
App\Entity\InfosDiscoverLink No errors.
App\Entity\Typologie No errors.
App\Entity\offre No errors.
App\Entity\OptionResidence No errors.
App\Entity\TypologieMedia No errors.
App\Entity\typeoffre No errors.
App\Entity\dateoffre No errors.
App\Entity\CatalogOrder No errors.
App\Entity\echeancier No errors.
App\Entity\Service No errors.
App\Entity\Theme No errors.
App\Entity\Page No errors.
App\Entity\slider No errors.
App\Entity\Catalog No errors.
App\Entity\Transaction No errors.
App\Entity\nomfiche No errors.
App\Entity\Promo 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\User No errors.
App\Entity\pays No errors.
App\Entity\commande No errors.
App\Entity\blog No errors.
App\Entity\InscritNewsletter No errors.
App\Entity\assurance No errors.
Vich\UploaderBundle\Entity\File No errors.