POST https://synergui.apipguinee.com/ajax-get-sous-prefecture-by-prefecture

Query Metrics

2 Database Queries
2 Different statements
1.50 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.account_must_be_verified_before AS account_must_be_verified_before_8, t0.registration_token AS registration_token_9, t0.is_verified AS is_verified_10, t0.account_verified_at AS account_verified_at_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13, t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14, t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15, t0.password AS password_16, t0.nom AS nom_17, t0.prenom AS prenom_18, t0.numero_piece_identite AS numero_piece_identite_19, t0.ville AS ville_20, t0.last_login AS last_login_21, t0.last_logout AS last_logout_22, t0.is_first_login AS is_first_login_23, t0.username AS username_24, t0.signature_file_name AS signature_file_name_25, t0.code_pin AS code_pin_26, t0.signataire_id AS signataire_id_27, t0.appelant_id AS appelant_id_28, t0.kyc_piece1 AS kyc_piece1_29, t0.kyc_piece2 AS kyc_piece2_30, t0.kyc_photo AS kyc_photo_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.civilite_id AS civilite_id_34, t0.piece_itendite_id AS piece_itendite_id_35, t0.pays_id AS pays_id_36, t0.service_id AS service_id_37, t0.role_id AS role_id_38, t0.banque_id AS banque_id_39 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
  200
]
2 0.78 ms
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.libelle AS libelle_2, s0_.isactif AS isactif_3, s0_.prefecture_id AS prefecture_id_4 FROM sous_prefecture s0_ INNER JOIN prefecture p1_ ON (p1_.id = s0_.prefecture_id) WHERE s0_.prefecture_id = ? AND s0_.isactif = 1
Parameters:
[
  "48"
]

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.