GET https://ep.proxisoft.ma/promotions?page=2

Query Metrics

20 Database Queries
4 Different statements
4.63 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0
Parameters:
[]
2 0.49 ms
SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18 FROM articles a0_ WHERE a0_.prix_promo > 0 AND a0_.prix_promo < a0_.prix_ttc AND a0_.etat = 1
Parameters:
[]
3 0.28 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  9
]
4 0.22 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
5 0.23 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
6 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
7 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  6
]
8 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
9 0.20 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  9
]
10 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
11 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  7
]
12 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
13 0.20 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
14 0.23 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
15 0.24 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  9
]
16 0.20 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
17 0.20 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  9
]
18 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
19 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  9
]
20 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = ? LIMIT 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.

Entities Mapping

Class Mapping errors
App\Entity\Categories No errors.
App\Entity\Articles No errors.
App\Entity\SousCategories No errors.