https://evasionishere-v0.aurone.dev/api/index.php/v1/config/application?public=true

Query Metrics

7 Database Queries
3 Different statements
6.81 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.55 ms
SELECT t0.routing AS routing_1, t0.redirect AS redirect_2, t0.codeRedirect AS codeRedirect_3, t0.id AS id_4 FROM Routing t0 WHERE t0.routing = ? LIMIT 1
Parameters:
[
  "/api/index.php/v1/config/application"
]
2 2.50 ms
SELECT DISTINCT t0_.label AS label_0, t0_.subtitle AS subtitle_1, t0_.slug AS slug_2, t0_.code AS code_3, t0_.id AS id_4, e1_.title AS title_5, e1_.subtitle AS subtitle_6, e1_.titleApidae AS titleApidae_7, e1_.idHeartStroke AS idHeartStroke_8, e1_.description AS description_9, e1_.infos AS infos_10, e1_.additionalServices AS additionalServices_11, e1_.distance AS distance_12, e1_.status AS status_13, e1_.slug AS slug_14, e1_.isHome AS isHome_15, e1_.includedInPrice AS includedInPrice_16, e1_.notIncludedInPrice AS notIncludedInPrice_17, e1_.productCode AS productCode_18, e1_.isAccessibleWithoutCar AS isAccessibleWithoutCar_19, e1_.accessibilityWithoutCarDescription AS accessibilityWithoutCarDescription_20, e1_.price AS price_21, e1_.nights AS nights_22, e1_.guests AS guests_23, e1_.dateStart AS dateStart_24, e1_.dateEnd AS dateEnd_25, e1_.hostExperienceNumber AS hostExperienceNumber_26, e1_.year AS year_27, e1_.id AS id_28, e1_.position AS position_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.meta_title AS meta_title_32, e1_.meta_description AS meta_description_33, e1_.og_title AS og_title_34, e1_.og_description AS og_description_35, t0_.visual_id AS visual_id_36, t0_.geomarker_id AS geomarker_id_37, t0_.geomarkerHover_id AS geomarkerHover_id_38, e1_.typology_id AS typology_id_39, e1_.accommodation_id AS accommodation_id_40, e1_.visualMobile_id AS visualMobile_id_41, e1_.cinemagraph_id AS cinemagraph_id_42, e1_.territory_id AS territory_id_43, e1_.season_id_id AS season_id_id_44, e1_.ogImage_id AS ogImage_id_45 FROM Typology t0_ LEFT JOIN Experience e1_ ON t0_.id = e1_.typology_id AND (e1_.typology_id = t0_.id) WHERE e1_.status = ? AND e1_.dateStart <= ? AND e1_.dateEnd >= ?
Parameters:
[
  1
  "2024-11-24"
  "2024-11-24"
]
3 0.43 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[]
4 0.38 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[]
5 2.20 ms
SELECT DISTINCT t0_.label AS label_0, t0_.subtitle AS subtitle_1, t0_.slug AS slug_2, t0_.code AS code_3, t0_.id AS id_4, e1_.title AS title_5, e1_.subtitle AS subtitle_6, e1_.titleApidae AS titleApidae_7, e1_.idHeartStroke AS idHeartStroke_8, e1_.description AS description_9, e1_.infos AS infos_10, e1_.additionalServices AS additionalServices_11, e1_.distance AS distance_12, e1_.status AS status_13, e1_.slug AS slug_14, e1_.isHome AS isHome_15, e1_.includedInPrice AS includedInPrice_16, e1_.notIncludedInPrice AS notIncludedInPrice_17, e1_.productCode AS productCode_18, e1_.isAccessibleWithoutCar AS isAccessibleWithoutCar_19, e1_.accessibilityWithoutCarDescription AS accessibilityWithoutCarDescription_20, e1_.price AS price_21, e1_.nights AS nights_22, e1_.guests AS guests_23, e1_.dateStart AS dateStart_24, e1_.dateEnd AS dateEnd_25, e1_.hostExperienceNumber AS hostExperienceNumber_26, e1_.year AS year_27, e1_.id AS id_28, e1_.position AS position_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.meta_title AS meta_title_32, e1_.meta_description AS meta_description_33, e1_.og_title AS og_title_34, e1_.og_description AS og_description_35, t0_.visual_id AS visual_id_36, t0_.geomarker_id AS geomarker_id_37, t0_.geomarkerHover_id AS geomarkerHover_id_38, e1_.typology_id AS typology_id_39, e1_.accommodation_id AS accommodation_id_40, e1_.visualMobile_id AS visualMobile_id_41, e1_.cinemagraph_id AS cinemagraph_id_42, e1_.territory_id AS territory_id_43, e1_.season_id_id AS season_id_id_44, e1_.ogImage_id AS ogImage_id_45 FROM Typology t0_ LEFT JOIN Experience e1_ ON t0_.id = e1_.typology_id AND (e1_.typology_id = t0_.id) WHERE e1_.status = ? AND e1_.dateStart <= ? AND e1_.dateEnd >= ?
Parameters:
[
  1
  "2024-11-24"
  "2024-11-24"
]
6 0.39 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[]
7 0.37 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
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\Typology
  • The mappings App\Entity\Typology#articles and App\Entity\Article#typology are inconsistent with each other.
App\Entity\Page No errors.
App\Entity\Review No errors.
App\Entity\Routing No errors.
App\Entity\Experience No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Entity\Accommodation No errors.
App\Entity\Territory No errors.
App\Entity\Season No errors.
App\Entity\PageContent No errors.
App\Entity\Article No errors.
App\Entity\Host No errors.
App\Entity\Note No errors.
App\Entity\ReviewOverallFeeling No errors.
App\Entity\Theme
  • The mappings App\Entity\Theme#articles and App\Entity\Article#themes are inconsistent with each other.
  • The mappings App\Entity\Theme#territories and App\Entity\Experience#themes are inconsistent with each other.
App\Entity\Story No errors.
App\Entity\Service
  • The mappings App\Entity\Service#displayInActivities and App\Entity\Activity#services are inconsistent with each other.
App\Entity\Activity
  • The mappings App\Entity\Activity#displayedServices and App\Entity\Service#activities are inconsistent with each other.
  • The association App\Entity\Activity#touristicObjects refers to the inverse side field App\Entity\TouristicObject#touristicobject which does not exist.
App\Entity\ArticleExperience No errors.
App\Entity\Sales No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia No errors.
App\Application\Sonata\MediaBundle\Entity\GalleryHasMedia No errors.
Sonata\ClassificationBundle\Entity\BaseCategory No errors.
App\Application\Sonata\ClassificationBundle\Entity\Category No errors.
App\Entity\City No errors.