Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.picture AS picture_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.movil_password AS movil_password_6,
  t0.pass_gmail AS pass_gmail_7,
  t0.firm_gmail AS firm_gmail_8,
  t0.name AS name_9,
  t0.last_name AS last_name_10,
  t0.telephone AS telephone_11,
  t0.mobile AS mobile_12,
  t0.id_office AS id_office_13,
  t0.status AS status_14,
  t0.id_company AS id_company_15,
  t0.id_user_rol AS id_user_rol_16,
  t0.id_team AS id_team_17,
  t0.team_leader AS team_leader_18,
  t0.role AS role_19,
  t0.access_key AS access_key_20,
  t0.language AS language_21,
  t0.color AS color_22,
  t0.vacations AS vacations_23,
  t0.half_days AS half_days_24,
  t0.sidebar AS sidebar_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.description AS description_28,
  t0.job_title AS job_title_29
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = 'ayudantedeproduccion3@avexpress.tv' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.picture AS picture_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.movil_password AS movil_password_6,
  t0.pass_gmail AS pass_gmail_7,
  t0.firm_gmail AS firm_gmail_8,
  t0.name AS name_9,
  t0.last_name AS last_name_10,
  t0.telephone AS telephone_11,
  t0.mobile AS mobile_12,
  t0.id_office AS id_office_13,
  t0.status AS status_14,
  t0.id_company AS id_company_15,
  t0.id_user_rol AS id_user_rol_16,
  t0.id_team AS id_team_17,
  t0.team_leader AS team_leader_18,
  t0.role AS role_19,
  t0.access_key AS access_key_20,
  t0.language AS language_21,
  t0.color AS color_22,
  t0.vacations AS vacations_23,
  t0.half_days AS half_days_24,
  t0.sidebar AS sidebar_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.description AS description_28,
  t0.job_title AS job_title_29
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = 'ayudantedeproduccion3@avexpress.tv' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.productName AS productName_2,
  t0.productId AS productId_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.fileId AS fileId_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.hourStart AS hourStart_10,
  t0.minStart AS minStart_11,
  t0.hourEnd AS hourEnd_12,
  t0.minEnd AS minEnd_13,
  t0.description AS description_14,
  t0.createdAt AS createdAt_15,
  t0.createdId AS createdId_16,
  t0.updatedAt AS updatedAt_17,
  t0.updatedId AS updatedId_18,
  t0.supplierExt AS supplierExt_19,
  t0.supplierExtId AS supplierExtId_20,
  t0.service_id_proposal AS service_id_proposal_21,
  t0.service_id_father AS service_id_father_22,
  t0.control_id AS control_id_23,
  t0.proposal_id AS proposal_id_24,
  t0.destination_id AS destination_id_25,
  t0.idea_id AS idea_id_26,
  t0.activity_id AS activity_id_27,
  t0.supplier_id AS supplier_id_28,
  t0.assistant_id AS assistant_id_29,
  t0.service_id AS service_id_30,
  t0.service_cat_id AS service_cat_id_31,
  t0.service_cat_name AS service_cat_name_32,
  t0.name AS name_33,
  t0.price AS price_34,
  t0.currency AS currency_35,
  t0.units AS units_36,
  t0.op_commission AS op_commission_37,
  t0.commission AS commission_38,
  t0.op_over AS op_over_39,
  t0.price_over AS price_over_40,
  t0.op_iva AS op_iva_41,
  t0.iva AS iva_42,
  t0.hour AS hour_43,
  t0.date_in_at AS date_in_at_44,
  t0.date_out_at AS date_out_at_45,
  t0.contcolor AS contcolor_46,
  t0.`rank` AS rank_47,
  t0.renovate AS renovate_48,
  t0.pay AS pay_49,
  t0.days AS days_50,
  t0.sub_total_price AS sub_total_price_51,
  t0.origin_id AS origin_id_52,
  t0.rank_av AS rank_av_53,
  t0.location AS location_54,
  t0.idGpLounge AS idGpLounge_55
FROM
  ave_product_file t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.productName AS productName_2, t0.productId AS productId_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.fileId AS fileId_7, t0.pax AS pax_8, t0.type AS type_9, t0.hourStart AS hourStart_10, t0.minStart AS minStart_11, t0.hourEnd AS hourEnd_12, t0.minEnd AS minEnd_13, t0.description AS description_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.supplierExt AS supplierExt_19, t0.supplierExtId AS supplierExtId_20, t0.service_id_proposal AS service_id_proposal_21, t0.service_id_father AS service_id_father_22, t0.control_id AS control_id_23, t0.proposal_id AS proposal_id_24, t0.destination_id AS destination_id_25, t0.idea_id AS idea_id_26, t0.activity_id AS activity_id_27, t0.supplier_id AS supplier_id_28, t0.assistant_id AS assistant_id_29, t0.service_id AS service_id_30, t0.service_cat_id AS service_cat_id_31, t0.service_cat_name AS service_cat_name_32, t0.name AS name_33, t0.price AS price_34, t0.currency AS currency_35, t0.units AS units_36, t0.op_commission AS op_commission_37, t0.commission AS commission_38, t0.op_over AS op_over_39, t0.price_over AS price_over_40, t0.op_iva AS op_iva_41, t0.iva AS iva_42, t0.hour AS hour_43, t0.date_in_at AS date_in_at_44, t0.date_out_at AS date_out_at_45, t0.contcolor AS contcolor_46, t0.`rank` AS rank_47, t0.renovate AS renovate_48, t0.pay AS pay_49, t0.days AS days_50, t0.sub_total_price AS sub_total_price_51, t0.origin_id AS origin_id_52, t0.rank_av AS rank_av_53, t0.location AS location_54, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = '111392' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.productName AS productName_2,
  t0.productId AS productId_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.fileId AS fileId_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.hourStart AS hourStart_10,
  t0.minStart AS minStart_11,
  t0.hourEnd AS hourEnd_12,
  t0.minEnd AS minEnd_13,
  t0.description AS description_14,
  t0.createdAt AS createdAt_15,
  t0.createdId AS createdId_16,
  t0.updatedAt AS updatedAt_17,
  t0.updatedId AS updatedId_18,
  t0.supplierExt AS supplierExt_19,
  t0.supplierExtId AS supplierExtId_20,
  t0.service_id_proposal AS service_id_proposal_21,
  t0.service_id_father AS service_id_father_22,
  t0.control_id AS control_id_23,
  t0.proposal_id AS proposal_id_24,
  t0.destination_id AS destination_id_25,
  t0.idea_id AS idea_id_26,
  t0.activity_id AS activity_id_27,
  t0.supplier_id AS supplier_id_28,
  t0.assistant_id AS assistant_id_29,
  t0.service_id AS service_id_30,
  t0.service_cat_id AS service_cat_id_31,
  t0.service_cat_name AS service_cat_name_32,
  t0.name AS name_33,
  t0.price AS price_34,
  t0.currency AS currency_35,
  t0.units AS units_36,
  t0.op_commission AS op_commission_37,
  t0.commission AS commission_38,
  t0.op_over AS op_over_39,
  t0.price_over AS price_over_40,
  t0.op_iva AS op_iva_41,
  t0.iva AS iva_42,
  t0.hour AS hour_43,
  t0.date_in_at AS date_in_at_44,
  t0.date_out_at AS date_out_at_45,
  t0.contcolor AS contcolor_46,
  t0.`rank` AS rank_47,
  t0.renovate AS renovate_48,
  t0.pay AS pay_49,
  t0.days AS days_50,
  t0.sub_total_price AS sub_total_price_51,
  t0.origin_id AS origin_id_52,
  t0.rank_av AS rank_av_53,
  t0.location AS location_54,
  t0.idGpLounge AS idGpLounge_55
FROM
  ave_product_file t0
WHERE
  t0.fileId = ?

SELECT t0.id AS id_1, t0.productName AS productName_2, t0.productId AS productId_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.fileId AS fileId_7, t0.pax AS pax_8, t0.type AS type_9, t0.hourStart AS hourStart_10, t0.minStart AS minStart_11, t0.hourEnd AS hourEnd_12, t0.minEnd AS minEnd_13, t0.description AS description_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.supplierExt AS supplierExt_19, t0.supplierExtId AS supplierExtId_20, t0.service_id_proposal AS service_id_proposal_21, t0.service_id_father AS service_id_father_22, t0.control_id AS control_id_23, t0.proposal_id AS proposal_id_24, t0.destination_id AS destination_id_25, t0.idea_id AS idea_id_26, t0.activity_id AS activity_id_27, t0.supplier_id AS supplier_id_28, t0.assistant_id AS assistant_id_29, t0.service_id AS service_id_30, t0.service_cat_id AS service_cat_id_31, t0.service_cat_name AS service_cat_name_32, t0.name AS name_33, t0.price AS price_34, t0.currency AS currency_35, t0.units AS units_36, t0.op_commission AS op_commission_37, t0.commission AS commission_38, t0.op_over AS op_over_39, t0.price_over AS price_over_40, t0.op_iva AS op_iva_41, t0.iva AS iva_42, t0.hour AS hour_43, t0.date_in_at AS date_in_at_44, t0.date_out_at AS date_out_at_45, t0.contcolor AS contcolor_46, t0.`rank` AS rank_47, t0.renovate AS renovate_48, t0.pay AS pay_49, t0.days AS days_50, t0.sub_total_price AS sub_total_price_51, t0.origin_id AS origin_id_52, t0.rank_av AS rank_av_53, t0.location AS location_54, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.fileId = 7307;

SELECT
  a0_.id AS id_0,
  a0_.productName AS productName_1,
  a0_.productId AS productId_2,
  a0_.dateStart AS dateStart_3,
  a0_.dateEnd AS dateEnd_4,
  a0_.servicePrice AS servicePrice_5,
  a0_.fileId AS fileId_6,
  a0_.pax AS pax_7,
  a0_.type AS type_8,
  a0_.hourStart AS hourStart_9,
  a0_.minStart AS minStart_10,
  a0_.hourEnd AS hourEnd_11,
  a0_.minEnd AS minEnd_12,
  a0_.description AS description_13,
  a0_.createdAt AS createdAt_14,
  a0_.createdId AS createdId_15,
  a0_.updatedAt AS updatedAt_16,
  a0_.updatedId AS updatedId_17,
  a0_.supplierExt AS supplierExt_18,
  a0_.supplierExtId AS supplierExtId_19,
  a0_.service_id_proposal AS service_id_proposal_20,
  a0_.service_id_father AS service_id_father_21,
  a0_.control_id AS control_id_22,
  a0_.proposal_id AS proposal_id_23,
  a0_.destination_id AS destination_id_24,
  a0_.idea_id AS idea_id_25,
  a0_.activity_id AS activity_id_26,
  a0_.supplier_id AS supplier_id_27,
  a0_.assistant_id AS assistant_id_28,
  a0_.service_id AS service_id_29,
  a0_.service_cat_id AS service_cat_id_30,
  a0_.service_cat_name AS service_cat_name_31,
  a0_.name AS name_32,
  a0_.price AS price_33,
  a0_.currency AS currency_34,
  a0_.units AS units_35,
  a0_.op_commission AS op_commission_36,
  a0_.commission AS commission_37,
  a0_.op_over AS op_over_38,
  a0_.price_over AS price_over_39,
  a0_.op_iva AS op_iva_40,
  a0_.iva AS iva_41,
  a0_.hour AS hour_42,
  a0_.date_in_at AS date_in_at_43,
  a0_.date_out_at AS date_out_at_44,
  a0_.contcolor AS contcolor_45,
  a0_.`rank` AS rank_46,
  a0_.renovate AS renovate_47,
  a0_.pay AS pay_48,
  a0_.days AS days_49,
  a0_.sub_total_price AS sub_total_price_50,
  a0_.origin_id AS origin_id_51,
  a0_.rank_av AS rank_av_52,
  a0_.location AS location_53,
  a0_.idGpLounge AS idGpLounge_54
FROM
  ave_product_file a0_
WHERE
  a0_.fileId = ?
  AND a0_.type = ?
  AND a0_.location = ?
ORDER BY
  a0_.rank_av ASC

SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.`rank` AS rank_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rank_av AS rank_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ WHERE a0_.fileId = 7307 AND a0_.type = 'Vídeo' AND a0_.location = 'null' ORDER BY a0_.rank_av ASC;

SELECT
  a0_.id AS id_0,
  a0_.productName AS productName_1,
  a0_.productId AS productId_2,
  a0_.dateStart AS dateStart_3,
  a0_.dateEnd AS dateEnd_4,
  a0_.servicePrice AS servicePrice_5,
  a0_.fileId AS fileId_6,
  a0_.pax AS pax_7,
  a0_.type AS type_8,
  a0_.hourStart AS hourStart_9,
  a0_.minStart AS minStart_10,
  a0_.hourEnd AS hourEnd_11,
  a0_.minEnd AS minEnd_12,
  a0_.description AS description_13,
  a0_.createdAt AS createdAt_14,
  a0_.createdId AS createdId_15,
  a0_.updatedAt AS updatedAt_16,
  a0_.updatedId AS updatedId_17,
  a0_.supplierExt AS supplierExt_18,
  a0_.supplierExtId AS supplierExtId_19,
  a0_.service_id_proposal AS service_id_proposal_20,
  a0_.service_id_father AS service_id_father_21,
  a0_.control_id AS control_id_22,
  a0_.proposal_id AS proposal_id_23,
  a0_.destination_id AS destination_id_24,
  a0_.idea_id AS idea_id_25,
  a0_.activity_id AS activity_id_26,
  a0_.supplier_id AS supplier_id_27,
  a0_.assistant_id AS assistant_id_28,
  a0_.service_id AS service_id_29,
  a0_.service_cat_id AS service_cat_id_30,
  a0_.service_cat_name AS service_cat_name_31,
  a0_.name AS name_32,
  a0_.price AS price_33,
  a0_.currency AS currency_34,
  a0_.units AS units_35,
  a0_.op_commission AS op_commission_36,
  a0_.commission AS commission_37,
  a0_.op_over AS op_over_38,
  a0_.price_over AS price_over_39,
  a0_.op_iva AS op_iva_40,
  a0_.iva AS iva_41,
  a0_.hour AS hour_42,
  a0_.date_in_at AS date_in_at_43,
  a0_.date_out_at AS date_out_at_44,
  a0_.contcolor AS contcolor_45,
  a0_.`rank` AS rank_46,
  a0_.renovate AS renovate_47,
  a0_.pay AS pay_48,
  a0_.days AS days_49,
  a0_.sub_total_price AS sub_total_price_50,
  a0_.origin_id AS origin_id_51,
  a0_.rank_av AS rank_av_52,
  a0_.location AS location_53,
  a0_.idGpLounge AS idGpLounge_54
FROM
  ave_product_file a0_
WHERE
  a0_.fileId = ?
  AND a0_.type = ?
  AND a0_.location = ?
ORDER BY
  a0_.rank_av ASC

SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.`rank` AS rank_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rank_av AS rank_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ WHERE a0_.fileId = 7307 AND a0_.type = 'Sonido' AND a0_.location = 'null' ORDER BY a0_.rank_av ASC;

SELECT
  a0_.id AS id_0,
  a0_.productName AS productName_1,
  a0_.productId AS productId_2,
  a0_.dateStart AS dateStart_3,
  a0_.dateEnd AS dateEnd_4,
  a0_.servicePrice AS servicePrice_5,
  a0_.fileId AS fileId_6,
  a0_.pax AS pax_7,
  a0_.type AS type_8,
  a0_.hourStart AS hourStart_9,
  a0_.minStart AS minStart_10,
  a0_.hourEnd AS hourEnd_11,
  a0_.minEnd AS minEnd_12,
  a0_.description AS description_13,
  a0_.createdAt AS createdAt_14,
  a0_.createdId AS createdId_15,
  a0_.updatedAt AS updatedAt_16,
  a0_.updatedId AS updatedId_17,
  a0_.supplierExt AS supplierExt_18,
  a0_.supplierExtId AS supplierExtId_19,
  a0_.service_id_proposal AS service_id_proposal_20,
  a0_.service_id_father AS service_id_father_21,
  a0_.control_id AS control_id_22,
  a0_.proposal_id AS proposal_id_23,
  a0_.destination_id AS destination_id_24,
  a0_.idea_id AS idea_id_25,
  a0_.activity_id AS activity_id_26,
  a0_.supplier_id AS supplier_id_27,
  a0_.assistant_id AS assistant_id_28,
  a0_.service_id AS service_id_29,
  a0_.service_cat_id AS service_cat_id_30,
  a0_.service_cat_name AS service_cat_name_31,
  a0_.name AS name_32,
  a0_.price AS price_33,
  a0_.currency AS currency_34,
  a0_.units AS units_35,
  a0_.op_commission AS op_commission_36,
  a0_.commission AS commission_37,
  a0_.op_over AS op_over_38,
  a0_.price_over AS price_over_39,
  a0_.op_iva AS op_iva_40,
  a0_.iva AS iva_41,
  a0_.hour AS hour_42,
  a0_.date_in_at AS date_in_at_43,
  a0_.date_out_at AS date_out_at_44,
  a0_.contcolor AS contcolor_45,
  a0_.`rank` AS rank_46,
  a0_.renovate AS renovate_47,
  a0_.pay AS pay_48,
  a0_.days AS days_49,
  a0_.sub_total_price AS sub_total_price_50,
  a0_.origin_id AS origin_id_51,
  a0_.rank_av AS rank_av_52,
  a0_.location AS location_53,
  a0_.idGpLounge AS idGpLounge_54
FROM
  ave_product_file a0_
WHERE
  a0_.fileId = ?
  AND a0_.type = ?
  AND a0_.location = ?
ORDER BY
  a0_.rank_av ASC

SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.`rank` AS rank_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rank_av AS rank_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ WHERE a0_.fileId = 7307 AND a0_.type = 'Iluminación' AND a0_.location = 'null' ORDER BY a0_.rank_av ASC;

SELECT
  a0_.id AS id_0,
  a0_.productName AS productName_1,
  a0_.productId AS productId_2,
  a0_.dateStart AS dateStart_3,
  a0_.dateEnd AS dateEnd_4,
  a0_.servicePrice AS servicePrice_5,
  a0_.fileId AS fileId_6,
  a0_.pax AS pax_7,
  a0_.type AS type_8,
  a0_.hourStart AS hourStart_9,
  a0_.minStart AS minStart_10,
  a0_.hourEnd AS hourEnd_11,
  a0_.minEnd AS minEnd_12,
  a0_.description AS description_13,
  a0_.createdAt AS createdAt_14,
  a0_.createdId AS createdId_15,
  a0_.updatedAt AS updatedAt_16,
  a0_.updatedId AS updatedId_17,
  a0_.supplierExt AS supplierExt_18,
  a0_.supplierExtId AS supplierExtId_19,
  a0_.service_id_proposal AS service_id_proposal_20,
  a0_.service_id_father AS service_id_father_21,
  a0_.control_id AS control_id_22,
  a0_.proposal_id AS proposal_id_23,
  a0_.destination_id AS destination_id_24,
  a0_.idea_id AS idea_id_25,
  a0_.activity_id AS activity_id_26,
  a0_.supplier_id AS supplier_id_27,
  a0_.assistant_id AS assistant_id_28,
  a0_.service_id AS service_id_29,
  a0_.service_cat_id AS service_cat_id_30,
  a0_.service_cat_name AS service_cat_name_31,
  a0_.name AS name_32,
  a0_.price AS price_33,
  a0_.currency AS currency_34,
  a0_.units AS units_35,
  a0_.op_commission AS op_commission_36,
  a0_.commission AS commission_37,
  a0_.op_over AS op_over_38,
  a0_.price_over AS price_over_39,
  a0_.op_iva AS op_iva_40,
  a0_.iva AS iva_41,
  a0_.hour AS hour_42,
  a0_.date_in_at AS date_in_at_43,
  a0_.date_out_at AS date_out_at_44,
  a0_.contcolor AS contcolor_45,
  a0_.`rank` AS rank_46,
  a0_.renovate AS renovate_47,
  a0_.pay AS pay_48,
  a0_.days AS days_49,
  a0_.sub_total_price AS sub_total_price_50,
  a0_.origin_id AS origin_id_51,
  a0_.rank_av AS rank_av_52,
  a0_.location AS location_53,
  a0_.idGpLounge AS idGpLounge_54
FROM
  ave_product_file a0_
WHERE
  (
    a0_.fileId = ?
    AND a0_.type <> ?
    AND a0_.type <> ?
    AND a0_.type <> ?
    AND a0_.location = ?
  )
ORDER BY
  a0_.rank_av ASC

SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.`rank` AS rank_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rank_av AS rank_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ WHERE (a0_.fileId = 7307 AND a0_.type <> 'Vídeo' AND a0_.type <> 'Sonido' AND a0_.type <> 'Iluminación' AND a0_.location = 'null') ORDER BY a0_.rank_av ASC;