GET https://roicargoapi.secssarl.com/

Query Metrics

11 Database Queries
5 Different statements
1.84 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 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.langue = ? AND t0.is_active = ? ORDER BY t0.ordre_affichage ASC
Parameters:
[
  "fr"
  1
]
2 0.24 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.langue AS langue_3, t0.titre AS titre_4, t0.description AS description_5, t0.icone AS icone_6, t0.ordre_affichage AS ordre_affichage_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM avantage t0 WHERE t0.langue = ? AND t0.is_active = ? ORDER BY t0.ordre_affichage ASC
Parameters:
[
  "fr"
  1
]
3 0.24 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-21 23:29:44"
  "2026-07-21 23:29:44"
]
4 0.15 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
]
5 0.12 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
]
6 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:
[
  "lien_play_store"
  1
]
7 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
]
8 0.05 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:
[]
9 0.12 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
]
10 0.27 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
]
11 0.12 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\Service 6
App\Entity\InfoUtile 5
App\Entity\Avantage 4
App\Entity\ReseauSocial 4

Entities Mapping

Class Mapping errors
App\Entity\Service No errors.
App\Entity\Avantage No errors.
App\Entity\Publicite No errors.
App\Entity\InfoUtile No errors.
App\Entity\ReseauSocial No errors.