Query Metrics
6
Database Queries
6
Different statements
2.04 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.14 ms |
SELECT param FROM doli_extrafields WHERE name = "sous_destination" AND elementtype = "societe"
Parameters:
[] |
2 | 0.15 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.is_active AS is_active_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.cellphone AS cellphone_9, t0.address AS address_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.avatar AS avatar_13, t0.uid AS uid_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.role_id AS role_id_17, t0.langue_id AS langue_id_18 FROM ba_user t0 WHERE t0.id = ?
Parameters:
[
26
]
|
3 | 0.77 ms |
UPDATE ba_historique_page SET updated_at = :date WHERE user_id = :userId AND url = :url
Parameters:
[ "date" => "2025-07-01 15:35:20" "userId" => 26 "url" => "/dossier/4759/segment/11189/composition" ] |
4 | 0.16 ms |
DELETE FROM ba_historique_page WHERE user_id = :userId AND updated_at < :date
Parameters:
[ "date" => "2025-07-01 15:33:20" "userId" => 26 ] |
5 | 0.71 ms |
SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.password AS password_2, b0_.email AS email_3, b0_.is_active AS is_active_4, b0_.firstname AS firstname_5, b0_.lastname AS lastname_6, b0_.phone AS phone_7, b0_.cellphone AS cellphone_8, b0_.address AS address_9, b0_.city AS city_10, b0_.zipcode AS zipcode_11, b0_.avatar AS avatar_12, b0_.uid AS uid_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b1_.id AS id_16, b1_.url AS url_17, b1_.query AS query_18, b1_.request AS request_19, b1_.user_actif AS user_actif_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, b0_.role_id AS role_id_23, b0_.langue_id AS langue_id_24, b1_.user_id AS user_id_25, b1_.created_by AS created_by_26, b1_.updated_by AS updated_by_27 FROM ba_user b0_ LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id WHERE b1_.user_id <> ? AND b1_.url = ? AND b1_.updated_at >= ? ORDER BY b1_.id ASC
Parameters:
[ 26 "/dossier/4759/segment/11189/composition" "2025-07-01 15:33:20" ] |
6 | 0.10 ms |
SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.locale AS locale_3, t0.translated_text AS translated_text_4, t0.is_validated AS is_validated_5, t0.redirect_url AS redirect_url_6, t0.sub_redirect_url AS sub_redirect_url_7 FROM translation t0 WHERE t0.redirect_url = ?
Parameters:
[
"/symfony/public/api/historique/user/26/refreshHistorique"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\DossierSegmentServiceGroupement | No errors. |
App\Entity\VoyageServiceGroupement | No errors. |
App\Entity\Allot\SegmentTour | No errors. |
App\Entity\Destination | No errors. |
App\Entity\User | No errors. |
App\Entity\Role | No errors. |
App\Entity\Langue | No errors. |
App\Entity\Log | No errors. |
App\Entity\HistoriquePage | No errors. |
App\Entity\Filtre | No errors. |
App\Entity\UserFilter | No errors. |
App\Entity\Dossier | No errors. |
App\Entity\TableauBordRequeteUser | No errors. |
App\Entity\DossierSegmentTodo | No errors. |
App\Entity\Translation | No errors. |