Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.vat AS vat_4,
  t0.fiscal_code AS fiscal_code_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.city AS city_8,
  t0.country AS country_9,
  t0.email AS email_10,
  t0.phone AS phone_11,
  t0.website AS website_12,
  t0.logo_path AS logo_path_13,
  t0.directory_name AS directory_name_14,
  t0.warranty_email AS warranty_email_15,
  t16.id AS id_17,
  t16.logo_path AS logo_path_18,
  t16.splash_path AS splash_path_19,
  t16.color_splash_back AS color_splash_back_20,
  t16.color_back AS color_back_21,
  t16.brand_id AS brand_id_22
FROM
  prim_brand t0
  LEFT JOIN prim_application t16 ON t16.brand_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.vat AS vat_4, t0.fiscal_code AS fiscal_code_5, t0.address AS address_6, t0.zip AS zip_7, t0.city AS city_8, t0.country AS country_9, t0.email AS email_10, t0.phone AS phone_11, t0.website AS website_12, t0.logo_path AS logo_path_13, t0.directory_name AS directory_name_14, t0.warranty_email AS warranty_email_15, t16.id AS id_17, t16.logo_path AS logo_path_18, t16.splash_path AS splash_path_19, t16.color_splash_back AS color_splash_back_20, t16.color_back AS color_back_21, t16.brand_id AS brand_id_22 FROM prim_brand t0 LEFT JOIN prim_application t16 ON t16.brand_id = t0.id WHERE t0.id = '98' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.client AS client_2,
          p0_.type AS type_3,
          p0_.start_date AS start_date_4,
          p0_.end_date AS end_date_5,
          p0_.details AS details_6,
          p0_.is_single_piece_managed AS is_single_piece_managed_7,
          p0_.is_external_code_application AS is_external_code_application_8,
          p0_.iqp_num AS iqp_num_9,
          p0_.pieces_for_box AS pieces_for_box_10,
          p0_.boxes_for_pallet AS boxes_for_pallet_11,
          p0_.pieces_for_pallet AS pieces_for_pallet_12,
          p0_.pallet_type AS pallet_type_13,
          p0_.pallet_weight AS pallet_weight_14,
          p0_.pallet_width AS pallet_width_15,
          p0_.pallet_depth AS pallet_depth_16,
          p0_.pallet_height AS pallet_height_17,
          p0_.box_weight AS box_weight_18,
          p0_.box_width AS box_width_19,
          p0_.box_depth AS box_depth_20,
          p0_.box_height AS box_height_21
        FROM
          prim_warehouse_production_order p0_
          LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
          LEFT JOIN prim_catalogue_product p2_ ON p0_.product_id = p2_.id
          LEFT JOIN prim_catalogue_product_detail p3_ ON p2_.id = p3_.product_id
        WHERE
          p1_.brand_id = ?
        ORDER BY
          p0_.start_date ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.client AS client_2, p0_.type AS type_3, p0_.start_date AS start_date_4, p0_.end_date AS end_date_5, p0_.details AS details_6, p0_.is_single_piece_managed AS is_single_piece_managed_7, p0_.is_external_code_application AS is_external_code_application_8, p0_.iqp_num AS iqp_num_9, p0_.pieces_for_box AS pieces_for_box_10, p0_.boxes_for_pallet AS boxes_for_pallet_11, p0_.pieces_for_pallet AS pieces_for_pallet_12, p0_.pallet_type AS pallet_type_13, p0_.pallet_weight AS pallet_weight_14, p0_.pallet_width AS pallet_width_15, p0_.pallet_depth AS pallet_depth_16, p0_.pallet_height AS pallet_height_17, p0_.box_weight AS box_weight_18, p0_.box_width AS box_width_19, p0_.box_depth AS box_depth_20, p0_.box_height AS box_height_21 FROM prim_warehouse_production_order p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p0_.product_id = p2_.id LEFT JOIN prim_catalogue_product_detail p3_ ON p2_.id = p3_.product_id WHERE p1_.brand_id = '98' ORDER BY p0_.start_date ASC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.client AS client_2,
  p0_.type AS type_3,
  p0_.start_date AS start_date_4,
  p0_.end_date AS end_date_5,
  p0_.details AS details_6,
  p0_.is_single_piece_managed AS is_single_piece_managed_7,
  p0_.is_external_code_application AS is_external_code_application_8,
  p0_.iqp_num AS iqp_num_9,
  p0_.pieces_for_box AS pieces_for_box_10,
  p0_.boxes_for_pallet AS boxes_for_pallet_11,
  p0_.pieces_for_pallet AS pieces_for_pallet_12,
  p0_.pallet_type AS pallet_type_13,
  p0_.pallet_weight AS pallet_weight_14,
  p0_.pallet_width AS pallet_width_15,
  p0_.pallet_depth AS pallet_depth_16,
  p0_.pallet_height AS pallet_height_17,
  p0_.box_weight AS box_weight_18,
  p0_.box_width AS box_width_19,
  p0_.box_depth AS box_depth_20,
  p0_.box_height AS box_height_21,
  p0_.status_id AS status_id_22,
  p0_.iqc_code_id AS iqc_code_id_23,
  p0_.product_id AS product_id_24
FROM
  prim_warehouse_production_order p0_
  LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
  LEFT JOIN prim_catalogue_product p2_ ON p0_.product_id = p2_.id
  LEFT JOIN prim_catalogue_product_detail p3_ ON p2_.id = p3_.product_id
WHERE
  p1_.brand_id = ?
ORDER BY
  p0_.start_date ASC
LIMIT
  15

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.client AS client_2, p0_.type AS type_3, p0_.start_date AS start_date_4, p0_.end_date AS end_date_5, p0_.details AS details_6, p0_.is_single_piece_managed AS is_single_piece_managed_7, p0_.is_external_code_application AS is_external_code_application_8, p0_.iqp_num AS iqp_num_9, p0_.pieces_for_box AS pieces_for_box_10, p0_.boxes_for_pallet AS boxes_for_pallet_11, p0_.pieces_for_pallet AS pieces_for_pallet_12, p0_.pallet_type AS pallet_type_13, p0_.pallet_weight AS pallet_weight_14, p0_.pallet_width AS pallet_width_15, p0_.pallet_depth AS pallet_depth_16, p0_.pallet_height AS pallet_height_17, p0_.box_weight AS box_weight_18, p0_.box_width AS box_width_19, p0_.box_depth AS box_depth_20, p0_.box_height AS box_height_21, p0_.status_id AS status_id_22, p0_.iqc_code_id AS iqc_code_id_23, p0_.product_id AS product_id_24 FROM prim_warehouse_production_order p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_catalogue_product p2_ ON p0_.product_id = p2_.id LEFT JOIN prim_catalogue_product_detail p3_ ON p2_.id = p3_.product_id WHERE p1_.brand_id = '98' ORDER BY p0_.start_date ASC LIMIT 15;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.date AS date_1,
          p0_.status AS status_2,
          p0_.type AS type_3,
          p0_.qty AS qty_4,
          p0_.send_type AS send_type_5,
          p0_.number AS number_6,
          p0_.ddt AS ddt_7
        FROM
          prim_warehouse_transfer p0_
          LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
          LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id
          LEFT JOIN prim_catalogue_product p3_ ON p2_.product_id = p3_.id
          LEFT JOIN prim_catalogue_product_detail p4_ ON p3_.id = p4_.product_id
          LEFT JOIN prim_warehouse_external_source p5_ ON p0_.external_source_id = p5_.id
        WHERE
          p1_.brand_id = ?
        ORDER BY
          p0_.date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.status AS status_2, p0_.type AS type_3, p0_.qty AS qty_4, p0_.send_type AS send_type_5, p0_.number AS number_6, p0_.ddt AS ddt_7 FROM prim_warehouse_transfer p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id LEFT JOIN prim_catalogue_product p3_ ON p2_.product_id = p3_.id LEFT JOIN prim_catalogue_product_detail p4_ ON p3_.id = p4_.product_id LEFT JOIN prim_warehouse_external_source p5_ ON p0_.external_source_id = p5_.id WHERE p1_.brand_id = '98' ORDER BY p0_.date DESC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.status AS status_2,
  p0_.type AS type_3,
  p0_.qty AS qty_4,
  p0_.send_type AS send_type_5,
  p0_.number AS number_6,
  p0_.ddt AS ddt_7,
  p0_.iqc_code_id AS iqc_code_id_8,
  p0_.external_source_id AS external_source_id_9
FROM
  prim_warehouse_transfer p0_
  LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
  LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id
  LEFT JOIN prim_catalogue_product p3_ ON p2_.product_id = p3_.id
  LEFT JOIN prim_catalogue_product_detail p4_ ON p3_.id = p4_.product_id
  LEFT JOIN prim_warehouse_external_source p5_ ON p0_.external_source_id = p5_.id
WHERE
  p1_.brand_id = ?
ORDER BY
  p0_.date DESC
LIMIT
  15

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.status AS status_2, p0_.type AS type_3, p0_.qty AS qty_4, p0_.send_type AS send_type_5, p0_.number AS number_6, p0_.ddt AS ddt_7, p0_.iqc_code_id AS iqc_code_id_8, p0_.external_source_id AS external_source_id_9 FROM prim_warehouse_transfer p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id LEFT JOIN prim_catalogue_product p3_ ON p2_.product_id = p3_.id LEFT JOIN prim_catalogue_product_detail p4_ ON p3_.id = p4_.product_id LEFT JOIN prim_warehouse_external_source p5_ ON p0_.external_source_id = p5_.id WHERE p1_.brand_id = '98' ORDER BY p0_.date DESC LIMIT 15;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.is_active AS is_active_1,
          p0_.value AS value_2,
          p0_.rfid AS rfid_3,
          p0_.json_msg AS json_msg_4,
          p0_.creation_date AS creation_date_5,
          p0_.gs1_value AS gs1_value_6,
          p0_.in_stock AS in_stock_7
        FROM
          prim_iqp_code p0_
          LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
          LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id
          LEFT JOIN prim_iqb_code p3_ ON p0_.iqb_code_id = p3_.id
          LEFT JOIN prim_brand p4_ ON p3_.brand_id = p4_.id
          LEFT JOIN prim_catalogue_product p5_ ON p3_.id = p5_.iqb_code_id
          LEFT JOIN prim_catalogue_product_detail p6_ ON p5_.id = p6_.product_id
          LEFT JOIN prim_warehouse_box p7_ ON p0_.box_id = p7_.id
          LEFT JOIN prim_iqs_code p8_ ON p7_.iqs_code_id = p8_.id
          LEFT JOIN prim_warehouse_pallet p9_ ON p0_.pallet_id = p9_.id
          LEFT JOIN prim_iqe_code p10_ ON p9_.iqe_code_id = p10_.id
          LEFT JOIN prim_warehouse_transfer p11_ ON p0_.transfer_exit_id = p11_.id
        WHERE
          p4_.id = ?
          AND p0_.iqc_code_id IS NOT NULL
          AND (
            p0_.transfer_exit_id IS NULL
            OR p11_.status <> 'sended'
          )
        ORDER BY
          p0_.creation_date DESC,
          p0_.value ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.value AS value_2, p0_.rfid AS rfid_3, p0_.json_msg AS json_msg_4, p0_.creation_date AS creation_date_5, p0_.gs1_value AS gs1_value_6, p0_.in_stock AS in_stock_7 FROM prim_iqp_code p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id LEFT JOIN prim_iqb_code p3_ ON p0_.iqb_code_id = p3_.id LEFT JOIN prim_brand p4_ ON p3_.brand_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p3_.id = p5_.iqb_code_id LEFT JOIN prim_catalogue_product_detail p6_ ON p5_.id = p6_.product_id LEFT JOIN prim_warehouse_box p7_ ON p0_.box_id = p7_.id LEFT JOIN prim_iqs_code p8_ ON p7_.iqs_code_id = p8_.id LEFT JOIN prim_warehouse_pallet p9_ ON p0_.pallet_id = p9_.id LEFT JOIN prim_iqe_code p10_ ON p9_.iqe_code_id = p10_.id LEFT JOIN prim_warehouse_transfer p11_ ON p0_.transfer_exit_id = p11_.id WHERE p4_.id = '98' AND p0_.iqc_code_id IS NOT NULL AND (p0_.transfer_exit_id IS NULL OR p11_.status <> 'sended') ORDER BY p0_.creation_date DESC, p0_.value ASC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.value AS value_2,
  p0_.rfid AS rfid_3,
  p0_.json_msg AS json_msg_4,
  p0_.creation_date AS creation_date_5,
  p0_.gs1_value AS gs1_value_6,
  p0_.in_stock AS in_stock_7,
  p0_.iqb_code_id AS iqb_code_id_8,
  p0_.iqc_code_id AS iqc_code_id_9,
  p0_.box_id AS box_id_10,
  p0_.pallet_id AS pallet_id_11,
  p0_.transfer_entrance_id AS transfer_entrance_id_12,
  p0_.transfer_exit_id AS transfer_exit_id_13
FROM
  prim_iqp_code p0_
  LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id
  LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id
  LEFT JOIN prim_iqb_code p3_ ON p0_.iqb_code_id = p3_.id
  LEFT JOIN prim_brand p4_ ON p3_.brand_id = p4_.id
  LEFT JOIN prim_catalogue_product p5_ ON p3_.id = p5_.iqb_code_id
  LEFT JOIN prim_catalogue_product_detail p6_ ON p5_.id = p6_.product_id
  LEFT JOIN prim_warehouse_box p7_ ON p0_.box_id = p7_.id
  LEFT JOIN prim_iqs_code p8_ ON p7_.iqs_code_id = p8_.id
  LEFT JOIN prim_warehouse_pallet p9_ ON p0_.pallet_id = p9_.id
  LEFT JOIN prim_iqe_code p10_ ON p9_.iqe_code_id = p10_.id
  LEFT JOIN prim_warehouse_transfer p11_ ON p0_.transfer_exit_id = p11_.id
WHERE
  p4_.id = ?
  AND p0_.iqc_code_id IS NOT NULL
  AND (
    p0_.transfer_exit_id IS NULL
    OR p11_.status <> 'sended'
  )
ORDER BY
  p0_.creation_date DESC,
  p0_.value ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.value AS value_2, p0_.rfid AS rfid_3, p0_.json_msg AS json_msg_4, p0_.creation_date AS creation_date_5, p0_.gs1_value AS gs1_value_6, p0_.in_stock AS in_stock_7, p0_.iqb_code_id AS iqb_code_id_8, p0_.iqc_code_id AS iqc_code_id_9, p0_.box_id AS box_id_10, p0_.pallet_id AS pallet_id_11, p0_.transfer_entrance_id AS transfer_entrance_id_12, p0_.transfer_exit_id AS transfer_exit_id_13 FROM prim_iqp_code p0_ LEFT JOIN prim_iqc_code p1_ ON p0_.iqc_code_id = p1_.id LEFT JOIN prim_warehouse_production_order p2_ ON p1_.id = p2_.iqc_code_id LEFT JOIN prim_iqb_code p3_ ON p0_.iqb_code_id = p3_.id LEFT JOIN prim_brand p4_ ON p3_.brand_id = p4_.id LEFT JOIN prim_catalogue_product p5_ ON p3_.id = p5_.iqb_code_id LEFT JOIN prim_catalogue_product_detail p6_ ON p5_.id = p6_.product_id LEFT JOIN prim_warehouse_box p7_ ON p0_.box_id = p7_.id LEFT JOIN prim_iqs_code p8_ ON p7_.iqs_code_id = p8_.id LEFT JOIN prim_warehouse_pallet p9_ ON p0_.pallet_id = p9_.id LEFT JOIN prim_iqe_code p10_ ON p9_.iqe_code_id = p10_.id LEFT JOIN prim_warehouse_transfer p11_ ON p0_.transfer_exit_id = p11_.id WHERE p4_.id = '98' AND p0_.iqc_code_id IS NOT NULL AND (p0_.transfer_exit_id IS NULL OR p11_.status <> 'sended') ORDER BY p0_.creation_date DESC, p0_.value ASC LIMIT 30;

SELECT
  p0_.id AS id_0,
  SUM(
    CASE WHEN p1_.iqc_code_id IS NOT NULL
    AND (
      p1_.transfer_exit_id IS NULL
      OR p2_.status <> 'sended'
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN p1_.iqc_code_id IS NOT NULL
    AND (
      p1_.transfer_exit_id IS NULL
      OR p2_.status <> 'sended'
    )
    AND (
      p1_.box_id IS NOT NULL
      OR p1_.pallet_id IS NOT NULL
    ) THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN p1_.iqc_code_id IS NOT NULL
    AND (
      p1_.transfer_exit_id IS NULL
      OR p2_.status <> 'sended'
    )
    AND p1_.box_id IS NULL
    AND p1_.pallet_id IS NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  SUM(
    CASE WHEN p1_.iqc_code_id IS NOT NULL
    AND (
      p1_.transfer_exit_id IS NULL
      OR p2_.status <> 'sended'
    )
    AND p1_.in_stock = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN p1_.iqc_code_id IS NOT NULL
    AND (
      p1_.transfer_exit_id IS NULL
      OR p2_.status <> 'sended'
    )
    AND p1_.in_stock = 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_5
FROM
  prim_iqp_code p1_
  INNER JOIN prim_iqb_code p3_ ON p1_.iqb_code_id = p3_.id
  INNER JOIN prim_catalogue_product p0_ ON p3_.id = p0_.iqb_code_id
  LEFT JOIN prim_warehouse_transfer p2_ ON p1_.transfer_exit_id = p2_.id
GROUP BY
  p0_.id
HAVING
  sclr_1 > 0

SELECT p0_.id AS id_0, SUM(CASE WHEN p1_.iqc_code_id IS NOT NULL AND (p1_.transfer_exit_id IS NULL OR p2_.status <> 'sended') THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN p1_.iqc_code_id IS NOT NULL AND (p1_.transfer_exit_id IS NULL OR p2_.status <> 'sended') AND (p1_.box_id IS NOT NULL OR p1_.pallet_id IS NOT NULL) THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN p1_.iqc_code_id IS NOT NULL AND (p1_.transfer_exit_id IS NULL OR p2_.status <> 'sended') AND p1_.box_id IS NULL AND p1_.pallet_id IS NULL THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN p1_.iqc_code_id IS NOT NULL AND (p1_.transfer_exit_id IS NULL OR p2_.status <> 'sended') AND p1_.in_stock = 1 THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN p1_.iqc_code_id IS NOT NULL AND (p1_.transfer_exit_id IS NULL OR p2_.status <> 'sended') AND p1_.in_stock = 0 THEN 1 ELSE 0 END) AS sclr_5 FROM prim_iqp_code p1_ INNER JOIN prim_iqb_code p3_ ON p1_.iqb_code_id = p3_.id INNER JOIN prim_catalogue_product p0_ ON p3_.id = p0_.iqb_code_id LEFT JOIN prim_warehouse_transfer p2_ ON p1_.transfer_exit_id = p2_.id GROUP BY p0_.id HAVING sclr_1 > 0;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '656' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '658' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '999' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '1144' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '1560' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_expirable AS is_expirable_3,
  t0.directory_path AS directory_path_4,
  t0.warranty_path AS warranty_path_5,
  t0.iqb_code_id AS iqb_code_id_6,
  t0.ean_code_id AS ean_code_id_7,
  t0.watermark_id AS watermark_id_8,
  t0.category_id AS category_id_9,
  t0.producer_id AS producer_id_10,
  t0.trademark_id AS trademark_id_11,
  t0.subcategory_1_id AS subcategory_1_id_12,
  t0.subcategory_2_id AS subcategory_2_id_13,
  t0.subcategory_3_id AS subcategory_3_id_14,
  t0.subcategory_4_id AS subcategory_4_id_15
FROM
  prim_catalogue_product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_expirable AS is_expirable_3, t0.directory_path AS directory_path_4, t0.warranty_path AS warranty_path_5, t0.iqb_code_id AS iqb_code_id_6, t0.ean_code_id AS ean_code_id_7, t0.watermark_id AS watermark_id_8, t0.category_id AS category_id_9, t0.producer_id AS producer_id_10, t0.trademark_id AS trademark_id_11, t0.subcategory_1_id AS subcategory_1_id_12, t0.subcategory_2_id AS subcategory_2_id_13, t0.subcategory_3_id AS subcategory_3_id_14, t0.subcategory_4_id AS subcategory_4_id_15 FROM prim_catalogue_product t0 WHERE t0.id = '1583' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.type AS type_1,
          p0_.name AS name_2,
          p0_.address AS address_3,
          p0_.city AS city_4,
          p0_.zip AS zip_5,
          p0_.province AS province_6,
          p0_.country AS country_7
        FROM
          prim_warehouse_external_source p0_
        WHERE
          1 = 1
        ORDER BY
          p0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.address AS address_3, p0_.city AS city_4, p0_.zip AS zip_5, p0_.province AS province_6, p0_.country AS country_7 FROM prim_warehouse_external_source p0_ WHERE 1 = 1 ORDER BY p0_.name ASC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.name AS name_2,
  p0_.address AS address_3,
  p0_.city AS city_4,
  p0_.zip AS zip_5,
  p0_.province AS province_6,
  p0_.country AS country_7
FROM
  prim_warehouse_external_source p0_
WHERE
  1 = 1
ORDER BY
  p0_.name ASC
LIMIT
  15

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.address AS address_3, p0_.city AS city_4, p0_.zip AS zip_5, p0_.province AS province_6, p0_.country AS country_7 FROM prim_warehouse_external_source p0_ WHERE 1 = 1 ORDER BY p0_.name ASC LIMIT 15;

SELECT
  t0.id AS id_1
FROM
  prim_catalogue_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM prim_catalogue_category t0 WHERE t0.id = '6';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_id AS category_id_3,
  t0.language_id AS language_id_4
FROM
  prim_catalogue_category_detail t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.language_id AS language_id_4 FROM prim_catalogue_category_detail t0 WHERE t0.category_id = '6';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.slug AS slug_3
FROM
  prim_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.slug AS slug_3
FROM
  prim_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.slug AS slug_3
FROM
  prim_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3 FROM prim_language t0 WHERE t0.id = '3';