Redirect 302 redirect from POST @admin (a7837d)

Query Metrics

24 Database Queries
7 Different statements
10.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.89 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed AS password_changed_5, t0.last_password_change AS last_password_change_6, t0.temporary_password_count AS temporary_password_count_7, t0.plain_password AS plain_password_8, t0.password_reset_token AS password_reset_token_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
  39
]
2 0.57 ms
SELECT DISTINCT c0_.id AS id_0, c0_.numeros AS numeros_1 FROM commande c0_ WHERE c0_.user_id = ? ORDER BY c0_.numeros DESC LIMIT 20
Parameters:
[
  39
]
3 0.52 ms
SELECT c0_.id AS id_0, c0_.numeros AS numeros_1, c0_.objet AS objet_2, c0_.statut AS statut_3, c0_.autre_choix AS autre_choix_4, c0_.suivi_envoi AS suivi_envoi_5, c0_.quantities AS quantities_6, c0_.created_at AS created_at_7, c0_.status_date AS status_date_8, c0_.instruction_detail AS instruction_detail_9, c0_.agency_id AS agency_id_10, c0_.user_id AS user_id_11 FROM commande c0_ WHERE c0_.user_id = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.numeros DESC
Parameters:
[
  39
  279
  261
  229
  153
  145
  143
  140
  98
  84
  81
]
4 0.41 ms
SELECT count(*) AS sclr_0 FROM commande c0_ WHERE c0_.user_id = ?
Parameters:
[
  39
]
5 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5 FROM agences t0 WHERE t0.id = ?
Parameters:
[
  7
]
6 0.36 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  279
]
7 0.40 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.36 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  17
]
9 0.35 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  261
]
10 0.39 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.34 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  229
]
12 0.38 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  52
]
13 0.37 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  153
]
14 0.36 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  23
]
15 0.34 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  145
]
16 0.36 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  28
]
17 0.57 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  143
]
18 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  140
]
19 0.50 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  98
]
20 0.45 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  16
]
21 0.43 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  84
]
22 0.41 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.command_id AS command_id_3, t0.product_id AS product_id_4 FROM order_line t0 WHERE t0.command_id = ?
Parameters:
[
  81
]
23 0.48 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  12
]
24 0.47 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix AS prix_4, t0.poids AS poids_5, t0.stock AS stock_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.statut AS statut_10, t0.quantite AS quantite_11, t0.montant_lot AS montant_lot_12, t0.cout_transport AS cout_transport_13, t0.is_active AS is_active_14, t0.category AS category_15, t0.type_de_produit AS type_de_produit_16, t0.stock_minimum AS stock_minimum_17, t0.receive_start AS receive_start_18, t0.max_quantity AS max_quantity_19, t0.stock_alert_sent AS stock_alert_sent_20, t0.commande_id AS commande_id_21 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  19
]

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\User No errors.
App\Entity\Agences No errors.
App\Entity\Commande No errors.
App\Entity\Produit No errors.
App\Entity\OrderLine No errors.