https://glapp.ch/piece/4271/edit

Query Metrics

51 Database Queries
9 Different statements
56.20 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\Client#docs and App\Entity\Doc#client are inconsistent with each other.
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.