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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.65 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.89 ms
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2, p0_.isactif AS isactif_3, p0_.region_id AS region_id_4 FROM prefecture p0_ INNER JOIN region r1_ ON (p0_.region_id = r1_.id) WHERE p0_.region_id = ? AND p0_.isactif = 1
Parameters:
[
  "2"
]

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.