GET https://roicargoapi.secssarl.com/tarifs

Query Metrics

16 Database Queries
9 Different statements
2.82 ms Query time
0 Invalid entities
29 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.68 ms
(59.58%)
1
SELECT t0.id AS id_1, t0.type_trafic AS type_trafic_2, t0.unite AS unite_3, t0.prix AS prix_4, t0.date_mise_a_jour AS date_mise_a_jour_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_id AS route_id_8, t0.categorie_id AS categorie_id_9, t0.devise_id AS devise_id_10 FROM tarif t0 WHERE t0.route_id = ? AND t0.type_trafic = ?
Parameters:
[
  1
  "aerien"
]
0.33 ms
(11.55%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.nom_en AS nom_en_4, t0.description_en AS description_en_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM categorie_marchandise t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
0.23 ms
(8.32%)
3
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
]
0.18 ms
(6.54%)
5
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
]
0.11 ms
(3.75%)
1
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
]
0.10 ms
(3.51%)
1
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
]
0.07 ms
(2.55%)
1
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:
[]
0.06 ms
(2.26%)
2
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
]
0.06 ms
(1.95%)
1
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 02:35:45"
  "2026-07-22 02:35:45"
]

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\CategorieMarchandise 4
App\Entity\Tarif 4
App\Entity\ReseauSocial 4
App\Entity\Pays 3
App\Entity\Entrepot 2
App\Entity\Devise 1

Entities Mapping

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