https://mazego.fr/caisse/ligne/15/supprimer Return to referer URL

Query Metrics

7 Database Queries
7 Different statements
4.43 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.42 ms
(32.04%)
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
]
0.64 ms
(14.51%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.quantite AS quantite_3, t0.prix_unitaire_ht AS prix_unitaire_ht_4, t0.taux_tva AS taux_tva_5, t0.remise_manuelle AS remise_manuelle_6, t0.remise_produit AS remise_produit_7, t0.note AS note_8, t0.quantite_envoyee_cuisine AS quantite_envoyee_cuisine_9, t0.created_at AS created_at_10, t0.commande_id AS commande_id_11, t0.produit_id AS produit_id_12 FROM ligne_commande_caisse t0 WHERE t0.id = ?
Parameters:
[
  "15"
]
0.63 ms
(14.19%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.quantite AS quantite_3, t0.prix_unitaire_ht AS prix_unitaire_ht_4, t0.taux_tva AS taux_tva_5, t0.remise_manuelle AS remise_manuelle_6, t0.remise_produit AS remise_produit_7, t0.note AS note_8, t0.quantite_envoyee_cuisine AS quantite_envoyee_cuisine_9, t0.created_at AS created_at_10, t0.commande_id AS commande_id_11, t0.produit_id AS produit_id_12 FROM ligne_commande_caisse t0 WHERE t0.commande_id = ? ORDER BY t0.id ASC
Parameters:
[
  11
]
0.59 ms
(13.36%)
1
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.type_commande AS type_commande_3, t0.nb_couverts AS nb_couverts_4, t0.libelle AS libelle_5, t0.note AS note_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.closed_at AS closed_at_9, t0.user_id AS user_id_10, t0.entreprise_id AS entreprise_id_11, t0.table_id AS table_id_12, t0.client_id AS client_id_13, t0.cree_par_user_id AS cree_par_user_id_14, t0.cree_par_salarie_id AS cree_par_salarie_id_15, t0.devis_id AS devis_id_16 FROM commande_caisse t0 WHERE t0.id = ?
Parameters:
[
  11
]
0.52 ms
(11.85%)
1
DELETE FROM ligne_commande_caisse WHERE id = ?
Parameters:
[
  15
]
0.33 ms
(7.35%)
1
"COMMIT"
Parameters:
[]
0.30 ms
(6.70%)
1
"START TRANSACTION"
Parameters:
[]

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\CommandeCaisse No errors.
App\Entity\LigneCommandeCaisse No errors.
App\Entity\TableRestaurant No errors.
App\Entity\Client
  • The association App\Entity\Client#user refers to the inverse side field App\Entity\User#clients which does not exist.
App\Entity\Salarie No errors.
App\Entity\Categorie No errors.
App\Entity\SalleRestaurant No errors.