Redirect 302 redirect from GET @app_residence_show (50fccf)

GET https://affinia.online/residences

Response
200 OK
Browse referrer URL
IP
3.147.57.145
Profiled on
Token
aeb17c

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
9.81 ms
(61.31%) 		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
3.72 ms
(23.24%) 		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
1.41 ms
(8.81%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.58 ms
(3.63%) 		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
0.31 ms
(1.91%) 		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.57.145\";s:7:\"referer\";s:47:\"https://affinia.online/residence/whatsapp_dummy\";s:14:\"acceptLanguage\";N;s:3:\"uri\";s:33:\"https://affinia.online/residences\";s:7:\"cookies\";a:3:{s:11:\"sf_redirect\";s:310:\"{\"token\":\"50fccf\",\"route\":\"app_residence_show\",\"method\":\"GET\",\"controller\":{\"class\":\"App\\\\Controller\\\\Web\\\\WebPropertyController\",\"method\":\"showResidence\",\"file\":\"\\/var\\/www\\/affiniaAgency\\/affiniaAgencyPlus\\/src\\/Controller\\/Web\\/WebPropertyController.php\",\"line\":223},\"status_code\":302,\"status_text\":\"Found\"}\";s:9:\"PHPSESSID\";s:26:\"8os0e2l3c0trtnnm4uqkm9csgp\";s:6:\"EVSSID\";s:36:\"f0fd4929-6a42-46f6-9546-c0cf2e8878bb\";}s:6:\"params\";a:0:{}s:7:\"dateAdd\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-11-05 06:44:05.475469\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:9:\"phpsessid\";s:26:\"8os0e2l3c0trtnnm4uqkm9csgp\";s:12:\"utm_campaign\";N;s:10:\"utm_source\";N;s:6:\"EVSSID\";s:36:\"f0fd4929-6a42-46f6-9546-c0cf2e8878bb\";}}}"
  "[]"
  "default"
  "2024-11-05 06:44:05"
  "2024-11-05 06:44:05"
]
View formatted query    View runnable query    Explain query
0.17 ms
(1.09%) 		1 
"START TRANSACTION"
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\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.