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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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
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 = '5' ORDER BY p0_.created_at DESC LIMIT 10;
|
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
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 = 1 LIMIT 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
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 = 'actif' ORDER BY t0.numero ASC;
|
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
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 = '5' ORDER BY t1.created_at DESC LIMIT 10;
|
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
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 = '5' LIMIT 1;
|
0.51 ms (2.54%)
|
1 |
SELECT SUM(d0_.montant) AS sclr_0 FROM depense_caisse d0_ WHERE d0_.caisse_id = ?
SELECT SUM(d0_.montant) AS sclr_0 FROM depense_caisse d0_ WHERE d0_.caisse_id = 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"
]
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 = 'papsonboutik07@gmail.com' LIMIT 1;
|