https://erpwi-staging.vertuoz.fr/symfony/public/api/historique/user/26/refreshHistorique Return to referer URL

Query Metrics

6 Database Queries
6 Different statements
1.85 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.10 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.65 ms
UPDATE ba_historique_page SET updated_at = :date WHERE user_id = :userId AND url = :url
Parameters:
[
  "date" => "2025-07-01 15:15:02"
  "userId" => 26
  "url" => "/tableau-de-bord2"
]
4 0.13 ms
DELETE FROM ba_historique_page WHERE user_id = :userId AND updated_at < :date
Parameters:
[
  "date" => "2025-07-01 15:13:02"
  "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
  "/tableau-de-bord2"
  "2025-07-01 15:13:02"
]
6 0.12 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.