Symfony Profiler

[
  "route" => "app_shop"
  "route_parameters" => [
    "_route" => "app_shop"
    "_controller" => "App\Controller\ShopController::Shop"
  ]
  "request_uri" => "https://www.elborj-elakwess.tn/decouvrir-nos-produits?fournisseur=Elborj&lang=fr"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "u346445600_steborj"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u346445600_steborj"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN categorie c1_ ON a0_.id_categorie = c1_.id LEFT JOIN sous_categorie s2_ ON a0_.id_souscategorie = s2_.id LEFT JOIN fournisseur f3_ ON a0_.id_fournisseur = f3_.id WHERE LOWER(a0_.marque) = LOWER(?) OR LOWER(f3_.libelle) = LOWER(?) OR LOWER(f3_.libarabe) = LOWER(?)"
  "params" => [
    1 => "Elborj"
    2 => "Elborj"
    3 => "Elborj"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1105
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1105}
    3 => Doctrine\DBAL\ParameterType {#1105}
  ]
]

[
  "sql" => "SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM article a0_ LEFT JOIN categorie c1_ ON a0_.id_categorie = c1_.id LEFT JOIN sous_categorie s2_ ON a0_.id_souscategorie = s2_.id LEFT JOIN fournisseur f3_ ON a0_.id_fournisseur = f3_.id WHERE LOWER(a0_.marque) = LOWER(?) OR LOWER(f3_.libelle) = LOWER(?) OR LOWER(f3_.libarabe) = LOWER(?) ORDER BY a0_.id DESC LIMIT 10"
  "params" => [
    1 => "Elborj"
    2 => "Elborj"
    3 => "Elborj"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1105
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1105}
    3 => Doctrine\DBAL\ParameterType {#1105}
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1242
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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 8"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1242
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN categorie c1_ ON a0_.id_categorie = c1_.id LEFT JOIN sous_categorie s2_ ON a0_.id_souscategorie = s2_.id LEFT JOIN fournisseur f3_ ON a0_.id_fournisseur = f3_.id WHERE LOWER(a0_.marque) = LOWER(?) OR LOWER(f3_.libelle) = LOWER(?) OR LOWER(f3_.libarabe) = LOWER(?)"
  "params" => [
    1 => "Elborj"
    2 => "Elborj"
    3 => "Elborj"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1105
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1105}
    3 => Doctrine\DBAL\ParameterType {#1105}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1295
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1295
      +name: "INTEGER"
    }
  ]
]