GET https://roicargoapi.secssarl.com/api/demandes

Query Metrics

10 Database Queries
6 Different statements
0.71 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 0.13 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.google_id AS google_id_6, t0.telephone_whatsapp AS telephone_whatsapp_7, t0.ville AS ville_8, t0.langue AS langue_9, t0.roles AS roles_10, t0.identifiant_client AS identifiant_client_11, t0.numero_ifu AS numero_ifu_12, t0.nom_entreprise AS nom_entreprise_13, t0.is_active AS is_active_14, t0.avatar AS avatar_15, t0.device_token AS device_token_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.pays_id AS pays_id_20 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "admin@roicargo.com"
]
2 0.09 ms
SELECT t0.id AS id_1, t0.details_json AS details_json_2, t0.statut AS statut_3, t0.montant_fiche AS montant_fiche_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.client_id AS client_id_7, t0.service_id AS service_id_8, t0.devise_fiche_id AS devise_fiche_id_9, t0.transaction_id AS transaction_id_10 FROM demande_service t0 ORDER BY t0.created_at DESC
Parameters:
[]
3 0.07 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.google_id AS google_id_6, t0.telephone_whatsapp AS telephone_whatsapp_7, t0.ville AS ville_8, t0.langue AS langue_9, t0.roles AS roles_10, t0.identifiant_client AS identifiant_client_11, t0.numero_ifu AS numero_ifu_12, t0.nom_entreprise AS nom_entreprise_13, t0.is_active AS is_active_14, t0.avatar AS avatar_15, t0.device_token AS device_token_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.pays_id AS pays_id_20 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5
]
4 0.05 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.langue AS langue_3, t0.nom AS nom_4, t0.description AS description_5, t0.icone AS icone_6, t0.points AS points_7, t0.etapes AS etapes_8, t0.cta_label AS cta_label_9, t0.ordre_affichage AS ordre_affichage_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM service t0 WHERE t0.id = ?
Parameters:
[
  7
]
5 0.04 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.symbole AS symbole_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM devise t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.06 ms
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode_paiement AS mode_paiement_3, t0.statut AS statut_4, t0.fedapay_transaction_id AS fedapay_transaction_id_5, t0.preuve_paiement_url AS preuve_paiement_url_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.client_id AS client_id_10, t0.facture_id AS facture_id_11, t0.devise_id AS devise_id_12, t0.agent_id AS agent_id_13, t0.moyen_paiement_id AS moyen_paiement_id_14 FROM transaction t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.12 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.langue AS langue_3, t0.nom AS nom_4, t0.description AS description_5, t0.icone AS icone_6, t0.points AS points_7, t0.etapes AS etapes_8, t0.cta_label AS cta_label_9, t0.ordre_affichage AS ordre_affichage_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM service t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.04 ms
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode_paiement AS mode_paiement_3, t0.statut AS statut_4, t0.fedapay_transaction_id AS fedapay_transaction_id_5, t0.preuve_paiement_url AS preuve_paiement_url_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.client_id AS client_id_10, t0.facture_id AS facture_id_11, t0.devise_id AS devise_id_12, t0.agent_id AS agent_id_13, t0.moyen_paiement_id AS moyen_paiement_id_14 FROM transaction t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.langue AS langue_3, t0.nom AS nom_4, t0.description AS description_5, t0.icone AS icone_6, t0.points AS points_7, t0.etapes AS etapes_8, t0.cta_label AS cta_label_9, t0.ordre_affichage AS ordre_affichage_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM service t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.04 ms
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode_paiement AS mode_paiement_3, t0.statut AS statut_4, t0.fedapay_transaction_id AS fedapay_transaction_id_5, t0.preuve_paiement_url AS preuve_paiement_url_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.client_id AS client_id_10, t0.facture_id AS facture_id_11, t0.devise_id AS devise_id_12, t0.agent_id AS agent_id_13, t0.moyen_paiement_id AS moyen_paiement_id_14 FROM transaction t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\DemandeService 3
App\Entity\Service 3
App\Entity\Transaction 3
App\Entity\Facture 3
App\Entity\User 2
App\Entity\Pays 1
App\Entity\Devise 1
App\Entity\MoyenPaiement 1

Entities Mapping