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 = '1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.status AS status_3,
  t0.type AS type_4,
  t0.qty AS qty_5,
  t0.send_type AS send_type_6,
  t0.number AS number_7,
  t0.ddt AS ddt_8,
  t0.iqc_code_id AS iqc_code_id_9,
  t0.external_source_id AS external_source_id_10
FROM
  prim_warehouse_transfer t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.type AS type_4, t0.qty AS qty_5, t0.send_type AS send_type_6, t0.number AS number_7, t0.ddt AS ddt_8, t0.iqc_code_id AS iqc_code_id_9, t0.external_source_id AS external_source_id_10 FROM prim_warehouse_transfer t0 WHERE t0.id = '42' LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  prim_iqp_code p0_
  LEFT JOIN prim_warehouse_box p1_ ON p0_.box_id = p1_.id
  LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id
  LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id
  LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id
  LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id
  LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id
WHERE
  (
    p0_.transfer_entrance_id = ?
    OR p0_.transfer_exit_id = ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_iqp_code p0_ LEFT JOIN prim_warehouse_box p1_ ON p0_.box_id = p1_.id LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id WHERE (p0_.transfer_entrance_id = '42' OR p0_.transfer_exit_id = '42');

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.value AS value_1
FROM
  prim_iqp_code p0_
  LEFT JOIN prim_warehouse_box p1_ ON p0_.box_id = p1_.id
  LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id
  LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id
  LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id
  LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id
  LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id
WHERE
  (
    p0_.transfer_entrance_id = ?
    OR p0_.transfer_exit_id = ?
  )
ORDER BY
  p0_.value ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.value AS value_1 FROM prim_iqp_code p0_ LEFT JOIN prim_warehouse_box p1_ ON p0_.box_id = p1_.id LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id WHERE (p0_.transfer_entrance_id = '42' OR p0_.transfer_exit_id = '42') ORDER BY 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_warehouse_box p1_ ON p0_.box_id = p1_.id
  LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id
  LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id
  LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id
  LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id
  LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id
WHERE
  (
    p0_.transfer_entrance_id = ?
    OR p0_.transfer_exit_id = ?
  )
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.value ASC

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_warehouse_box p1_ ON p0_.box_id = p1_.id LEFT JOIN prim_iqs_code p2_ ON p1_.iqs_code_id = p2_.id LEFT JOIN prim_warehouse_pallet p3_ ON p0_.pallet_id = p3_.id LEFT JOIN prim_iqe_code p4_ ON p3_.iqe_code_id = p4_.id LEFT JOIN prim_warehouse_pallet p5_ ON p1_.pallet_id = p5_.id LEFT JOIN prim_iqe_code p6_ ON p5_.iqe_code_id = p6_.id WHERE (p0_.transfer_entrance_id = '42' OR p0_.transfer_exit_id = '42') AND p0_.id IN ('255713', '255714', '255715', '255716', '255717', '255718', '255719', '255720', '255721', '255722', '255723', '255724', '255725', '255726', '255727', '255728', '255729', '255730', '255731', '255732', '255733', '255734', '255735', '255736', '255737', '255738', '255739', '255740', '255741', '255742') ORDER BY p0_.value ASC;

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255713';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255713';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255714';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255714';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255715';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255715';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255716';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255716';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255717';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255717';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255718';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255718';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255719';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255719';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255720';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255720';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255721';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255721';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255722';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.iqp_code_id = '255722';

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.iqp_code_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.iqp_code_id = '255723';