Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.subcategory_id AS subcategory_id_3,
  t0.productname AS productname_4,
  t0.description AS description_5,
  t0.retailprice AS retailprice_6,
  t0.wholesaleprice AS wholesaleprice_7,
  t0.semiretailprice AS semiretailprice_8,
  t0.image AS image_9,
  t0.status AS status_10,
  t0.category_id AS category_id_11,
  t0.subcategory_id AS subcategory_id_12
FROM
  products t0
WHERE
  t0.status = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.subcategory_id AS subcategory_id_3, t0.productname AS productname_4, t0.description AS description_5, t0.retailprice AS retailprice_6, t0.wholesaleprice AS wholesaleprice_7, t0.semiretailprice AS semiretailprice_8, t0.image AS image_9, t0.status AS status_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12 FROM products t0 WHERE t0.status = 1 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.province_id AS province_id_3
FROM
  city t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.province_id AS province_id_3 FROM city t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  province t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM province t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  categorie t0
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.name AS name_2 FROM categorie t0 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.category_id AS category_id_5
FROM
  subcategorie t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.name AS name_3, t0.status AS status_4, t0.category_id AS category_id_5 FROM subcategorie t0 WHERE t0.status = '1';