Query Metrics
51
Database Queries
9
Different statements
56.20 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.83 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.numero AS numero_3, t0.type AS type_4, t0.amount_ht AS amount_ht_5, t0.amount_tva AS amount_tva_6, t0.discount AS discount_7, t0.amount_discount AS amount_discount_8, t0.amount_ttc AS amount_ttc_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.payer AS payer_12, t0.amount_buy_ht AS amount_buy_ht_13, t0.amount_marge AS amount_marge_14, t0.solde AS solde_15, t0.mode_paiement AS mode_paiement_16, t0.amount_discount_total AS amount_discount_total_17, t0.client_id AS client_id_18, t0.user_id AS user_id_19 FROM piece t0 WHERE t0.id = ?
Parameters:
[
"4271"
]
|
2 | 0.31 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.tel AS tel_7, t0.role AS role_8, t0.avatar AS avatar_9, t0.active AS active_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3 | 0.73 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.price_ht AS price_ht_4, t0.qty AS qty_5, t0.tva AS tva_6, t0.total_ht AS total_ht_7, t0.marge AS marge_8, t0.price_buy_ht AS price_buy_ht_9, t0.rabais AS rabais_10, t0.amount_rabais AS amount_rabais_11, t0.piece_id AS piece_id_12, t0.product_id AS product_id_13, t0.lot_id AS lot_id_14 FROM piece_line t0 WHERE t0.piece_id = ?
Parameters:
[
4271
]
|
4 | 0.33 ms |
SELECT t0.id AS id_1, t0.tva AS tva_2, t0.name AS name_3, t0.address AS address_4, t0.tel AS tel_5, t0.email AS email_6, t0.web AS web_7, t0.code_tva AS code_tva_8, t0.logo AS logo_9, t0.tva_active AS tva_active_10, t0.updated_at AS updated_at_11 FROM configuration t0 WHERE t0.id = ?
Parameters:
[
1
]
|
5 | 5.11 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC
Parameters:
[] |
6 | 5.27 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1637
]
|
7 | 0.63 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1633
]
|
8 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1632
]
|
9 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1635
]
|
10 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1634
]
|
11 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1636
]
|
12 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1639
]
|
13 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1641
]
|
14 | 0.67 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1661
]
|
15 | 6.69 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1660
]
|
16 | 0.62 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1625
]
|
17 | 0.46 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1656
]
|
18 | 0.40 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1659
]
|
19 | 0.37 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1638
]
|
20 | 0.35 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1631
]
|
21 | 0.35 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1648
]
|
22 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1652
]
|
23 | 0.35 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1649
]
|
24 | 0.36 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1658
]
|
25 | 0.35 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1629
]
|
26 | 0.35 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1630
]
|
27 | 0.46 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1655
]
|
28 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1628
]
|
29 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1650
]
|
30 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1617
]
|
31 | 5.06 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1619
]
|
32 | 0.66 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1644
]
|
33 | 0.43 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1651
]
|
34 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1647
]
|
35 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1646
]
|
36 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1645
]
|
37 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1657
]
|
38 | 0.40 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1618
]
|
39 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1620
]
|
40 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1640
]
|
41 | 0.39 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1616
]
|
42 | 0.38 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1654
]
|
43 | 0.37 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1653
]
|
44 | 5.10 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = ?
Parameters:
[
1643
]
|
45 | 4.93 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.tel AS tel_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_client AS type_client_8, t0.address AS address_9, t0.sexe AS sexe_10, t0.date_naissance AS date_naissance_11, t0.poids AS poids_12, t0.taux_graisse AS taux_graisse_13, t0.experience_fitness AS experience_fitness_14, t0.experience_fitness_quoi AS experience_fitness_quoi_15, t0.combiens_annees AS combiens_annees_16, t0.fumez_vous AS fumez_vous_17, t0.buvez_alcool AS buvez_alcool_18, t0.maladie_existant AS maladie_existant_19, t0.traitement AS traitement_20, t0.medicament AS medicament_21, t0.medicament_quoi AS medicament_quoi_22, t0.operation AS operation_23, t0.operation_quoi AS operation_quoi_24, t0.objectif AS objectif_25, t0.remarque AS remarque_26, t0.type_abo AS type_abo_27, t0.date_ref AS date_ref_28, t0.can_edit AS can_edit_29, t0.edit_files AS edit_files_30, t0.edit_fitness AS edit_fitness_31, t0.edit_diete AS edit_diete_32, t0.edit_invoices AS edit_invoices_33, t0.user_id AS user_id_34 FROM client t0 WHERE t0.id = ?
Parameters:
[
265
]
|
46 | 0.37 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC
Parameters:
[] |
47 | 5.39 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC
Parameters:
[] |
48 | 0.56 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.tel AS tel_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.type_client AS type_client_7, c0_.address AS address_8, c0_.sexe AS sexe_9, c0_.date_naissance AS date_naissance_10, c0_.poids AS poids_11, c0_.taux_graisse AS taux_graisse_12, c0_.experience_fitness AS experience_fitness_13, c0_.experience_fitness_quoi AS experience_fitness_quoi_14, c0_.combiens_annees AS combiens_annees_15, c0_.fumez_vous AS fumez_vous_16, c0_.buvez_alcool AS buvez_alcool_17, c0_.maladie_existant AS maladie_existant_18, c0_.traitement AS traitement_19, c0_.medicament AS medicament_20, c0_.medicament_quoi AS medicament_quoi_21, c0_.operation AS operation_22, c0_.operation_quoi AS operation_quoi_23, c0_.objectif AS objectif_24, c0_.remarque AS remarque_25, c0_.type_abo AS type_abo_26, c0_.date_ref AS date_ref_27, c0_.can_edit AS can_edit_28, c0_.edit_files AS edit_files_29, c0_.edit_fitness AS edit_fitness_30, c0_.edit_diete AS edit_diete_31, c0_.edit_invoices AS edit_invoices_32, c0_.user_id AS user_id_33 FROM client c0_ ORDER BY c0_.first_name ASC, c0_.last_name ASC
Parameters:
[] |
49 | 0.51 ms |
SELECT l0_.id AS id_0, l0_.stock AS stock_1, l0_.date_expiration AS date_expiration_2, l0_.product_id AS product_id_3 FROM lot l0_ WHERE l0_.product_id = ?
Parameters:
[
null
]
|
50 | 0.37 ms |
SELECT l0_.id AS id_0, l0_.stock AS stock_1, l0_.date_expiration AS date_expiration_2, l0_.product_id AS product_id_3 FROM lot l0_ WHERE l0_.product_id = ?
Parameters:
[
1641
]
|
51 | 0.33 ms |
SELECT l0_.id AS id_0, l0_.stock AS stock_1, l0_.date_expiration AS date_expiration_2, l0_.product_id AS product_id_3 FROM lot l0_ WHERE l0_.product_id = ?
Parameters:
[
1647
]
|
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\Piece | No errors. |
App\Entity\Client |
|
App\Entity\User | No errors. |
App\Entity\PieceLine | No errors. |
App\Entity\Affectation | No errors. |
App\Entity\Configuration | No errors. |
App\Entity\Payment | No errors. |
App\Entity\Gift | No errors. |
App\Entity\Product | No errors. |
App\Entity\Lot | No errors. |
App\Entity\Programm | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Doc | No errors. |
App\Entity\Programme | No errors. |