Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_controller" => "App\Controller\HomeController::index"
    "_locale" => "en"
  ]
  "request_uri" => "https://istanbuldiamonds.com/en"
  "method" => "GET"
]

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

[
  "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" => "127.0.0.1"
    "port" => 3306
    "user" => "u2236156_istdiamond"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "u2236156_istdiamond"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.lang AS lang_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5, t0.about AS about_6, t0.contact AS contact_7 FROM setting_lang t0 WHERE t0.lang = ? ORDER BY t0.id ASC LIMIT 1"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#978
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.lang AS lang_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5, t0.category_id AS category_id_6 FROM category_lang t0 WHERE t0.lang = ?"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#978
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.pcode AS pcode_1, p0_.image AS image_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.metal AS metal_5, p0_.weight AS weight_6, p0_.user_id AS user_id_7, p0_.status AS status_8, p0_.campaign AS campaign_9, COALESCE(p1_.title, p2_.title) AS sclr_10, COALESCE(p1_.description, p2_.description) AS sclr_11, p0_.pcode AS pcode_12, p0_.image AS image_13, p0_.price AS price_14, p0_.quantity AS quantity_15, p0_.metal AS metal_16, p0_.id AS id_17, p0_.status AS status_18, p0_.category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_.id = p1_.product_id AND (p1_.lang = ?) LEFT JOIN product_lang p2_ ON p0_.id = p2_.product_id AND (p2_.lang = ?) WHERE p0_.status = 1 LIMIT 12"
  "params" => [
    1 => "en"
    2 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#978
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#978}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.pcode AS pcode_1, p0_.image AS image_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.metal AS metal_5, p0_.weight AS weight_6, p0_.user_id AS user_id_7, p0_.status AS status_8, p0_.campaign AS campaign_9, COALESCE(p1_.title, p2_.title) AS sclr_10, COALESCE(p1_.description, p2_.description) AS sclr_11, p0_.pcode AS pcode_12, p0_.image AS image_13, p0_.price AS price_14, p0_.quantity AS quantity_15, p0_.metal AS metal_16, p0_.id AS id_17, p0_.status AS status_18, p0_.category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_.id = p1_.product_id AND (p1_.lang = ?) LEFT JOIN product_lang p2_ ON p0_.id = p2_.product_id AND (p2_.lang = ?) WHERE p0_.status = 1 LIMIT 12"
  "params" => [
    1 => "en"
    2 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#978
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#978}
  ]
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id is NULL AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 23  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 7  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 11  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 2  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 12  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 1  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 3  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 13  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id is NULL AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 23  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 7  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 11  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 2  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 12  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 1  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 3  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 13  AND c.status=1 ORDER BY cl.title ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#975
      +name: "INTEGER"
    }
  ]
]