https://mlc.digitz.dev/fr/recherche

302 Redirect from
@render_mlc_reservation (672a72)
Forwarded to
ExceptionController :: showAction (545f7e)
Method
GET
HTTP Status
500
IP
66.249.66.13
Profiled on
Token
22d5db

Query Metrics

27 Database Queries
7 Different statements
15.08 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.17 ms 
SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = ? AND c1_.id = ? LIMIT 1
Parameters: 
[
  "index.html.twig"
  2
]
View formatted query    View runnable query    Explain query
2 1.46 ms 
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_translation c0_ WHERE c0_.locale = ? AND c0_.object_id = ?
Parameters: 
[
  "fr"
  3
]
View formatted query    View runnable query    Explain query
3 0.40 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "seo_slug"
  "en"
]
View formatted query    View runnable query    Explain query
4 0.25 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "header_titre"
  "en"
]
View formatted query    View runnable query    Explain query
5 0.68 ms 
SELECT c0_.id AS id_0, c0_.first_menu AS first_menu_1, c0_.second_menu AS second_menu_2, c0_.date AS date_3, c0_.lang AS lang_4, c0_.type AS type_5 FROM cache_menu c0_ WHERE c0_.lang = ? AND c0_.type = ? ORDER BY c0_.date DESC
Parameters: 
[
  "fr"
  "hotel"
]
View formatted query    View runnable query    Explain query
6 0.07 ms 
SELECT c0_.id AS id_0, c0_.first_menu AS first_menu_1, c0_.second_menu AS second_menu_2, c0_.date AS date_3, c0_.lang AS lang_4, c0_.type AS type_5 FROM cache_menu c0_ WHERE c0_.lang = ? AND c0_.type = ? ORDER BY c0_.date DESC
Parameters: 
[
  "fr"
  "hotel"
]
View formatted query    View runnable query    Explain query
7 1.10 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.facebook AS facebook_3, t0.instagram AS instagram_4, t0.linkedin AS linkedin_5 FROM social_media t0 WHERE t0.type = ? LIMIT 1
Parameters: 
[
  "hotel"
]
View formatted query    View runnable query    Explain query
8 1.03 ms 
SELECT s0_.content AS content_0, s0_.field AS field_1 FROM social_media_translation s0_ WHERE s0_.locale = ? AND s0_.object_id = ?
Parameters: 
[
  "fr"
  1
]
View formatted query    View runnable query    Explain query
9 0.21 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "facebook"
  "fr"
]
View formatted query    View runnable query    Explain query
10 3.45 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "facebook"
  "fr"
]
View formatted query    View runnable query    Explain query
11 0.29 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "instagram"
  "fr"
]
View formatted query    View runnable query    Explain query
12 0.11 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "instagram"
  "fr"
]
View formatted query    View runnable query    Explain query
13 0.25 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "linkedin"
  "fr"
]
View formatted query    View runnable query    Explain query
14 0.08 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "linkedin"
  "fr"
]
View formatted query    View runnable query    Explain query
15 0.13 ms 
SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = ? AND c1_.id = ? LIMIT 1
Parameters: 
[
  "index.html.twig"
  2
]
View formatted query    View runnable query    Explain query
16 0.56 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "seo_slug"
  "fr"
]
View formatted query    View runnable query    Explain query
17 0.23 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "header_titre"
  "fr"
]
View formatted query    View runnable query    Explain query
18 0.07 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.facebook AS facebook_3, t0.instagram AS instagram_4, t0.linkedin AS linkedin_5 FROM social_media t0 WHERE t0.type = ? LIMIT 1
Parameters: 
[
  "hotel"
]
View formatted query    View runnable query    Explain query
19 0.06 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "facebook"
  "fr"
]
View formatted query    View runnable query    Explain query
20 0.05 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "facebook"
  "fr"
]
View formatted query    View runnable query    Explain query
21 0.07 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "instagram"
  "fr"
]
View formatted query    View runnable query    Explain query
22 0.05 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "instagram"
  "fr"
]
View formatted query    View runnable query    Explain query
23 0.05 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "linkedin"
  "fr"
]
View formatted query    View runnable query    Explain query
24 0.05 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM social_media_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  1
  "linkedin"
  "fr"
]
View formatted query    View runnable query    Explain query
25 0.09 ms 
SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = ? AND c1_.id = ? LIMIT 1
Parameters: 
[
  "index.html.twig"
  2
]
View formatted query    View runnable query    Explain query
26 0.06 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "seo_slug"
  "fr"
]
View formatted query    View runnable query    Explain query
27 0.06 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = ? AND t0.field = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "header_titre"
  "fr"
]
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\CmsComposant No errors.
App\Entity\CmsPageBlockComposant No errors.
App\Entity\CmsPageBlockComposantItems No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
App\Entity\CmsPageBlockComposantTrans\Translation No errors.
App\Entity\CmsPageBlockComposantItemsTrans\Translation No errors.
App\Entity\SubItemTrans\Translation No errors.
App\Entity\ProduitThalassos\Translation No errors.
App\Entity\Chambre\Translation No errors.
App\Entity\CategorieThalassos\Translation No errors.
App\Entity\ProduitThalassoPhotos No errors.
App\Entity\CmsPageTrans\Translation No errors.
App\Entity\CmsPage No errors.
App\Entity\ChampsTrans\Translation No errors.
App\Entity\ValeurChampsTrans\Translation No errors.
App\Entity\Formulaire No errors.
App\Entity\FormulaireList No errors.
App\Entity\Champs No errors.
App\Entity\MenuItemTrans\Translation No errors.
App\Entity\SocialMediaTrans\Translation No errors.
App\Entity\BrochureItemsTrans\Translation No errors.
App\Entity\Sitemap No errors.
App\Entity\PopIn\Translation No errors.
App\Entity\ProgrammeTrans\Translation No errors.
App\Entity\Tags\Translation No errors.
App\Entity\TypeLit\Translation No errors.
App\Entity\Regime\Translation No errors.
App\Entity\Supplement\Translation No errors.
App\Entity\ValeurChamps No errors.
App\Entity\CmsTemplate No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Entity\ProduitThalasso No errors.
App\Entity\Chambre No errors.
App\Entity\SubItem No errors.
App\Entity\CmsComposantTrans\Translation No errors.
App\Entity\CmsTemplateConfig No errors.
App\Entity\Picto No errors.
App\Entity\CmsComposantSlide No errors.
App\Entity\Slide No errors.
App\Entity\CategorieThalasso No errors.
App\Entity\ProduitThalassoPhotosTrans\Translation No errors.
App\Entity\FormulaireTrans\Translation No errors.
App\Entity\MenuItem No errors.
App\Entity\SocialMedia No errors.
App\Entity\BrochureItems No errors.
App\Entity\PopIn No errors.
App\Entity\Programme No errors.
App\Entity\Tag No errors.
App\Entity\TypeLit No errors.
App\Entity\Regime No errors.
App\Entity\Supplement No errors.
App\Entity\CmsTemplateTrans\Translation No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia No errors.
App\Application\Sonata\MediaBundle\Entity\GalleryHasMedia No errors.
App\Entity\MaxstayProduit No errors.
App\Entity\DispoProduit No errors.
App\Entity\MinstayProduit No errors.
App\Entity\JourSemaine No errors.
App\Entity\NiveauPrix No errors.
App\Entity\TarifProduitThalasso No errors.
App\Entity\Promotion No errors.
App\Entity\Fermeture No errors.
App\Entity\CodePromo No errors.
App\Entity\ReservationCure No errors.
App\Entity\ReservationSoins No errors.
App\Entity\Arrangement No errors.
App\Entity\TarifProduitThalassoChambre No errors.
App\Entity\ReglesArrangement No errors.
App\Entity\TypeChambre No errors.
App\Entity\ChambrePhotos No errors.
App\Entity\DispoChambre No errors.
App\Entity\MinstayChambre No errors.
App\Entity\MaxstayChambre No errors.
App\Entity\TarifAccompagnant No errors.
App\Entity\TarifChambre No errors.
App\Entity\ReservationChambre No errors.
App\Entity\ChambreComposition No errors.
App\Entity\CacheMenu No errors.
App\Entity\PictoTrans\Translation No errors.
App\Entity\MenuSubItem No errors.
App\Entity\CmsComposantSlideTrans\Translation No errors.
App\Entity\SlideTrans\Translation No errors.
App\Entity\Menu No errors.
App\Entity\Brochure No errors.
App\Entity\CategorieTag No errors.
App\Entity\Prix No errors.
App\Entity\SupplementPhotos No errors.
App\Entity\TypeFacturation No errors.
App\Entity\TarifSupplement No errors.
App\Entity\ReservationSupplement No errors.
App\Entity\DispoSupplement No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Application\Sonata\MediaBundle\Entity\Gallery No errors.
App\Entity\JourSemaine\Translation No errors.
App\Entity\TypeBar No errors.
App\Entity\TypePromotion No errors.
App\Entity\TypeApplication No errors.
App\Entity\PromotionValidite No errors.
App\Entity\TypeSurclassement No errors.
App\Entity\PromotionAffichage No errors.
App\Entity\PromotionMtdepense No errors.
App\Entity\Application No errors.
App\Entity\PromotionPhotos No errors.
App\Entity\Promotion\Translation No errors.
App\Entity\TypePrestation No errors.
App\Entity\CodePromo\Translation No errors.
App\Entity\Client No errors.
App\Entity\EarlyBooking No errors.
App\Entity\CodePromoValidite No errors.
App\Entity\CodePromoAffichage No errors.
App\Entity\ReservationCure\Translation No errors.
App\Entity\Curiste No errors.
App\Entity\Reservation No errors.
App\Entity\ReservationSoins\Translation No errors.
App\Entity\TypeArrangement No errors.
App\Entity\TarifArrangement No errors.
App\Entity\TypeChambre\Translation No errors.
App\Entity\ChambrePhotosTrans\Translation No errors.
App\Entity\ReservationChambre\Translation No errors.