http://preprod.ateya-vacances.fr/fr/produit/le-claux-du-puits-by-ateya/37?datearrivee=2024-10-03&duree=3

Forwarded to
ErrorController (24d787)
Method
GET
HTTP Status
500
IP
124.243.178.3
Profiled on
Token
5a72c6

Query Metrics

29 Database Queries
17 Different statements
6.02 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.52 ms 
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"
]
View formatted query    View runnable query    Explain query
2 0.15 ms 
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"
]
View formatted query    View runnable query    Explain query
3 0.12 ms 
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"
]
View formatted query    View runnable query    Explain query
4 0.10 ms 
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"
]
View formatted query    View runnable query    Explain query
5 0.13 ms 
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: 
[
  "37"
]
View formatted query    View runnable query    Explain query
6 0.15 ms 
SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
7 0.12 ms 
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ?
Parameters: 
[
  1
  32
  1
]
View formatted query    View runnable query    Explain query
8 0.11 ms 
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ?
Parameters: 
[
  1
  32
  1
]
View formatted query    View runnable query    Explain query
9 0.11 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
10 0.14 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ?
Parameters: 
[
  1
  32
  1
]
View formatted query    View runnable query    Explain query
11 0.12 ms 
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.text AS text_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
12 0.12 ms 
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.anchor AS anchor_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover_link t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
13 0.11 ms 
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
14 0.10 ms 
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
Parameters: 
[
  1
  32
]
View formatted query    View runnable query    Explain query
15 0.12 ms 
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND m0_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
Parameters: 
[
  32
  "header"
  1
  "SEASON_2"
  1
]
View formatted query    View runnable query    Explain query
16 0.12 ms 
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND m0_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
Parameters: 
[
  32
  "content"
  1
  "SEASON_2"
  1
]
View formatted query    View runnable query    Explain query
17 0.11 ms 
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND m0_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
Parameters: 
[
  32
  "header"
  1
  "SEASON_2"
  1
]
View formatted query    View runnable query    Explain query
18 0.16 ms 
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND m0_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
Parameters: 
[
  32
  "content"
  1
  "SEASON_2"
  1
]
View formatted query    View runnable query    Explain query
19 0.40 ms 
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.26 ms 
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters: 
[]
View formatted query    View runnable query    Explain query
21 0.18 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.48 ms 
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: 
[]
View formatted query    View runnable query    Explain query
23 0.15 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 0.52 ms 
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: 
[]
View formatted query    View runnable query    Explain query
25 0.15 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
26 0.23 ms 
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: 
[]
View formatted query    View runnable query    Explain query
27 0.67 ms 
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: 
[]
View formatted query    View runnable query    Explain query
28 0.12 ms 
SELECT * FROM migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 0.23 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\MediaHebergement 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\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.