GET https://roicargoapi.secssarl.com/a-propos?locale=fr

Query Metrics

12 Database Queries
6 Different statements
1.73 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.29 ms
SELECT t0.id AS id_1, t0.ville_destination AS ville_destination_2, t0.type_trafic AS type_trafic_3, t0.duree_estimee_jours AS duree_estimee_jours_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.entrepot_origine_id AS entrepot_origine_id_8, t0.pays_destination_id AS pays_destination_id_9 FROM route t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
2 0.30 ms
SELECT p0_.id AS id_0, p0_.image_url AS image_url_1, p0_.message AS message_2, p0_.message_en AS message_en_3, p0_.lien AS lien_4, p0_.position AS position_5, p0_.date_debut AS date_debut_6, p0_.date_fin AS date_fin_7, p0_.is_active AS is_active_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM publicite p0_ WHERE p0_.is_active = ? AND (p0_.date_debut IS NULL OR p0_.date_debut <= ?) AND (p0_.date_fin IS NULL OR p0_.date_fin >= ?) ORDER BY p0_.position ASC
Parameters:
[
  1
  "2026-07-22 05:38:31"
  "2026-07-22 05:38:31"
]
3 0.05 ms
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "lien_play_store"
  1
]
4 0.03 ms
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "lien_app_store"
  1
]
5 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.pays_id AS pays_id_7 FROM entrepot t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.nom_en AS nom_en_4, t0.flag AS flag_5, t0.flag_url AS flag_url_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.50 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.nom_en AS nom_en_4, t0.flag AS flag_5, t0.flag_url AS flag_url_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.pays_id AS pays_id_7 FROM entrepot t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.06 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.icone AS icone_4, t0.ordre_affichage AS ordre_affichage_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM reseau_social t0 ORDER BY t0.ordre_affichage ASC
Parameters:
[]
10 0.04 ms
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "whatsapp_principal"
  1
]
11 0.03 ms
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "email_contact"
  1
]
12 0.03 ms
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "numero_apdp"
  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\Route 6
App\Entity\InfoUtile 5
App\Entity\ReseauSocial 4
App\Entity\Pays 3
App\Entity\Entrepot 2

Entities Mapping

Class Mapping errors
App\Entity\Route No errors.
App\Entity\Entrepot No errors.
App\Entity\Pays No errors.
App\Entity\Publicite No errors.
App\Entity\InfoUtile No errors.
App\Entity\ReseauSocial No errors.