Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_entered AS date_entered_3,
  t0.date_modified AS date_modified_4,
  t0.description AS description_5,
  t0.code1c AS code1c_6,
  t0.barcode AS barcode_7,
  t0.status AS status_8,
  t0.price AS price_9,
  t0.price_income AS price_income_10,
  t0.mark_up AS mark_up_11,
  t0.min_mark_up AS min_mark_up_12,
  t0.packing_type AS packing_type_13,
  t0.packing_type_count AS packing_type_count_14,
  t0.discounts AS discounts_15,
  t0.count_order AS count_order_16,
  t0.product_to_order AS product_to_order_17,
  t0.article AS article_18,
  t0.nds AS nds_19,
  t0.service AS service_20,
  t0.transport_service AS transport_service_21,
  t0.exise AS exise_22,
  t0.expiration_date AS expiration_date_23,
  t0.unit_volume AS unit_volume_24,
  t0.net_weight AS net_weight_25,
  t0.gross_weight AS gross_weight_26,
  t0.go_by_weight AS go_by_weight_27,
  t0.packaging AS packaging_28,
  t0.old_code AS old_code_29,
  t0.show AS show_30,
  t0.balance AS balance_31,
  t0.deleted AS deleted_32,
  t0.category_cnt AS category_cnt_33,
  t0.price_category AS price_category_34,
  t0.is_salle AS is_salle_35,
  t0.is_new AS is_new_36,
  t0.is_top AS is_top_37,
  t0.old_price AS old_price_38,
  t0.discount_percent AS discount_percent_39,
  t0.video AS video_40,
  t0.is_video AS is_video_41,
  t0.is_free_shipping AS is_free_shipping_42,
  t0.warranty_period AS warranty_period_43,
  t0.min_balance AS min_balance_44,
  t0.min_balance_admin AS min_balance_admin_45,
  t0.main_category_id AS main_category_id_46,
  t0.modified_user_id AS modified_user_id_47,
  t0.created_by_id AS created_by_id_48,
  t0.measurement_unit_id AS measurement_unit_id_49,
  t0.site_product_id AS site_product_id_50,
  t0.storage_id AS storage_id_51,
  t0.storage_element_id AS storage_element_id_52,
  t0.language_id AS language_id_53,
  t0.translations_id AS translations_id_54,
  t0.main_media_id AS main_media_id_55,
  t0.main_media_hover_id AS main_media_hover_id_56
FROM
  products t0
WHERE
  t0.show = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_entered AS date_entered_3, t0.date_modified AS date_modified_4, t0.description AS description_5, t0.code1c AS code1c_6, t0.barcode AS barcode_7, t0.status AS status_8, t0.price AS price_9, t0.price_income AS price_income_10, t0.mark_up AS mark_up_11, t0.min_mark_up AS min_mark_up_12, t0.packing_type AS packing_type_13, t0.packing_type_count AS packing_type_count_14, t0.discounts AS discounts_15, t0.count_order AS count_order_16, t0.product_to_order AS product_to_order_17, t0.article AS article_18, t0.nds AS nds_19, t0.service AS service_20, t0.transport_service AS transport_service_21, t0.exise AS exise_22, t0.expiration_date AS expiration_date_23, t0.unit_volume AS unit_volume_24, t0.net_weight AS net_weight_25, t0.gross_weight AS gross_weight_26, t0.go_by_weight AS go_by_weight_27, t0.packaging AS packaging_28, t0.old_code AS old_code_29, t0.show AS show_30, t0.balance AS balance_31, t0.deleted AS deleted_32, t0.category_cnt AS category_cnt_33, t0.price_category AS price_category_34, t0.is_salle AS is_salle_35, t0.is_new AS is_new_36, t0.is_top AS is_top_37, t0.old_price AS old_price_38, t0.discount_percent AS discount_percent_39, t0.video AS video_40, t0.is_video AS is_video_41, t0.is_free_shipping AS is_free_shipping_42, t0.warranty_period AS warranty_period_43, t0.min_balance AS min_balance_44, t0.min_balance_admin AS min_balance_admin_45, t0.main_category_id AS main_category_id_46, t0.modified_user_id AS modified_user_id_47, t0.created_by_id AS created_by_id_48, t0.measurement_unit_id AS measurement_unit_id_49, t0.site_product_id AS site_product_id_50, t0.storage_id AS storage_id_51, t0.storage_element_id AS storage_element_id_52, t0.language_id AS language_id_53, t0.translations_id AS translations_id_54, t0.main_media_id AS main_media_id_55, t0.main_media_hover_id AS main_media_hover_id_56 FROM products t0 WHERE t0.show = 1;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29166;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29144;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29176;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29210;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29143;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29134;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29180;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29184;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29172;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29168;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29169;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29140;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29186;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29171;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29133;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29138;

SELECT
  t0.id AS id_1,
  t0.date_entered AS date_entered_2,
  t0.date_modified AS date_modified_3,
  t0.created_by AS created_by_4,
  t0.modified_user_id AS modified_user_id_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.status AS status_8,
  t0.description AS description_9,
  t0.main AS main_10,
  t0.type AS type_11,
  t0.product_cnt AS product_cnt_12,
  t0.site_product_cnt AS site_product_cnt_13,
  t0.sort AS sort_14,
  t0.parent_id AS parent_id_15,
  t0.media_id AS media_id_16
FROM
  category t0
  INNER JOIN products_category ON t0.id = products_category.category_id
WHERE
  products_category.products_id = ?

SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = 29150;