Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.active AS active_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.address AS address_7,
  t0.city AS city_8,
  t0.codepostal AS codepostal_9,
  t0.phone AS phone_10,
  t0.mobile AS mobile_11,
  t0.country AS country_12,
  t0.logo AS logo_13,
  t0.description AS description_14,
  t0.email AS email_15,
  t0.seotitle AS seotitle_16,
  t0.seodescription AS seodescription_17,
  t0.shop AS shop_18
FROM
  store t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.active AS active_4, t0.created AS created_5, t0.updated AS updated_6, t0.address AS address_7, t0.city AS city_8, t0.codepostal AS codepostal_9, t0.phone AS phone_10, t0.mobile AS mobile_11, t0.country AS country_12, t0.logo AS logo_13, t0.description AS description_14, t0.email AS email_15, t0.seotitle AS seotitle_16, t0.seodescription AS seodescription_17, t0.shop AS shop_18 FROM store t0 WHERE t0.code = 'hometrends' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.price AS price_4,
  t0.active AS active_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.description AS description_8,
  t0.sku AS sku_9,
  t0.dimension AS dimension_10,
  t0.detail AS detail_11,
  t0.quantity AS quantity_12,
  t0.homepage AS homepage_13,
  t0.codeurl AS codeurl_14,
  t0.sort AS sort_15,
  t0.category_id AS category_id_16,
  t0.store_id AS store_id_17,
  t0.secondcategory_id AS secondcategory_id_18,
  t0.thirdcategory_id AS thirdcategory_id_19,
  t0.family_id AS family_id_20
FROM
  product t0
WHERE
  t0.store_id = ?
  AND t0.codeurl = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.price AS price_4, t0.active AS active_5, t0.created AS created_6, t0.updated AS updated_7, t0.description AS description_8, t0.sku AS sku_9, t0.dimension AS dimension_10, t0.detail AS detail_11, t0.quantity AS quantity_12, t0.homepage AS homepage_13, t0.codeurl AS codeurl_14, t0.sort AS sort_15, t0.category_id AS category_id_16, t0.store_id AS store_id_17, t0.secondcategory_id AS secondcategory_id_18, t0.thirdcategory_id AS thirdcategory_id_19, t0.family_id AS family_id_20 FROM product t0 WHERE t0.store_id = 2 AND t0.codeurl = 'komodo-5-piece-outdoor-sofa-set-114' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.active AS active_3,
  t0.sort AS sort_4,
  t0.product_id AS product_id_5
FROM
  product_image t0
WHERE
  (
    t0.active = ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.active AS active_3, t0.sort AS sort_4, t0.product_id AS product_id_5 FROM product_image t0 WHERE (t0.active = 1 AND t0.product_id = 114) ORDER BY t0.sort 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;