GET https://affinia.online/residence/viber_dummy

Query Metrics

4 Database Queries
4 Different statements
1.90 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.public_name AS public_name_3, t0.short_description AS short_description_4, t0.text AS text_5, t0.thumb AS thumb_6, t0.image AS image_7, t0.address AS address_8, t0.gps AS gps_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.video AS video_12, t0.cover_brochure AS cover_brochure_13, t0.brochure AS brochure_14, t0.prestations AS prestations_15, t0.is_published AS is_published_16, t0.is_project_price_published AS is_project_price_published_17, t0.is_featured AS is_featured_18, t0.lat AS lat_19, t0.lng AS lng_20, t0.second_long_text AS second_long_text_21, t0.project_manager_id AS project_manager_id_22, t0.city_id AS city_id_23, t0.country_state_id AS country_state_id_24 FROM residence t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "viber_dummy"
]
2 0.22 ms
"START TRANSACTION"
Parameters:
[]
3 0.31 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:50:\"App\\Messenger\\Message\\TrackingKernelRequestMessage\":1:{s:59:\"\0App\\Messenger\\Message\\TrackingKernelRequestMessage\0content\";a:12:{s:9:\"userAgent\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:2:\"ip\";s:12:\"3.145.97.104\";s:7:\"referer\";N;s:14:\"acceptLanguage\";N;s:3:\"uri\";s:44:\"https://affinia.online/residence/viber_dummy\";s:7:\"cookies\";a:0:{}s:6:\"params\";a:0:{}s:7:\"dateAdd\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-11-05 06:49:44.036530\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:9:\"phpsessid\";N;s:12:\"utm_campaign\";N;s:10:\"utm_source\";N;s:6:\"EVSSID\";s:36:\"f2fb4f1a-dc30-4c4f-9b02-9f8757ad19f0\";}}}"
  "[]"
  "default"
  "2024-11-05 06:49:44"
  "2024-11-05 06:49:44"
]
4 0.90 ms
"COMMIT"
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\Residence
  • The association App\Entity\Residence#documents refers to the owning side field App\Entity\Document#project which does not exist.
  • The association App\Entity\Residence#city refers to the inverse side field App\Entity\City#cProjects which does not exist.
  • The association App\Entity\Residence#countryState refers to the inverse side field App\Entity\State#cProjects which does not exist.
App\Entity\Employee No errors.
App\Entity\City
  • The mappings App\Entity\City#residences and App\Entity\Residence#city are inconsistent with each other.
App\Entity\State
  • The mappings App\Entity\State#residences and App\Entity\Residence#countryState are inconsistent with each other.