GET https://affinia.online/residences

Response
200 OK
IP
3.147.46.181
Profiled on
Token
c16ba0

Query Metrics

32 Database Queries
6 Different statements
15.93 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
4.54 ms
(28.50%) 		14 
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.insee_code AS insee_code_6, t0.country_id AS country_id_7, t0.state_id AS state_id_8 FROM city t0 WHERE t0.id = ?
Parameters: 
[
  25112
]
View formatted query    View runnable query    Explain query
3.98 ms
(24.98%) 		1 
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.147.46.181\";s:7:\"referer\";N;s:14:\"acceptLanguage\";N;s:3:\"uri\";s:33:\"https://affinia.online/residences\";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 08:36:16.902190\";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:\"9821ce36-0fcc-4e98-83db-1a55e6035ef0\";}}}"
  "[]"
  "default"
  "2024-11-05 08:36:16"
  "2024-11-05 08:36:16"
]
View formatted query    View runnable query    Explain query
3.58 ms
(22.48%) 		14 
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.iso_code AS iso_code_4, t0.thumb AS thumb_5, t0.image AS image_6, t0.country_id AS country_id_7 FROM state t0 WHERE t0.id = ?
Parameters: 
[
  78
]
View formatted query    View runnable query    Explain query
1.79 ms
(11.20%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.33 ms
(8.37%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.71 ms
(4.47%) 		1 
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.is_active = ?
Parameters: 
[
  1
]
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\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.
App\Entity\Property
  • The field App\Entity\Property#features is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Feature#properties does not contain the required 'mappedBy="features"' attribute.
App\Entity\Album No errors.
App\Entity\Document
  • The mappings App\Entity\Document#residence and App\Entity\Residence#documents are inconsistent with each other.
App\Entity\Feature
  • The field App\Entity\Feature#properties is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Property#features does not contain the required 'mappedBy="properties"' attribute.
App\Entity\NearbyServices No errors.
App\Entity\Country
  • The association App\Entity\Country#residences refers to the owning side field App\Entity\Residence#country which does not exist.
App\Entity\Lead No errors.
App\Entity\Customer
  • The field App\Entity\Customer#proposals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Proposal#customer does not contain the required 'inversedBy="proposals"' attribute.