Query Metrics

9 Database Queries
9 Different statements
9.24 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.44 ms
DELETE FROM token WHERE name IS NULL AND lifetime IS NOT NULL AND (create_time + lifetime) < ?
Parameters:
[
  1727670802
]
2 0.32 ms
SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.lifetime AS lifetime_3, t0.rights AS rights_4, t0.name AS name_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM token t0 WHERE t0.id = ?
Parameters:
[
  "TOKEN_d4bdf33b4dc928c690f4458f00e296fda0b3ec1e"
]
3 0.49 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.enable AS enable_5, t0.salt AS salt_6, t0.roles AS roles_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
  13
]
4 1.62 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM cubage_prestation_estimed c0_ WHERE c0_.prestation_id IN (?)
Parameters:
[
  [
    1025
  ]
]
5 0.75 ms
SELECT c0_.id AS id_0, c0_.volume_inner AS volume_inner_1, c0_.volume_outter AS volume_outter_2, c0_.coef AS coef_3, c0_.volume_stere AS volume_stere_4, c0_.coef_stere AS coef_stere_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.prestation_id AS prestation_id_10, c0_.bois_type_id AS bois_type_id_11, c0_.bois_quality_id AS bois_quality_id_12, c0_.bois_size_id AS bois_size_id_13, c0_.marquage_id AS marquage_id_14 FROM cubage_prestation_estimed c0_ WHERE c0_.prestation_id IN (?) ORDER BY c0_.id ASC LIMIT 10
Parameters:
[
  [
    1025
  ]
]
6 1.09 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM bois_type t0 WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
7 1.42 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM bois_quality t0 WHERE t0.id IN (?)
Parameters:
[
  [
    6
  ]
]
8 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.grume AS grume_3 FROM bois_size t0 WHERE t0.id IN (?)
Parameters:
[
  [
    7
  ]
]
9 1.51 ms
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.cubage_prestation_estimed_id AS cubage_prestation_estimed_id_19 FROM document_cubage_pour_client t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.cubage_prestation_estimed_id = ?
Parameters:
[
  191
]

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\Token No errors.
App\Entity\User No errors.
App\Entity\Contrat No errors.
App\Entity\CubagePrestationEstimed No errors.
App\Entity\Prestation No errors.
App\Entity\BoisType No errors.
App\Entity\BoisQuality No errors.
App\Entity\BoisSize No errors.
App\Entity\Marquage No errors.
App\Entity\DocumentCubagePourClient No errors.
App\Entity\CubageLivraison No errors.
App\Entity\CubageLivraisonPlateforme No errors.
App\Entity\CubagePlateforme No errors.
App\Entity\CubageChantier No errors.
App\Entity\CubageChantierRestant No errors.
App\Entity\PurchasePrice No errors.
App\Entity\CubagePlateformeRestant No errors.
App\Entity\LivraisonPlateformePourChauffeur No errors.
App\Entity\Media No errors.