Query Metrics
8
Database Queries
8
Different statements
169.81 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
27.70 ms (16.31%) |
1 |
SELECT u0_.id AS id_0, u0_.adresse AS adresse_1, u0_.prix AS prix_2, u0_.date_time_maj AS date_time_maj_3, u0_.erreur AS erreur_4, u0_.commentaire AS commentaire_5, u0_.crawl_prioritaire AS crawl_prioritaire_6, v1_.id AS id_7, v1_.nom AS nom_8, v1_.filtre AS filtre_9, v1_.filtre_secondaire AS filtre_secondaire_10, v1_.methode AS methode_11, v1_.etat AS etat_12, v1_.commentaire AS commentaire_13, u0_.produit_id AS produit_id_14, u0_.vendeur_id AS vendeur_id_15 FROM url u0_ INNER JOIN vendeur v1_ ON u0_.vendeur_id = v1_.id WHERE v1_.etat = 1 AND u0_.erreur = ? ORDER BY u0_.date_time_maj ASC LIMIT 1
Parameters:
[
"NON"
]
|
24.47 ms (14.41%) |
1 |
SELECT u0_.id AS id_0, u0_.adresse AS adresse_1, u0_.prix AS prix_2, u0_.date_time_maj AS date_time_maj_3, u0_.erreur AS erreur_4, u0_.commentaire AS commentaire_5, u0_.crawl_prioritaire AS crawl_prioritaire_6, v1_.id AS id_7, v1_.nom AS nom_8, v1_.filtre AS filtre_9, v1_.filtre_secondaire AS filtre_secondaire_10, v1_.methode AS methode_11, v1_.etat AS etat_12, v1_.commentaire AS commentaire_13, u0_.produit_id AS produit_id_14, u0_.vendeur_id AS vendeur_id_15 FROM url u0_ INNER JOIN vendeur v1_ ON u0_.vendeur_id = v1_.id WHERE u0_.crawl_prioritaire = 1 AND u0_.erreur = ? AND v1_.etat = 1 ORDER BY u0_.date_time_maj ASC LIMIT 1
Parameters:
[
"NON"
]
|
20.42 ms (12.02%) |
1 |
"COMMIT"
Parameters:
[] |
20.31 ms (11.96%) |
1 |
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.prix AS prix_3, t0.date_time_maj AS date_time_maj_4, t0.erreur AS erreur_5, t0.commentaire AS commentaire_6, t0.crawl_prioritaire AS crawl_prioritaire_7, t0.produit_id AS produit_id_8, t0.vendeur_id AS vendeur_id_9 FROM url t0 ORDER BY t0.date_time_maj DESC LIMIT 1
Parameters:
[] |
20.14 ms (11.86%) |
1 |
SELECT t0.id AS id_1, t0.parametre AS parametre_2, t0.valeur AS valeur_3 FROM configuration t0 WHERE t0.parametre = ? LIMIT 1
Parameters:
[
"URL_WEBDRIVER_CHROME_DRIVER"
]
|
19.15 ms (11.27%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.ordre_application AS ordre_application_4, t0.vendeur_id AS vendeur_id_5 FROM `action` t0 WHERE t0.vendeur_id = ? ORDER BY t0.ordre_application ASC
Parameters:
[
41
]
|
18.92 ms (11.14%) |
1 |
UPDATE url SET date_time_maj = ? WHERE id = ?
Parameters:
[ "2025-09-03 15:38:05" 1700 ] |
18.72 ms (11.02%) |
1 |
"START TRANSACTION"
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\Url | No errors. |
App\Entity\Vendeur | No errors. |
App\Entity\Produit | No errors. |
App\Entity\Action | No errors. |
App\Entity\Configuration | No errors. |