Query Metrics
14
Database Queries
6
Different statements
14.43 ms
Query time
8
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.44 ms |
SELECT l0_.id AS id_0, l0_.deal_type AS deal_type_1, l0_.price AS price_2, l0_.date_added AS date_added_3, l0_.date_updated AS date_updated_4, l0_.date_expires AS date_expires_5, l0_.status AS status_6, l0_.is_negotiable AS is_negotiable_7, l0_.is_featured AS is_featured_8, l0_.description AS description_9, l0_.deposit AS deposit_10, l0_.charges AS charges_11, l0_.services AS services_12, l0_.assigned_at AS assigned_at_13, l0_.contract_end_at AS contract_end_at_14, l0_.assignment_type AS assignment_type_15, l0_.is_published AS is_published_16, l0_.slug AS slug_17, l0_.uuid AS uuid_18, l0_.property_id AS property_id_19, l0_.album_id AS album_id_20, l0_.customer_id AS customer_id_21, l0_.employee_id AS employee_id_22 FROM listing l0_ WHERE l0_.is_published = ? ORDER BY l0_.date_added DESC
Parameters:
[
1
]
|
2 | 4.55 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.public_title AS public_title_2, p0_.thumb AS thumb_3, p0_.image AS image_4, p0_.short_description AS short_description_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.text AS text_8, p0_.is_habitation AS is_habitation_9, p0_.is_collectif AS is_collectif_10 FROM property_type p0_
Parameters:
[] |
3 | 1.03 ms |
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.id = ?
Parameters:
[
173
]
|
4 | 0.73 ms |
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.id = ?
Parameters:
[
174
]
|
5 | 0.38 ms |
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.id = ?
Parameters:
[
175
]
|
6 | 0.34 ms |
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.id = ?
Parameters:
[
176
]
|
7 | 0.35 ms |
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.id = ?
Parameters:
[
177
]
|
8 | 0.40 ms |
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.id = ?
Parameters:
[
178
]
|
9 | 0.38 ms |
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.id = ?
Parameters:
[
179
]
|
10 | 0.35 ms |
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.id = ?
Parameters:
[
180
]
|
11 | 0.35 ms |
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.id = ?
Parameters:
[
181
]
|
12 | 1.88 ms |
"START TRANSACTION"
Parameters:
[] |
13 | 0.55 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.149.233.14\";s:7:\"referer\";N;s:14:\"acceptLanguage\";N;s:3:\"uri\";s:39:\"https://affinia.online/listings?page=11\";s:7:\"cookies\";a:0:{}s:6:\"params\";a:1:{s:4:\"page\";s:2:\"11\";}s:7:\"dateAdd\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-11-05 09:18:34.198064\";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:\"5d26bd03-3989-4140-aa46-86fd9f812405\";}}}" "[]" "default" "2024-11-05 09:18:34" "2024-11-05 09:18:34" ] |
14 | 1.70 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\Listing |
|
App\Entity\Property |
|
App\Entity\Album | No errors. |
App\Entity\Customer |
|
App\Entity\Employee | No errors. |
App\Entity\Deal | No errors. |
App\Entity\Lead | No errors. |
App\Entity\Proposal | No errors. |
App\Entity\AvailabilitySlot | No errors. |
App\Entity\Appointment | No errors. |
App\Entity\PropertyType | No errors. |
App\Entity\ProviderLead | No errors. |
App\Entity\Residence |
|
App\Entity\City |
|
App\Entity\State |
|
App\Entity\Provider | No errors. |
App\Entity\PropertyStateHistory | No errors. |
App\Entity\Document |
|
App\Entity\Feature |
|
App\Entity\NearbyServices | No errors. |