https://mazego.fr/stock/new

Query Metrics

33 Database Queries
4 Different statements
83.99 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
41.55 ms
(49.47%)
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
]
20.99 ms
(24.99%)
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
]
19.96 ms
(23.77%)
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.49 ms
(1.77%)
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
  • The field App\Entity\User#paiementsFournisseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaiementFournisseur#user does not contain the required 'inversedBy="paiementsFournisseur"' attribute.
  • The field App\Entity\User#assignedTickets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ticket#assignedTo does not contain the required 'inversedBy="assignedTickets"' attribute.
  • The field App\Entity\User#ticketReplies is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketReply#user does not contain the required 'inversedBy="ticketReplies"' attribute.
App\Entity\FactureElectroniqueActivation No errors.
App\Entity\SignatureCounter No errors.
App\Entity\Entreprise No errors.
App\Entity\Commentaire No errors.
App\Entity\Devis
  • The field App\Entity\Devis#retoursFournisseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RetourFournisseur#bonCommande does not contain the required 'inversedBy="retoursFournisseur"' attribute.
App\Entity\Produit No errors.
App\Entity\UserPage No errors.
App\Entity\Entrees
  • The field App\Entity\Entrees#retoursFournisseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RetourFournisseur#reception does not contain the required 'inversedBy="retoursFournisseur"' attribute.
  • The field App\Entity\Entrees#lignesFactureFournisseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LigneFactureFournisseur#receptionLier does not contain the required 'inversedBy="lignesFactureFournisseur"' attribute.
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.