Query Metrics
16
Database Queries
9
Different statements
9.37 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.99 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.public_name AS public_name_2, c0_.short_description AS short_description_3, c0_.text AS text_4, c0_.thumb AS thumb_5, c0_.image AS image_6, c0_.address AS address_7, c0_.gps AS gps_8, c0_.slug AS slug_9, c0_.is_active AS is_active_10, c0_.video AS video_11, c0_.date_livraison AS date_livraison_12, c0_.cover_brochure AS cover_brochure_13, c0_.brochure AS brochure_14, c0_.prestations AS prestations_15, c0_.state AS state_16, c0_.is_published AS is_published_17, c0_.is_project_price_published AS is_project_price_published_18, c0_.co_proprity_fees AS co_proprity_fees_19, c0_.project_manager_id AS project_manager_id_20, c0_.country_id AS country_id_21, c0_.city_id AS city_id_22, c0_.country_state_id AS country_state_id_23 FROM cproject c0_ WHERE c0_.is_active = ?
Parameters:
[
1
]
|
2 | 0.84 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.thumb AS thumb_2, c0_.image AS image_3, c0_.is_active AS is_active_4, c0_.text AS text_5, c0_.price AS price_6, c0_.area AS area_7, c0_.slug AS slug_8, c0_.nbrbedrooms AS nbrbedrooms_9, c0_.nbrbathrooms AS nbrbathrooms_10, c0_.is_piscine AS is_piscine_11, c0_.is_garage AS is_garage_12, c0_.is_garden AS is_garden_13, c0_.floor_plan AS floor_plan_14, c0_.additional_array AS additional_array_15, c0_.video AS video_16, c0_.type_id AS type_id_17, c0_.project_id AS project_id_18 FROM cformat_bien c0_ WHERE c0_.is_active = ? ORDER BY c0_.id ASC
Parameters:
[
1
]
|
3 | 0.58 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.public_title AS public_title_2, c0_.thumb AS thumb_3, c0_.image AS image_4, c0_.short_description AS short_description_5, c0_.is_active AS is_active_6, c0_.slug AS slug_7, c0_.text AS text_8, c0_.is_habitation AS is_habitation_9, c0_.is_collectif AS is_collectif_10 FROM ctype_bien c0_ WHERE c0_.is_active = ?
Parameters:
[
1
]
|
4 | 0.69 ms |
SELECT t0.id AS id_1, t0.public_title AS public_title_2, t0.seo_title AS seo_title_3, t0.body AS body_4, t0.thumbnail AS thumbnail_5, t0.image AS image_6, t0.seo_description AS seo_description_7, t0.created_at AS created_at_8, t0.img_og AS img_og_9, t0.last_modified AS last_modified_10, t0.is_active AS is_active_11, t0.slug AS slug_12, t0.is_featured AS is_featured_13, t0.author_id AS author_id_14 FROM blog_post t0 WHERE t0.is_featured = ?
Parameters:
[
1
]
|
5 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.project_id = ?
Parameters:
[
1
]
|
6 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.project_id = ?
Parameters:
[
2
]
|
7 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.project_id = ?
Parameters:
[
3
]
|
8 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.project_id = ?
Parameters:
[
4
]
|
9 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.type_id = ?
Parameters:
[
1
]
|
10 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.type_id = ?
Parameters:
[
2
]
|
11 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.type_id = ?
Parameters:
[
3
]
|
12 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.type_id = ?
Parameters:
[
4
]
|
13 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.text AS text_6, t0.price AS price_7, t0.area AS area_8, t0.slug AS slug_9, t0.nbrbedrooms AS nbrbedrooms_10, t0.nbrbathrooms AS nbrbathrooms_11, t0.is_piscine AS is_piscine_12, t0.is_garage AS is_garage_13, t0.is_garden AS is_garden_14, t0.floor_plan AS floor_plan_15, t0.additional_array AS additional_array_16, t0.video AS video_17, t0.type_id AS type_id_18, t0.project_id AS project_id_19 FROM cformat_bien t0 WHERE t0.type_id = ?
Parameters:
[
5
]
|
14 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
15 | 0.54 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:\"18.222.98.91\";s:7:\"referer\";N;s:14:\"acceptLanguage\";N;s:3:\"uri\";s:24:\"https://grandbridge.org/\";s:7:\"cookies\";a:1:{s:6:\"EVSSID\";s:36:\"0567d829-29ec-42cb-87d7-f3ef9a46455b\";}s:6:\"params\";a:0:{}s:7:\"dateAdd\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-01-22 13:45:37.612953\";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:\"0567d829-29ec-42cb-87d7-f3ef9a46455b\";}}}" "[]" "default" "2025-01-22 13:45:37" "2025-01-22 13:45:37" ] |
16 | 1.65 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\CProject | No errors. |
App\Entity\Employee | No errors. |
App\Entity\Country | No errors. |
App\Entity\City | No errors. |
App\Entity\State | No errors. |
App\Entity\CBuiliding | No errors. |
App\Entity\Cbien | No errors. |
App\Entity\Album | No errors. |
App\Entity\CProjectStateHistory | No errors. |
App\Entity\CFormatBien | No errors. |
App\Entity\PaiementSchudle | No errors. |
App\Entity\ProviderOrder | No errors. |
App\Entity\Document | No errors. |
App\Entity\BienAdditional | No errors. |
App\Entity\CTypeBien | No errors. |
App\Entity\Customer | No errors. |
App\Entity\Lead | No errors. |
App\Entity\CreditSimulation | No errors. |
App\Entity\BlogPost | No errors. |
App\Entity\BlogCategory | No errors. |