https://harmony.assiecloud.com/fr/dashboard/kouassi-nazaire-ndri/liste-produit-lors-commande

Query Metrics

35 Database Queries
6 Different statements
24.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.58 ms
(42.84%)
1
SELECT t0.slug_username AS slug_username_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.sexe AS sexe_5, t0.id AS id_6, t0.email AS email_7, t0.email_token AS email_token_8, t0.nom AS nom_9, t0.prenom AS prenom_10, t0.nom_complet AS nom_complet_11, t0.dateNaissance AS dateNaissance_12, t0.contacts AS contacts_13, t0.adresse AS adresse_14, t0.matricule AS matricule_15, t0.salaire AS salaire_16, t0.numero_cnps AS numero_cnps_17, t0.vacataire AS vacataire_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.filename AS filename_21, t0.boutique_id AS boutique_id_22, t0.avatar_id AS avatar_id_23 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  116
]
7.29 ms
(29.52%)
1
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.reference AS reference_3, t0.nom AS nom_4, t0.prix_dachat AS prix_dachat_5, t0.description AS description_6, t0.stock_minimum AS stock_minimum_7, t0.stock_disponible AS stock_disponible_8, t0.stock_de_securite AS stock_de_securite_9, t0.stock_dalerte AS stock_dalerte_10, t0.stock_outil AS stock_outil_11, t0.stock_maximum AS stock_maximum_12, t0.cout_de_stockage AS cout_de_stockage_13, t0.gere_le_stock AS gere_le_stock_14, t0.unite_de_mesure AS unite_de_mesure_15, t0.codebarre AS codebarre_16, t0.est_supprime AS est_supprime_17, t0.boutique_id AS boutique_id_18, t0.tva_id AS tva_id_19, t0.prix_actuel_id AS prix_actuel_id_20, t0.type_produit_id AS type_produit_id_21, t0.photo_id AS photo_id_22, t0.categorie_produit_id AS categorie_produit_id_23, t0.cree_par_id AS cree_par_id_24, t0.modifie_par_id AS modifie_par_id_25, t0.supprime_par_id AS supprime_par_id_26 FROM gestock_produit t0 WHERE t0.boutique_id = ? AND t0.est_supprime = ?
Parameters:
[
  55
  0
]
4.71 ms
(19.08%)
28
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.boutique_id AS boutique_id_5, t0.produit_id AS produit_id_6 FROM gestock_prix_produit t0 WHERE t0.id = ?
Parameters:
[
  1579
]
0.99 ms
(4.02%)
1
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.nom AS nom_4, t0.heure_debut_travail AS heure_debut_travail_5, t0.heure_fin_travail AS heure_fin_travail_6, t0.temps_de_travail AS temps_de_travail_7, t0.sigle AS sigle_8, t0.email AS email_9, t0.phone AS phone_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.site_web AS site_web_13, t0.fax AS fax_14, t0.statut_juridique AS statut_juridique_15, t0.capital AS capital_16, t0.matricule AS matricule_17, t0.siret AS siret_18, t0.ape AS ape_19, t0.cc AS cc_20, t0.facture_tva AS facture_tva_21, t0.mention_legal AS mention_legal_22, t0.banque AS banque_23, t0.rib AS rib_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.url_fnede_base AS url_fnede_base_27, t0.api_key_fne AS api_key_fne_28, t0.solde_timbre_fne AS solde_timbre_fne_29, t0.numero_cnps AS numero_cnps_30, t0.logo_id AS logo_id_31, t0.settings_id AS settings_id_32, t0.pays_id AS pays_id_33 FROM gestock_boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "kouassi-nazaire-ndri"
]
0.56 ms
(2.27%)
1
SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.est_parti AS est_parti_3, t0.est_employe AS est_employe_4, t0.salaire AS salaire_5, t0.matricule AS matricule_6, t0.la_fonction AS la_fonction_7, t0.categorie_emploi AS categorie_emploi_8, t0.la_qualification AS la_qualification_9, t0.departement_emploi AS departement_emploi_10, t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_11, t0.igr AS igr_12, t0.nombre_d_enfant AS nombre_d_enfant_13, t0.nom_etablissement_fne AS nom_etablissement_fne_14, t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_15, t0.droits AS droits_16, t0.boutique_id AS boutique_id_17, t0.user_id AS user_id_18 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 1
Parameters:
[
  116
  55
]
0.56 ms
(2.27%)
3
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.est_principale AS est_principale_3, t0.libelle_interne AS libelle_interne_4, t0.valeur AS valeur_5, t0.boutique_id AS boutique_id_6 FROM gestock_tva t0 WHERE t0.id = ?
Parameters:
[
  72
]

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\Boutique No errors.
App\Entity\Photo No errors.
App\Entity\Settings No errors.
App\Entity\Pays No errors.
App\Entity\AppUser No errors.
App\Entity\Produit No errors.
App\Entity\TVA No errors.
App\Entity\PrixProduit No errors.
App\Entity\TypeProduit No errors.
App\Entity\CategorieProduit No errors.
App\Entity\UserBoutique No errors.