Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.label AS label_2,
  s0_.active AS active_3,
  s0_.created AS created_4,
  s0_.updated AS updated_5,
  s0_.address AS address_6,
  s0_.city AS city_7,
  s0_.codepostal AS codepostal_8,
  s0_.phone AS phone_9,
  s0_.mobile AS mobile_10,
  s0_.country AS country_11,
  s0_.logo AS logo_12,
  s0_.description AS description_13,
  s0_.email AS email_14,
  s0_.seotitle AS seotitle_15,
  s0_.seodescription AS seodescription_16,
  s0_.shop AS shop_17
FROM
  store s0_
WHERE
  s0_.active = 1
ORDER BY
  s0_.created ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.label AS label_2, s0_.active AS active_3, s0_.created AS created_4, s0_.updated AS updated_5, s0_.address AS address_6, s0_.city AS city_7, s0_.codepostal AS codepostal_8, s0_.phone AS phone_9, s0_.mobile AS mobile_10, s0_.country AS country_11, s0_.logo AS logo_12, s0_.description AS description_13, s0_.email AS email_14, s0_.seotitle AS seotitle_15, s0_.seodescription AS seodescription_16, s0_.shop AS shop_17 FROM store s0_ WHERE s0_.active = 1 ORDER BY s0_.created ASC;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.label AS label_2,
  p0_.price AS price_3,
  p0_.active AS active_4,
  p0_.created AS created_5,
  p0_.updated AS updated_6,
  p0_.description AS description_7,
  p0_.sku AS sku_8,
  p0_.dimension AS dimension_9,
  p0_.detail AS detail_10,
  p0_.quantity AS quantity_11,
  p0_.homepage AS homepage_12,
  p0_.codeurl AS codeurl_13,
  p0_.sort AS sort_14,
  p0_.category_id AS category_id_15,
  p0_.store_id AS store_id_16,
  p0_.secondcategory_id AS secondcategory_id_17,
  p0_.thirdcategory_id AS thirdcategory_id_18,
  p0_.family_id AS family_id_19
FROM
  product p0_
  INNER JOIN store s1_ ON p0_.store_id = s1_.id
WHERE
  p0_.active = ?
  AND p0_.homepage = ?
ORDER BY
  p0_.sort ASC,
  p0_.code ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.label AS label_2, p0_.price AS price_3, p0_.active AS active_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.description AS description_7, p0_.sku AS sku_8, p0_.dimension AS dimension_9, p0_.detail AS detail_10, p0_.quantity AS quantity_11, p0_.homepage AS homepage_12, p0_.codeurl AS codeurl_13, p0_.sort AS sort_14, p0_.category_id AS category_id_15, p0_.store_id AS store_id_16, p0_.secondcategory_id AS secondcategory_id_17, p0_.thirdcategory_id AS thirdcategory_id_18, p0_.family_id AS family_id_19 FROM product p0_ INNER JOIN store s1_ ON p0_.store_id = s1_.id WHERE p0_.active = 1 AND p0_.homepage = 1 ORDER BY p0_.sort ASC, p0_.code ASC;

SELECT
  c0_.id AS id_0,
  c0_.label AS label_1,
  c0_.updated AS updated_2,
  c0_.sort AS sort_3
FROM
  category1 c0_
WHERE
  c0_.sort <> 50
ORDER BY
  c0_.sort ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.updated AS updated_2, c0_.sort AS sort_3 FROM category1 c0_ WHERE c0_.sort <> 50 ORDER BY c0_.sort ASC LIMIT 7;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category1_id AS category1_id_5
FROM
  category2 t0
WHERE
  t0.category1_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category1_id AS category1_id_5 FROM category2 t0 WHERE t0.category1_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 1) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 2) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 3) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 4) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 5) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 6) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 2 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 42) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 43) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 44) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 7) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 8) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 9) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 3 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 10) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 11) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 12) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 4 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 13) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 14) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 15) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 16) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 17) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 1) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 2) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 3) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 4) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 5) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.sort AS sort_6,
  t0.category3_id AS category3_id_7
FROM
  category t0
WHERE
  (
    t0.active = ?
    AND t0.category3_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = 1 AND t0.category3_id = 6) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.updated AS updated_3,
  t0.sort AS sort_4,
  t0.category2_id AS category2_id_5
FROM
  category3 t0
WHERE
  t0.category2_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = 1 ORDER BY t0.sort ASC;