Query Metrics
62
Database Queries
11
Different statements
37.42 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
23.73 ms (63.40%) |
51 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.payment_id AS payment_id_5, t0.piece_id AS piece_id_6 FROM affectation t0 WHERE t0.payment_id = ?
Parameters:
[
1596
]
|
9.44 ms (25.23%) |
1 |
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:
[
"4388"
]
|
0.82 ms (2.18%) |
1 |
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.client_id = ?
Parameters:
[
259
]
|
0.78 ms (2.09%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.amount AS amount_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.client_id AS client_id_7, t0.user_id AS user_id_8 FROM payment t0 WHERE t0.client_id = ?
Parameters:
[
259
]
|
0.67 ms (1.78%) |
1 |
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:
[
4388
]
|
0.45 ms (1.20%) |
2 |
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 WHERE t0.id = ?
Parameters:
[
1641
]
|
0.39 ms (1.04%) |
1 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.payment_id AS payment_id_5, t0.piece_id AS piece_id_6 FROM affectation t0 WHERE t0.piece_id = ?
Parameters:
[
4388
]
|
0.32 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.percent AS percent_3, t0.created_at AS created_at_4, t0.client_id AS client_id_5, t0.user_id AS user_id_6 FROM gift t0 WHERE t0.client_id = ?
Parameters:
[
259
]
|
0.31 ms (0.84%) |
1 |
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
]
|
0.29 ms (0.78%) |
1 |
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:
[
259
]
|
0.23 ms (0.61%) |
1 |
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
]
|
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\Programm | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Doc | No errors. |
App\Entity\Programme | No errors. |
App\Entity\Product | No errors. |
App\Entity\Lot | No errors. |