GET https://affinia.online/type/Residence-Senior

Response
200 OK
IP
3.147.63.199
Profiled on
Token
2292f2

Query Metrics

5 Database Queries
5 Different statements
7.16 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
4.82 ms
(67.43%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.69 ms
(9.70%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.68 ms
(9.46%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.floor AS floor_4, t0.exact_area AS exact_area_5, t0.date_add AS date_add_6, t0.usable_area AS usable_area_7, t0.plan AS plan_8, t0.short_description AS short_description_9, t0.long_description AS long_description_10, t0.thumb AS thumb_11, t0.slug AS slug_12, t0.address AS address_13, t0.number_rooms AS number_rooms_14, t0.number_bathrooms AS number_bathrooms_15, t0.lat AS lat_16, t0.lng AS lng_17, t0.google_street_link AS google_street_link_18, t0.year_built AS year_built_19, t0.materport AS materport_20, t0.video AS video_21, t0.video_youtube AS video_youtube_22, t0.type_id AS type_id_23, t0.residence_id AS residence_id_24, t0.customer_id AS customer_id_25, t0.album_id AS album_id_26, t0.city_id AS city_id_27, t0.department_id AS department_id_28, t0.provider_id AS provider_id_29, t0.provider_lead_id AS provider_lead_id_30 FROM property t0 WHERE t0.type_id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
0.52 ms
(7.25%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.public_title AS public_title_3, t0.thumb AS thumb_4, t0.image AS image_5, t0.short_description AS short_description_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.text AS text_9, t0.is_habitation AS is_habitation_10, t0.is_collectif AS is_collectif_11 FROM property_type t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "Residence-Senior"
]
View formatted query    View runnable query    Explain query
0.44 ms
(6.15%) 		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.63.199\";s:7:\"referer\";N;s:14:\"acceptLanguage\";N;s:3:\"uri\";s:44:\"https://affinia.online/type/Residence-Senior\";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 04:40:13.951510\";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:\"e716be1f-6432-41a0-8a24-7c345dc40a06\";}}}"
  "[]"
  "default"
  "2024-11-05 04:40:13"
  "2024-11-05 04:40:13"
]
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\PropertyType No errors.
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\ProviderLead No 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\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.
App\Entity\Album 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\Provider No errors.