GET https://www.elborj-elakwess.tn/?lang=fr

Query Metrics

13 Database Queries
12 Different statements
2.88 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.40 ms
(13.74%)
1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.libelle AS libelle_2, c0_.libarabe AS libarabe_3, c0_.icon AS icon_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, s1_.id AS id_7, s1_.code AS code_8, s1_.libelle AS libelle_9, s1_.libarabe AS libarabe_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.categorie_id AS categorie_id_13 FROM categorie c0_ LEFT JOIN sous_categorie s1_ ON c0_.id = s1_.categorie_id ORDER BY c0_.libelle ASC, s1_.libelle ASC
Parameters:
[]
0.39 ms
(13.70%)
2
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libarabe AS libarabe_4, t0.description AS description_5, t0.marque AS marque_6, t0.image AS image_7, t0.largeimage AS largeimage_8, t0.reference AS reference_9, t0.nouveau AS nouveau_10, t0.disponible AS disponible_11, t0.enavant AS enavant_12, t0.promo AS promo_13, t0.tendance AS tendance_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.prix AS prix_17, t0.remise AS remise_18, t0.promo_type AS promo_type_19, t0.promo_qte_achetee AS promo_qte_achetee_20, t0.promo_qte_offerte AS promo_qte_offerte_21, t0.id_souscategorie AS id_souscategorie_22, t0.id_categorie AS id_categorie_23, t0.id_fournisseur AS id_fournisseur_24 FROM article t0 WHERE t0.id_fournisseur = ?
Parameters:
[
  3
]
0.31 ms
(10.65%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, c1_.id AS id_21, c1_.code AS code_22, c1_.libelle AS libelle_23, c1_.libarabe AS libarabe_24, c1_.icon AS icon_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, s2_.id AS id_28, s2_.code AS code_29, s2_.libelle AS libelle_30, s2_.libarabe AS libarabe_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, a0_.id_souscategorie AS id_souscategorie_34, a0_.id_categorie AS id_categorie_35, a0_.id_fournisseur AS id_fournisseur_36, s2_.categorie_id AS categorie_id_37 FROM article a0_ LEFT JOIN categorie c1_ ON a0_.id_categorie = c1_.id LEFT JOIN sous_categorie s2_ ON a0_.id_souscategorie = s2_.id ORDER BY a0_.created_at DESC, a0_.id DESC LIMIT 10
Parameters:
[]
0.29 ms
(10.08%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ LEFT JOIN sous_categorie s1_ ON a0_.id_souscategorie = s1_.id LEFT JOIN categorie c2_ ON s1_.categorie_id = c2_.id LEFT JOIN categorie c3_ ON a0_.id_categorie = c3_.id WHERE LOWER(c3_.libelle) = LOWER(?) OR LOWER(c3_.libarabe) = LOWER(?) OR LOWER(c2_.libelle) = LOWER(?) OR LOWER(c2_.libarabe) = LOWER(?)
Parameters:
[
  "cmo"
  "cmo"
  "cmo"
  "cmo"
]
0.27 ms
(9.49%)
1
SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.libarabe AS libarabe_2, p0_.description AS description_3, p0_.image AS image_4, p0_.remise_type AS remise_type_5, p0_.remise_value AS remise_value_6, p0_.actif AS actif_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.quantite AS quantite_11, a2_.id AS id_12, a2_.code AS code_13, a2_.libelle AS libelle_14, a2_.libarabe AS libarabe_15, a2_.description AS description_16, a2_.marque AS marque_17, a2_.image AS image_18, a2_.largeimage AS largeimage_19, a2_.reference AS reference_20, a2_.nouveau AS nouveau_21, a2_.disponible AS disponible_22, a2_.enavant AS enavant_23, a2_.promo AS promo_24, a2_.tendance AS tendance_25, a2_.created_at AS created_at_26, a2_.updated_at AS updated_at_27, a2_.prix AS prix_28, a2_.remise AS remise_29, a2_.promo_type AS promo_type_30, a2_.promo_qte_achetee AS promo_qte_achetee_31, a2_.promo_qte_offerte AS promo_qte_offerte_32, p0_.id_fournisseur AS id_fournisseur_33, p1_.pack_id AS pack_id_34, p1_.article_id AS article_id_35, a2_.id_souscategorie AS id_souscategorie_36, a2_.id_categorie AS id_categorie_37, a2_.id_fournisseur AS id_fournisseur_38 FROM pack p0_ LEFT JOIN pack_details p1_ ON p0_.id = p1_.pack_id LEFT JOIN article a2_ ON p1_.article_id = a2_.id WHERE p0_.actif = 1 ORDER BY p0_.created_at DESC
Parameters:
[]
0.22 ms
(7.54%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ WHERE a0_.enavant = ? ORDER BY a0_.created_at DESC LIMIT 5
Parameters:
[
  1
]
0.20 ms
(6.81%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ WHERE a0_.enavant = ? ORDER BY a0_.created_at DESC LIMIT 10
Parameters:
[
  1
]
0.17 ms
(5.84%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ WHERE a0_.nouveau = ? ORDER BY a0_.created_at DESC LIMIT 10
Parameters:
[
  1
]
0.17 ms
(5.77%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libarabe AS libarabe_3, t0.image AS image_4, t0.telephone AS telephone_5, t0.telephone2 AS telephone2_6, t0.email AS email_7, t0.about_text AS about_text_8, t0.facebook AS facebook_9, t0.instagram AS instagram_10, t0.linkedin AS linkedin_11, t0.adresse AS adresse_12, t0.maps_query AS maps_query_13, t0.horaire_semaine AS horaire_semaine_14, t0.horaire_samedi AS horaire_samedi_15, t0.horaire_dimanche AS horaire_dimanche_16, t0.created_at AS created_at_17 FROM fournisseur t0
Parameters:
[]
0.16 ms
(5.53%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ WHERE a0_.promo = ?
Parameters:
[
  1
]
0.16 ms
(5.46%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ WHERE a0_.tendance = ?
Parameters:
[
  1
]
0.15 ms
(5.39%)
1
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.libelle AS libelle_2, a0_.libarabe AS libarabe_3, a0_.description AS description_4, a0_.marque AS marque_5, a0_.image AS image_6, a0_.largeimage AS largeimage_7, a0_.reference AS reference_8, a0_.nouveau AS nouveau_9, a0_.disponible AS disponible_10, a0_.enavant AS enavant_11, a0_.promo AS promo_12, a0_.tendance AS tendance_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.prix AS prix_16, a0_.remise AS remise_17, a0_.promo_type AS promo_type_18, a0_.promo_qte_achetee AS promo_qte_achetee_19, a0_.promo_qte_offerte AS promo_qte_offerte_20, a0_.id_souscategorie AS id_souscategorie_21, a0_.id_categorie AS id_categorie_22, a0_.id_fournisseur AS id_fournisseur_23 FROM article a0_ ORDER BY a0_.created_at DESC LIMIT 3
Parameters:
[]

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\Pack 3
App\Entity\Fournisseur 2

Entities Mapping

Class Mapping errors
App\Entity\Categorie No errors.
App\Entity\SousCategorie No errors.
App\Entity\Article No errors.
App\Entity\Fournisseur No errors.
App\Entity\Pack No errors.
App\Entity\PackDetails No errors.