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 = 'sandra.lopez@inout.events' 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 = 'sandra.lopez@inout.events' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.proposal_id AS proposal_id_2,
  t0.destination_id AS destination_id_3,
  t0.disabled AS disabled_4,
  t0.disabled_presentation AS disabled_presentation_5
FROM
  proposals_control t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.destination_id AS destination_id_3, t0.disabled AS disabled_4, t0.disabled_presentation AS disabled_presentation_5 FROM proposals_control t0 WHERE t0.id = '5833' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.proposal_id AS proposal_id_2,
  t0.destination_id AS destination_id_3,
  t0.disabled AS disabled_4,
  t0.disabled_presentation AS disabled_presentation_5
FROM
  proposals_control t0
WHERE
  t0.proposal_id = ?

SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.destination_id AS destination_id_3, t0.disabled AS disabled_4, t0.disabled_presentation AS disabled_presentation_5 FROM proposals_control t0 WHERE t0.proposal_id = 6016;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.region AS region_3,
  t0.province AS province_4,
  t0.population AS population_5,
  t0.title AS title_6,
  t0.created_id AS created_id_7,
  t0.created_at AS created_at_8,
  t0.updated_id AS updated_id_9,
  t0.updated_at AS updated_at_10
FROM
  destinations t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.country AS country_2, t0.region AS region_3, t0.province AS province_4, t0.population AS population_5, t0.title AS title_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10 FROM destinations t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.region AS region_3,
  t0.province AS province_4,
  t0.population AS population_5,
  t0.title AS title_6,
  t0.created_id AS created_id_7,
  t0.created_at AS created_at_8,
  t0.updated_id AS updated_id_9,
  t0.updated_at AS updated_at_10
FROM
  destinations t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.country AS country_2, t0.region AS region_3, t0.province AS province_4, t0.population AS population_5, t0.title AS title_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10 FROM destinations t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.proposal_id AS proposal_id_2,
  t0.name AS name_3,
  t0.service_id AS service_id_4,
  t0.type AS type_5,
  t0.amount AS amount_6,
  t0.op_iva AS op_iva_7,
  t0.iva AS iva_8,
  t0.created_id AS created_id_9,
  t0.created_at AS created_at_10,
  t0.updated_id AS updated_id_11,
  t0.updated_at AS updated_at_12
FROM
  proposals_discount t0
WHERE
  t0.proposal_id = ?

SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.service_id AS service_id_4, t0.type AS type_5, t0.amount AS amount_6, t0.op_iva AS op_iva_7, t0.iva AS iva_8, t0.created_id AS created_id_9, t0.created_at AS created_at_10, t0.updated_id AS updated_id_11, t0.updated_at AS updated_at_12 FROM proposals_discount t0 WHERE t0.proposal_id = 6016;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.commission AS commission_4,
  t0.pax AS pax_5,
  t0.bedrooms AS bedrooms_6,
  t0.office_id AS office_id_7,
  t0.client_id AS client_id_8,
  t0.contact_id AS contact_id_9,
  t0.reference_name AS reference_name_10,
  t0.reference_id AS reference_id_11,
  t0.agent_id AS agent_id_12,
  t0.approximate_billing AS approximate_billing_13,
  t0.team_id AS team_id_14,
  t0.agent_two_id AS agent_two_id_15,
  t0.agent_commercial_id AS agent_commercial_id_16,
  t0.date_proposed_at AS date_proposed_at_17,
  t0.date_event_star_at AS date_event_star_at_18,
  t0.date_event_end_at AS date_event_end_at_19,
  t0.days_email_reminder AS days_email_reminder_20,
  t0.language AS language_21,
  t0.include_logo AS include_logo_22,
  t0.version_ppt AS version_ppt_23,
  t0.version_excel AS version_excel_24,
  t0.version_flahs AS version_flahs_25,
  t0.version_word AS version_word_26,
  t0.briefing AS briefing_27,
  t0.date_presentation_at AS date_presentation_at_28,
  t0.status AS status_29,
  t0.sent AS sent_30,
  t0.select_type AS select_type_31,
  t0.created_at AS created_at_32,
  t0.created_id AS created_id_33,
  t0.updated_at AS updated_at_34,
  t0.updated_id AS updated_id_35,
  t0.access_key AS access_key_36,
  t0.viewed_at AS viewed_at_37,
  t0.observation AS observation_38,
  t0.send_admin AS send_admin_39,
  t0.mcp AS mcp_40,
  t0.image AS image_41,
  t0.category AS category_42,
  t0.idMusic AS idMusic_43
FROM
  proposals t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.commission AS commission_4, t0.pax AS pax_5, t0.bedrooms AS bedrooms_6, t0.office_id AS office_id_7, t0.client_id AS client_id_8, t0.contact_id AS contact_id_9, t0.reference_name AS reference_name_10, t0.reference_id AS reference_id_11, t0.agent_id AS agent_id_12, t0.approximate_billing AS approximate_billing_13, t0.team_id AS team_id_14, t0.agent_two_id AS agent_two_id_15, t0.agent_commercial_id AS agent_commercial_id_16, t0.date_proposed_at AS date_proposed_at_17, t0.date_event_star_at AS date_event_star_at_18, t0.date_event_end_at AS date_event_end_at_19, t0.days_email_reminder AS days_email_reminder_20, t0.language AS language_21, t0.include_logo AS include_logo_22, t0.version_ppt AS version_ppt_23, t0.version_excel AS version_excel_24, t0.version_flahs AS version_flahs_25, t0.version_word AS version_word_26, t0.briefing AS briefing_27, t0.date_presentation_at AS date_presentation_at_28, t0.status AS status_29, t0.sent AS sent_30, t0.select_type AS select_type_31, t0.created_at AS created_at_32, t0.created_id AS created_id_33, t0.updated_at AS updated_at_34, t0.updated_id AS updated_id_35, t0.access_key AS access_key_36, t0.viewed_at AS viewed_at_37, t0.observation AS observation_38, t0.send_admin AS send_admin_39, t0.mcp AS mcp_40, t0.image AS image_41, t0.category AS category_42, t0.idMusic AS idMusic_43 FROM proposals t0 WHERE t0.id = 6016 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  countries t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM countries t0 WHERE t0.id = '62' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country_id AS country_id_4
FROM
  regions t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM regions t0 WHERE t0.id = '969' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.country_id AS country_id_4,
  t0.region_id AS region_id_5
FROM
  provinces t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.country_id AS country_id_4, t0.region_id AS region_id_5 FROM provinces t0 WHERE t0.id = '28' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.region_id AS region_id_2,
  t0.country_id AS country_id_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.name AS name_6,
  t0.province_id AS province_id_7,
  t0.zipcode AS zipcode_8
FROM
  cities t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.region_id AS region_id_2, t0.country_id AS country_id_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.name AS name_6, t0.province_id AS province_id_7, t0.zipcode AS zipcode_8 FROM cities t0 WHERE t0.id = '713549' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.control_destination_id AS control_destination_id_2,
  t0.proposal_id AS proposal_id_3,
  t0.destino_id AS destino_id_4,
  t0.supplier_id AS supplier_id_5,
  t0.idea_id AS idea_id_6,
  t0.activity_id AS activity_id_7,
  t0.status AS status_8,
  t0.rank AS rank_9,
  t0.disabled AS disabled_10,
  t0.date_block_limit AS date_block_limit_11
FROM
  proposals_supplier_control t0
WHERE
  t0.proposal_id = ?
  AND t0.destino_id = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.control_destination_id AS control_destination_id_2, t0.proposal_id AS proposal_id_3, t0.destino_id AS destino_id_4, t0.supplier_id AS supplier_id_5, t0.idea_id AS idea_id_6, t0.activity_id AS activity_id_7, t0.status AS status_8, t0.rank AS rank_9, t0.disabled AS disabled_10, t0.date_block_limit AS date_block_limit_11 FROM proposals_supplier_control t0 WHERE t0.proposal_id = 6016 AND t0.destino_id = 1 ORDER BY t0.rank ASC;

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.group_id AS group_id_3,
  t0.contact AS contact_4,
  t0.type_document AS type_document_5,
  t0.id_document AS id_document_6,
  t0.address AS address_7,
  t0.population AS population_8,
  t0.province AS province_9,
  t0.region AS region_10,
  t0.zip_code AS zip_code_11,
  t0.country AS country_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.email AS email_15,
  t0.type AS type_16,
  t0.tags AS tags_17,
  t0.preference AS preference_18,
  t0.created_id AS created_id_19,
  t0.created_at AS created_at_20,
  t0.updated_id AS updated_id_21,
  t0.updated_at AS updated_at_22,
  t0.state AS state_23,
  t0.picture AS picture_24,
  t0.observation AS observation_25,
  t0.terms AS terms_26,
  t0.star AS star_27,
  t0.name AS name_28,
  t0.url AS url_29,
  t0.commission AS commission_30,
  t0.iva AS iva_31,
  t0.accommodation AS accommodation_32,
  t0.is_supplier_in_out AS is_supplier_in_out_33,
  t0.is_supplier_green_patio AS is_supplier_green_patio_34,
  t0.is_supplier_av_express AS is_supplier_av_express_35,
  t0.is_supplier_develup AS is_supplier_develup_36,
  t0.typology AS typology_37
FROM
  suppliers t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company AS company_2, t0.group_id AS group_id_3, t0.contact AS contact_4, t0.type_document AS type_document_5, t0.id_document AS id_document_6, t0.address AS address_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.zip_code AS zip_code_11, t0.country AS country_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.email AS email_15, t0.type AS type_16, t0.tags AS tags_17, t0.preference AS preference_18, t0.created_id AS created_id_19, t0.created_at AS created_at_20, t0.updated_id AS updated_id_21, t0.updated_at AS updated_at_22, t0.state AS state_23, t0.picture AS picture_24, t0.observation AS observation_25, t0.terms AS terms_26, t0.star AS star_27, t0.name AS name_28, t0.url AS url_29, t0.commission AS commission_30, t0.iva AS iva_31, t0.accommodation AS accommodation_32, t0.is_supplier_in_out AS is_supplier_in_out_33, t0.is_supplier_green_patio AS is_supplier_green_patio_34, t0.is_supplier_av_express AS is_supplier_av_express_35, t0.is_supplier_develup AS is_supplier_develup_36, t0.typology AS typology_37 FROM suppliers t0 WHERE t0.id = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idea_id AS idea_id_2,
  t0.activity_id AS activity_id_3,
  t0.supplier_id AS supplier_id_4
FROM
  supplier_idea_services_control t0
WHERE
  t0.supplier_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.idea_id AS idea_id_2, t0.activity_id AS activity_id_3, t0.supplier_id AS supplier_id_4 FROM supplier_idea_services_control t0 WHERE t0.supplier_id = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.control_id AS control_id_2,
  t0.supplier_id AS supplier_id_3,
  t0.services_cat_id AS services_cat_id_4,
  t0.services_category AS services_category_5,
  t0.services_id AS services_id_6,
  t0.image_large AS image_large_7,
  t0.image_medium AS image_medium_8,
  t0.image_small AS image_small_9,
  t0.rank AS rank_10,
  t0.created_id AS created_id_11,
  t0.created_at AS created_at_12,
  t0.updated_id AS updated_id_13,
  t0.updated_at AS updated_at_14
FROM
  suppliers_gallery t0
WHERE
  t0.supplier_id = ?
  AND t0.services_cat_id = ?
  AND t0.services_category = ?
  AND t0.services_id = ?
  AND t0.control_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.control_id AS control_id_2, t0.supplier_id AS supplier_id_3, t0.services_cat_id AS services_cat_id_4, t0.services_category AS services_category_5, t0.services_id AS services_id_6, t0.image_large AS image_large_7, t0.image_medium AS image_medium_8, t0.image_small AS image_small_9, t0.rank AS rank_10, t0.created_id AS created_id_11, t0.created_at AS created_at_12, t0.updated_id AS updated_id_13, t0.updated_at AS updated_at_14 FROM suppliers_gallery t0 WHERE t0.supplier_id = '0' AND t0.services_cat_id = '0' AND t0.services_category = 'General' AND t0.services_id = '0' AND t0.control_id = '0' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.service_id_father AS service_id_father_1,
  p0_.control_id AS control_id_2,
  p0_.proposal_id AS proposal_id_3,
  p0_.destination_id AS destination_id_4,
  p0_.activity_id AS activity_id_5,
  p0_.idea_id AS idea_id_6,
  p0_.supplier_id AS supplier_id_7,
  p0_.assistant_id AS assistant_id_8,
  p0_.service_id AS service_id_9,
  p0_.service_cat_id AS service_cat_id_10,
  p0_.service_cat_name AS service_cat_name_11,
  p0_.name AS name_12,
  p0_.price AS price_13,
  p0_.pre_commission AS pre_commission_14,
  p0_.pre_iva AS pre_iva_15,
  p0_.currency AS currency_16,
  p0_.units AS units_17,
  p0_.op_commission AS op_commission_18,
  p0_.commission AS commission_19,
  p0_.op_over AS op_over_20,
  p0_.price_over AS price_over_21,
  p0_.op_iva AS op_iva_22,
  p0_.iva AS iva_23,
  p0_.original_op_iva AS original_op_iva_24,
  p0_.original_iva AS original_iva_25,
  p0_.original_price AS original_price_26,
  p0_.pax AS pax_27,
  p0_.hour AS hour_28,
  p0_.date_in_at AS date_in_at_29,
  p0_.date_out_at AS date_out_at_30,
  p0_.direct_payment AS direct_payment_31,
  p0_.date_block_limit AS date_block_limit_32,
  p0_.status_internal AS status_internal_33,
  p0_.status AS status_34,
  p0_.status_recommended AS status_recommended_35,
  p0_.breakdown AS breakdown_36,
  p0_.is_father AS is_father_37,
  p0_.rank AS rank_38,
  p0_.created_at AS created_at_39,
  p0_.created_id AS created_id_40,
  p0_.updated_at AS updated_at_41,
  p0_.updated_id AS updated_id_42
FROM
  proposals_supplier_services p0_
WHERE
  p0_.control_id = ?
  AND p0_.service_id_father = ?
ORDER BY
  p0_.rank ASC,
  p0_.service_cat_id ASC

SELECT p0_.id AS id_0, p0_.service_id_father AS service_id_father_1, p0_.control_id AS control_id_2, p0_.proposal_id AS proposal_id_3, p0_.destination_id AS destination_id_4, p0_.activity_id AS activity_id_5, p0_.idea_id AS idea_id_6, p0_.supplier_id AS supplier_id_7, p0_.assistant_id AS assistant_id_8, p0_.service_id AS service_id_9, p0_.service_cat_id AS service_cat_id_10, p0_.service_cat_name AS service_cat_name_11, p0_.name AS name_12, p0_.price AS price_13, p0_.pre_commission AS pre_commission_14, p0_.pre_iva AS pre_iva_15, p0_.currency AS currency_16, p0_.units AS units_17, p0_.op_commission AS op_commission_18, p0_.commission AS commission_19, p0_.op_over AS op_over_20, p0_.price_over AS price_over_21, p0_.op_iva AS op_iva_22, p0_.iva AS iva_23, p0_.original_op_iva AS original_op_iva_24, p0_.original_iva AS original_iva_25, p0_.original_price AS original_price_26, p0_.pax AS pax_27, p0_.hour AS hour_28, p0_.date_in_at AS date_in_at_29, p0_.date_out_at AS date_out_at_30, p0_.direct_payment AS direct_payment_31, p0_.date_block_limit AS date_block_limit_32, p0_.status_internal AS status_internal_33, p0_.status AS status_34, p0_.status_recommended AS status_recommended_35, p0_.breakdown AS breakdown_36, p0_.is_father AS is_father_37, p0_.rank AS rank_38, p0_.created_at AS created_at_39, p0_.created_id AS created_id_40, p0_.updated_at AS updated_at_41, p0_.updated_id AS updated_id_42 FROM proposals_supplier_services p0_ WHERE p0_.control_id = 33206 AND p0_.service_id_father = '0' ORDER BY p0_.rank ASC, p0_.service_cat_id ASC;

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.group_id AS group_id_3,
  t0.contact AS contact_4,
  t0.type_document AS type_document_5,
  t0.id_document AS id_document_6,
  t0.address AS address_7,
  t0.population AS population_8,
  t0.province AS province_9,
  t0.region AS region_10,
  t0.zip_code AS zip_code_11,
  t0.country AS country_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.email AS email_15,
  t0.type AS type_16,
  t0.tags AS tags_17,
  t0.preference AS preference_18,
  t0.created_id AS created_id_19,
  t0.created_at AS created_at_20,
  t0.updated_id AS updated_id_21,
  t0.updated_at AS updated_at_22,
  t0.state AS state_23,
  t0.picture AS picture_24,
  t0.observation AS observation_25,
  t0.terms AS terms_26,
  t0.star AS star_27,
  t0.name AS name_28,
  t0.url AS url_29,
  t0.commission AS commission_30,
  t0.iva AS iva_31,
  t0.accommodation AS accommodation_32,
  t0.is_supplier_in_out AS is_supplier_in_out_33,
  t0.is_supplier_green_patio AS is_supplier_green_patio_34,
  t0.is_supplier_av_express AS is_supplier_av_express_35,
  t0.is_supplier_develup AS is_supplier_develup_36,
  t0.typology AS typology_37
FROM
  suppliers t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company AS company_2, t0.group_id AS group_id_3, t0.contact AS contact_4, t0.type_document AS type_document_5, t0.id_document AS id_document_6, t0.address AS address_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.zip_code AS zip_code_11, t0.country AS country_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.email AS email_15, t0.type AS type_16, t0.tags AS tags_17, t0.preference AS preference_18, t0.created_id AS created_id_19, t0.created_at AS created_at_20, t0.updated_id AS updated_id_21, t0.updated_at AS updated_at_22, t0.state AS state_23, t0.picture AS picture_24, t0.observation AS observation_25, t0.terms AS terms_26, t0.star AS star_27, t0.name AS name_28, t0.url AS url_29, t0.commission AS commission_30, t0.iva AS iva_31, t0.accommodation AS accommodation_32, t0.is_supplier_in_out AS is_supplier_in_out_33, t0.is_supplier_green_patio AS is_supplier_green_patio_34, t0.is_supplier_av_express AS is_supplier_av_express_35, t0.is_supplier_develup AS is_supplier_develup_36, t0.typology AS typology_37 FROM suppliers t0 WHERE t0.id = 285 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idea_id AS idea_id_2,
  t0.activity_id AS activity_id_3,
  t0.supplier_id AS supplier_id_4
FROM
  supplier_idea_services_control t0
WHERE
  t0.supplier_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.idea_id AS idea_id_2, t0.activity_id AS activity_id_3, t0.supplier_id AS supplier_id_4 FROM supplier_idea_services_control t0 WHERE t0.supplier_id = 285 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.control_id AS control_id_2,
  t0.supplier_id AS supplier_id_3,
  t0.services_cat_id AS services_cat_id_4,
  t0.services_category AS services_category_5,
  t0.services_id AS services_id_6,
  t0.image_large AS image_large_7,
  t0.image_medium AS image_medium_8,
  t0.image_small AS image_small_9,
  t0.rank AS rank_10,
  t0.created_id AS created_id_11,
  t0.created_at AS created_at_12,
  t0.updated_id AS updated_id_13,
  t0.updated_at AS updated_at_14
FROM
  suppliers_gallery t0
WHERE
  t0.supplier_id = ?
  AND t0.services_cat_id = ?
  AND t0.services_category = ?
  AND t0.services_id = ?
  AND t0.control_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.control_id AS control_id_2, t0.supplier_id AS supplier_id_3, t0.services_cat_id AS services_cat_id_4, t0.services_category AS services_category_5, t0.services_id AS services_id_6, t0.image_large AS image_large_7, t0.image_medium AS image_medium_8, t0.image_small AS image_small_9, t0.rank AS rank_10, t0.created_id AS created_id_11, t0.created_at AS created_at_12, t0.updated_id AS updated_id_13, t0.updated_at AS updated_at_14 FROM suppliers_gallery t0 WHERE t0.supplier_id = 308 AND t0.services_cat_id = '0' AND t0.services_category = 'General' AND t0.services_id = '0' AND t0.control_id = '0' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.service_id_father AS service_id_father_1,
  p0_.control_id AS control_id_2,
  p0_.proposal_id AS proposal_id_3,
  p0_.destination_id AS destination_id_4,
  p0_.activity_id AS activity_id_5,
  p0_.idea_id AS idea_id_6,
  p0_.supplier_id AS supplier_id_7,
  p0_.assistant_id AS assistant_id_8,
  p0_.service_id AS service_id_9,
  p0_.service_cat_id AS service_cat_id_10,
  p0_.service_cat_name AS service_cat_name_11,
  p0_.name AS name_12,
  p0_.price AS price_13,
  p0_.pre_commission AS pre_commission_14,
  p0_.pre_iva AS pre_iva_15,
  p0_.currency AS currency_16,
  p0_.units AS units_17,
  p0_.op_commission AS op_commission_18,
  p0_.commission AS commission_19,
  p0_.op_over AS op_over_20,
  p0_.price_over AS price_over_21,
  p0_.op_iva AS op_iva_22,
  p0_.iva AS iva_23,
  p0_.original_op_iva AS original_op_iva_24,
  p0_.original_iva AS original_iva_25,
  p0_.original_price AS original_price_26,
  p0_.pax AS pax_27,
  p0_.hour AS hour_28,
  p0_.date_in_at AS date_in_at_29,
  p0_.date_out_at AS date_out_at_30,
  p0_.direct_payment AS direct_payment_31,
  p0_.date_block_limit AS date_block_limit_32,
  p0_.status_internal AS status_internal_33,
  p0_.status AS status_34,
  p0_.status_recommended AS status_recommended_35,
  p0_.breakdown AS breakdown_36,
  p0_.is_father AS is_father_37,
  p0_.rank AS rank_38,
  p0_.created_at AS created_at_39,
  p0_.created_id AS created_id_40,
  p0_.updated_at AS updated_at_41,
  p0_.updated_id AS updated_id_42
FROM
  proposals_supplier_services p0_
WHERE
  p0_.control_id = ?
  AND p0_.service_id_father = ?
ORDER BY
  p0_.rank ASC,
  p0_.service_cat_id ASC