GET https://backendprod.ateliya.com/api/accueil/5/boutique

Query Metrics

43 Database Queries
12 Different statements
20.05 ms Query time
0 Invalid entities
97 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.33 ms
(16.62%)
7
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.surccursale_id AS surccursale_id_10, t0.photo_id AS photo_id_11, t12.id AS id_13, t12.size AS size_14, t12.path AS path_15, t12.alt AS alt_16, t12.date_creation AS date_creation_17, t12.url AS url_18, t0.boutique_id AS boutique_id_19, t0.entreprise_id AS entreprise_id_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22 FROM client t0 LEFT JOIN param_fichier t12 ON t0.photo_id = t12.id WHERE t0.id = ?
Parameters:
[
  247
]
3.32 ms
(16.55%)
7
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.quantite AS quantite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_active AS is_active_7, t0.module_abonnement_id AS module_abonnement_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM ligne_module t0 WHERE t0.module_abonnement_id = ?
Parameters:
[
  1
]
3.00 ms
(14.98%)
7
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.quantite_globale AS quantite_globale_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_active AS is_active_6, t0.photo_id AS photo_id_7, t8.id AS id_9, t8.size AS size_10, t8.path AS path_11, t8.alt AS alt_12, t8.date_creation AS date_creation_13, t8.url AS url_14, t0.entreprise_id AS entreprise_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM modele t0 LEFT JOIN param_fichier t8 ON t0.photo_id = t8.id WHERE t0.id = ?
Parameters:
[
  9
]
2.89 ms
(14.40%)
8
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix AS prix_3, t0.taille AS taille_4, t0.prix_minimal AS prix_minimal_5, t0.couleur AS couleur_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.modele_id AS modele_id_10, t0.boutique_id AS boutique_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM modele_boutique t0 WHERE t0.id = ?
Parameters:
[
  87
]
2.68 ms
(13.34%)
7
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.montant AS montant_3, t0.remise AS remise_4, t0.modele_boutique_id AS modele_boutique_id_5, t0.paiement_boutique_id AS paiement_boutique_id_6 FROM paiement_boutique_ligne t0 WHERE t0.paiement_boutique_id = ?
Parameters:
[
  302
]
1.13 ms
(5.66%)
1
SELECT p0_.id AS id_0, p0_.montant AS montant_1, p0_.reference AS reference_2, p0_.type AS type_3, p0_.moyen_paiement AS moyen_paiement_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.is_active AS is_active_7, p0_.discr AS discr_8, p0_.created_by_id AS created_by_id_9, p0_.updated_by_id AS updated_by_id_10, p1_.reservation_id AS reservation_id_11 FROM paiement_reservation p1_ INNER JOIN paiement p0_ ON p1_.id = p0_.id LEFT JOIN reservation r2_ ON p1_.reservation_id = r2_.id WHERE r2_.boutique_id = ? ORDER BY p0_.created_at DESC LIMIT 10
Parameters:
[
  "5"
]
0.83 ms
(4.12%)
1
SELECT t0.id AS id_1, t0.nombre_user AS nombre_user_2, t0.nombre_sms AS nombre_sms_3, t0.nombre_succursale AS nombre_succursale_4, t0.send_messsage_automatic_if_rendez_vous_proche AS send_messsage_automatic_if_rendez_vous_proche_5, t0.nombre_jour_restant_pour_envoyer_sms AS nombre_jour_restant_pour_envoyer_sms_6, t0.modele_message_envoyer_pour_rendez_vous_proche AS modele_message_envoyer_pour_rendez_vous_proche_7, t0.nombre_boutique AS nombre_boutique_8, t0.numero_abonnement AS numero_abonnement_9, t0.message_facture_boutique AS message_facture_boutique_10, t0.message_facture_atelier AS message_facture_atelier_11, t0.is_mall_active AS is_mall_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.is_active AS is_active_15, t0.entreprise_id AS entreprise_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18 FROM setting t0 WHERE t0.entreprise_id = ? LIMIT 1
Parameters:
[
  1
]
0.74 ms
(3.71%)
1
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.description AS description_3, t0.montant AS montant_4, t0.duree AS duree_5, t0.code AS code_6, t0.numero AS numero_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.pays_id AS pays_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM module_abonnement t0 WHERE t0.etat = ? ORDER BY t0.numero ASC
Parameters:
[
  "actif"
]
0.71 ms
(3.56%)
1
SELECT t1.id AS id_2, t1.montant AS montant_3, t1.reference AS reference_4, t1.type AS type_5, t1.moyen_paiement AS moyen_paiement_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.is_active AS is_active_9, t0.quantite AS quantite_10, t1.created_by_id AS created_by_id_11, t1.updated_by_id AS updated_by_id_12, t0.boutique_id AS boutique_id_13, t0.client_id AS client_id_14, t1.discr FROM paiement_boutique t0 INNER JOIN paiement t1 ON t0.id = t1.id WHERE t0.boutique_id = ? ORDER BY t1.created_at DESC LIMIT 10
Parameters:
[
  "5"
]
0.54 ms
(2.68%)
1
SELECT t1.id AS id_2, t1.montant AS montant_3, t1.reference AS reference_4, t1.type AS type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.is_active AS is_active_8, t1.entreprise_id AS entreprise_id_9, t1.created_by_id AS created_by_id_10, t1.updated_by_id AS updated_by_id_11, t0.boutique_id AS boutique_id_12, t1.discr FROM caisse_boutique t0 INNER JOIN caisse t1 ON t0.id = t1.id WHERE t0.boutique_id = ? LIMIT 1
Parameters:
[
  "5"
]
0.51 ms
(2.54%)
1
SELECT SUM(d0_.montant) AS sclr_0 FROM depense_caisse d0_ WHERE d0_.caisse_id = ?
Parameters:
[
  6
]
0.37 ms
(1.84%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenoms AS prenoms_8, t0.plain_reset_token AS plain_reset_token_9, t0.plain_token_expires_at AS plain_token_expires_at_10, t0.fcm_token AS fcm_token_11, t0.code_parrain AS code_parrain_12, t0.surccursale_id AS surccursale_id_13, t0.entreprise_id AS entreprise_id_14, t0.type_id AS type_id_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.size AS size_19, t17.path AS path_20, t17.alt AS alt_21, t17.date_creation AS date_creation_22, t17.url AS url_23, t0.boutique_id AS boutique_id_24 FROM users t0 LEFT JOIN param_fichier t17 ON t0.logo_id = t17.id WHERE t0.login = ? LIMIT 1
Parameters:
[
  "papsonboutik07@gmail.com"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\LigneModule 35
App\Entity\PaiementBoutiqueLigne 9
App\Entity\Fichier 8
App\Entity\ModeleBoutique 8
App\Entity\ModuleAbonnement 7
App\Entity\Paiement 7
App\Entity\Client 7
App\Entity\Modele 7
App\Entity\User 3
App\Entity\Entreprise 1
App\Entity\TypeUser 1
App\Entity\Pays 1
App\Entity\Setting 1
App\Entity\Boutique 1
App\Entity\Caisse 1