Query Metrics
9
Database Queries
9
Different statements
9.24 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.62 ms (0.00%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM cubage_prestation_estimed c0_ WHERE c0_.prestation_id IN (?)
Parameters:
[
[
1025
]
]
|
1.51 ms (0.00%) |
1 |
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
]
|
1.44 ms (0.00%) |
1 |
DELETE FROM token WHERE name IS NULL AND lifetime IS NOT NULL AND (create_time + lifetime) < ?
Parameters:
[
1727670802
]
|
1.42 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM bois_quality t0 WHERE t0.id IN (?)
Parameters:
[
[
6
]
]
|
1.09 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM bois_type t0 WHERE t0.id IN (?)
Parameters:
[
[
1
]
]
|
0.75 ms (0.00%) |
1 |
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
]
]
|
0.60 ms (0.00%) |
1 |
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
]
]
|
0.49 ms (0.00%) |
1 |
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
]
|
0.32 ms (0.00%) |
1 |
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"
]
|
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. |