Query Metrics
33
Database Queries
4
Different statements
42.95 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.96 ms (51.14%) |
30 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.description AS description_3, t0.puht AS puht_4, t0.remise AS remise_5, t0.npuht AS npuht_6, t0.nb AS nb_7, t0.prixht AS prixht_8, t0.tva AS tva_9, t0.code_barre AS code_barre_10, t0.nature_stock AS nature_stock_11, t0.num_bl AS num_bl_12, t0.piece AS piece_13, t0.marque AS marque_14, t0.modele AS modele_15, t0.immatriculation AS immatriculation_16, t0.date_commande AS date_commande_17, t0.nom_fournisseur AS nom_fournisseur_18, t0.image_url AS image_url_19, t0.top_vente AS top_vente_20, t0.prix_vente AS prix_vente_21, t0.type AS type_22, t0.tva_rate AS tva_rate_23, t0.discount_rate AS discount_rate_24, t0.unite AS unite_25, t0.commission_rate AS commission_rate_26, t0.user_id AS user_id_27, t0.fournisseur_id AS fournisseur_id_28, t0.categorie_id AS categorie_id_29 FROM produit t0 WHERE t0.id = ?
Parameters:
[
780
]
|
|
17.91 ms (41.70%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.description AS description_2, p0_.puht AS puht_3, p0_.remise AS remise_4, p0_.npuht AS npuht_5, p0_.nb AS nb_6, p0_.prixht AS prixht_7, p0_.tva AS tva_8, p0_.code_barre AS code_barre_9, p0_.nature_stock AS nature_stock_10, p0_.num_bl AS num_bl_11, p0_.piece AS piece_12, p0_.marque AS marque_13, p0_.modele AS modele_14, p0_.immatriculation AS immatriculation_15, p0_.date_commande AS date_commande_16, p0_.nom_fournisseur AS nom_fournisseur_17, p0_.image_url AS image_url_18, p0_.top_vente AS top_vente_19, p0_.prix_vente AS prix_vente_20, p0_.type AS type_21, p0_.tva_rate AS tva_rate_22, p0_.discount_rate AS discount_rate_23, p0_.unite AS unite_24, p0_.commission_rate AS commission_rate_25, p0_.user_id AS user_id_26, p0_.fournisseur_id AS fournisseur_id_27, p0_.categorie_id AS categorie_id_28 FROM produit p0_
Parameters:
[] |
|
1.72 ms (4.00%) |
1 |
SELECT s0_.id AS id_0, s0_.piece AS piece_1, s0_.quantite AS quantite_2, s0_.montant_htva AS montant_htva_3, s0_.num_bl AS num_bl_4, s0_.immatriculation AS immatriculation_5, s0_.reference AS reference_6, s0_.code_barre AS code_barre_7, s0_.id_produit_id AS id_produit_id_8 FROM stock s0_ INNER JOIN produit p1_ ON s0_.id_produit_id = p1_.id WHERE p1_.user_id = ? ORDER BY s0_.id DESC
Parameters:
[
12
]
|
|
1.35 ms (3.15%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.categorie AS categorie_7, t0.trial_start_date AS trial_start_date_8, t0.trial_end_date AS trial_end_date_9, t0.user_license AS user_license_10, t0.quota_used AS quota_used_11, t0.quota_month AS quota_month_12, t0.digigo_email AS digigo_email_13, t14.id AS id_15, t14.status AS status_16, t14.activated_at AS activated_at_17, t14.amount_paid AS amount_paid_18, t14.payment_transaction_id AS payment_transaction_id_19, t14.payment_method AS payment_method_20, t14.payment_date AS payment_date_21, t14.expires_at AS expires_at_22, t14.created_at AS created_at_23, t14.updated_at AS updated_at_24, t14.user_id AS user_id_25, t26.id AS id_27, t26.signatures_included AS signatures_included_28, t26.signatures_remaining AS signatures_remaining_29, t26.signatures_used AS signatures_used_30, t26.signature_cost_per_unit AS signature_cost_per_unit_31, t26.last_reset_at AS last_reset_at_32, t26.next_reset_at AS next_reset_at_33, t26.created_at AS created_at_34, t26.updated_at AS updated_at_35, t26.user_id AS user_id_36 FROM user t0 LEFT JOIN facture_electronique_activation t14 ON t14.user_id = t0.id LEFT JOIN signature_counter t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
12
]
|
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 |
|
| App\Entity\FactureElectroniqueActivation | No errors. |
| App\Entity\SignatureCounter | No errors. |
| App\Entity\Entreprise | No errors. |
| App\Entity\Commentaire | No errors. |
| App\Entity\Devis |
|
| App\Entity\Produit | No errors. |
| App\Entity\UserPage | No errors. |
| App\Entity\Entrees |
|
| App\Entity\Fournisseur | No errors. |
| App\Entity\Prospect | No errors. |
| App\Entity\RetourFournisseur | No errors. |
| App\Entity\FactureFournisseur | No errors. |
| App\Entity\RetourClient | No errors. |
| App\Entity\PaiementFournisseur | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\TicketReply | No errors. |
| App\Entity\Certificate | No errors. |
| App\Entity\TTNConfiguration | No errors. |
| App\Entity\FactureElectroniqueFacture | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Sorties | No errors. |
| App\Entity\DevisLine | No errors. |