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 = 'anna.canal@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 = 'anna.canal@inout.events' 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.access_key = ?
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.access_key = 'c9cbeeb50e9fba95cf790876e58baf62' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.title AS title_4,
  t0.address AS address_5,
  t0.address_number AS address_number_6,
  t0.zip_code AS zip_code_7,
  t0.population AS population_8,
  t0.province AS province_9,
  t0.region AS region_10,
  t0.country AS country_11,
  t0.telephone AS telephone_12,
  t0.fax AS fax_13,
  t0.email AS email_14,
  t0.gds AS gds_15,
  t0.type_document AS type_document_16,
  t0.id_document AS id_document_17,
  t0.observation AS observation_18,
  t0.id_office AS id_office_19,
  t0.created_at AS created_at_20,
  t0.created_id AS created_id_21,
  t0.updated_at AS updated_at_22,
  t0.updated_id AS updated_id_23,
  t0.status AS status_24,
  t0.picture AS picture_25,
  t0.group_id AS group_id_26,
  t0.competency AS competency_27,
  t0.action AS action_28,
  t0.return_investment AS return_investment_29,
  t0.is_client_in_out AS is_client_in_out_30,
  t0.is_client_green_patio AS is_client_green_patio_31,
  t0.is_client_av_express AS is_client_av_express_32,
  t0.is_client_develup AS is_client_develup_33,
  t0.typology AS typology_34
FROM
  clients t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33, t0.typology AS typology_34 FROM clients t0 WHERE t0.id = 3159 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 = ?
  AND t0.disabled = ?

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 = 6070 AND t0.disabled = '0';

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

SELECT
  t0.id AS id_1,
  t0.destination_id AS destination_id_2,
  t0.image_large AS image_large_3,
  t0.image_medium AS image_medium_4,
  t0.image_small AS image_small_5,
  t0.created_id AS created_id_6,
  t0.created_at AS created_at_7,
  t0.updated_id AS updated_id_8,
  t0.updated_at AS updated_at_9
FROM
  destinations_gallery t0
WHERE
  t0.destination_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.destination_id AS destination_id_2, t0.image_large AS image_large_3, t0.image_medium AS image_medium_4, t0.image_small AS image_small_5, t0.created_id AS created_id_6, t0.created_at AS created_at_7, t0.updated_id AS updated_id_8, t0.updated_at AS updated_at_9 FROM destinations_gallery t0 WHERE t0.destination_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.destination_id AS destination_id_2,
  t0.language AS language_3,
  t0.description AS description_4,
  t0.created_id AS created_id_5,
  t0.created_at AS created_at_6,
  t0.updated_id AS updated_id_7,
  t0.updated_at AS updated_at_8
FROM
  destinations_description t0
WHERE
  t0.destination_id = ?
  AND t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.destination_id AS destination_id_2, t0.language AS language_3, t0.description AS description_4, t0.created_id AS created_id_5, t0.created_at AS created_at_6, t0.updated_id AS updated_id_7, t0.updated_at AS updated_at_8 FROM destinations_description t0 WHERE t0.destination_id = 2 AND t0.language = 'CASTELLANO' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.id_document AS id_document_3,
  t0.registry AS registry_4,
  t0.address AS address_5,
  t0.zip_code AS zip_code_6,
  t0.telephone AS telephone_7,
  t0.fax AS fax_8,
  t0.email AS email_9,
  t0.note AS note_10,
  t0.note_sin_iva AS note_sin_iva_11,
  t0.created_at AS created_at_12,
  t0.created_id AS created_id_13,
  t0.updated_at AS updated_at_14,
  t0.updated_id AS updated_id_15,
  t0.picture AS picture_16,
  t0.priority AS priority_17,
  t0.token AS token_18
FROM
  settings_company t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company AS company_2, t0.id_document AS id_document_3, t0.registry AS registry_4, t0.address AS address_5, t0.zip_code AS zip_code_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.email AS email_9, t0.note AS note_10, t0.note_sin_iva AS note_sin_iva_11, t0.created_at AS created_at_12, t0.created_id AS created_id_13, t0.updated_at AS updated_at_14, t0.updated_id AS updated_id_15, t0.picture AS picture_16, t0.priority AS priority_17, t0.token AS token_18 FROM settings_company t0 WHERE t0.id = '1' 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 = ?
  AND t0.disabled = ?

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 = 6070 AND t0.disabled = '0';

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.control_destination_id = ?
  AND t0.disabled = ?
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.control_destination_id = 5896 AND t0.disabled = '0' ORDER BY t0.rank ASC;

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

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.id_document AS id_document_3,
  t0.registry AS registry_4,
  t0.address AS address_5,
  t0.zip_code AS zip_code_6,
  t0.telephone AS telephone_7,
  t0.fax AS fax_8,
  t0.email AS email_9,
  t0.note AS note_10,
  t0.note_sin_iva AS note_sin_iva_11,
  t0.created_at AS created_at_12,
  t0.created_id AS created_id_13,
  t0.updated_at AS updated_at_14,
  t0.updated_id AS updated_id_15,
  t0.picture AS picture_16,
  t0.priority AS priority_17,
  t0.token AS token_18
FROM
  settings_company t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company AS company_2, t0.id_document AS id_document_3, t0.registry AS registry_4, t0.address AS address_5, t0.zip_code AS zip_code_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.email AS email_9, t0.note AS note_10, t0.note_sin_iva AS note_sin_iva_11, t0.created_at AS created_at_12, t0.created_id AS created_id_13, t0.updated_at AS updated_at_14, t0.updated_id AS updated_id_15, t0.picture AS picture_16, t0.priority AS priority_17, t0.token AS token_18 FROM settings_company t0 WHERE t0.id = '1' 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 = ?
  AND p0_.direct_payment = ?
ORDER BY
  p0_.service_cat_id ASC,
  p0_.rank 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 = 33545 AND p0_.service_id_father = '0' AND p0_.direct_payment = '0' ORDER BY p0_.service_cat_id ASC, p0_.rank ASC;

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 = 2 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 = ?
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 = 4 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 = 4 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 = 6 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 = ?
  AND p0_.direct_payment = ?
ORDER BY
  p0_.service_cat_id ASC,
  p0_.rank ASC