Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

25 Database Queries

14 Different statements

72.32 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.number AS number_2, t0.prefix AS prefix_3, t0.date_at AS date_at_4, t0.type AS type_5, t0.proposal_id AS proposal_id_6, t0.total_net AS total_net_7, t0.vat AS vat_8, t0.total AS total_9, t0.created_at AS created_at_10, t0.created_id AS created_id_11, t0.updated_at AS updated_at_12, t0.updated_id AS updated_id_13 FROM proposals_invoice t0 WHERE t0.proposal_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 = ? LIMIT 1
SELECT t0.id AS id_1, t0.service_id_proposal AS service_id_proposal_2, t0.service_id_father AS service_id_father_3, t0.control_id AS control_id_4, t0.proposal_id AS proposal_id_5, t0.destination_id AS destination_id_6, t0.idea_id AS idea_id_7, t0.activity_id AS activity_id_8, t0.supplier_id AS supplier_id_9, t0.assistant_id AS assistant_id_10, t0.service_id AS service_id_11, t0.service_cat_id AS service_cat_id_12, t0.service_cat_name AS service_cat_name_13, t0.name AS name_14, t0.price AS price_15, t0.currency AS currency_16, t0.units AS units_17, t0.op_commission AS op_commission_18, t0.commission AS commission_19, t0.op_over AS op_over_20, t0.price_over AS price_over_21, t0.op_iva AS op_iva_22, t0.iva AS iva_23, t0.pax AS pax_24, t0.hour AS hour_25, t0.date_in_at AS date_in_at_26, t0.date_out_at AS date_out_at_27, t0.created_at AS created_at_28, t0.created_id AS created_id_29, t0.updated_at AS updated_at_30, t0.updated_id AS updated_id_31, t0.contcolor AS contcolor_32, t0.`rank` AS rank_33, t0.renovate AS renovate_34, t0.pay AS pay_35 FROM proposals_supplier_services_costs_client t0 WHERE t0.proposal_id = ? AND t0.service_id_father = ? ORDER BY t0.id 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.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 p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`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 = ? 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.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 p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`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.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.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 p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`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.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 c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33, c1_.name AS name_34, r2_.name AS name_35, p3_.name AS name_36, c4_.name AS name_37 FROM clients c0_ INNER JOIN countries c1_ ON (c1_.id = c0_.country) INNER JOIN regions r2_ ON (r2_.id = c0_.region) INNER JOIN provinces p3_ ON (p3_.id = c0_.province) INNER JOIN cities c4_ ON (c4_.id = c0_.population) WHERE c0_.id = ?
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control 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 = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_pay_at AS date_pay_at_3, t0.way_to_pay AS way_to_pay_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_payments_client t0 WHERE t0.proposal_id = ?
SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.to_invoice AS to_invoice_8, t0.fee_total AS fee_total_9, t0.created_id AS created_id_10, t0.created_at AS created_at_11, t0.updated_id AS updated_id_12, t0.updated_at AS updated_at_13 FROM proposal_fee t0 WHERE t0.proposal_id = ?
SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ?
SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.net AS net_3, t0.currency AS currency_4, t0.vat_ten AS vat_ten_5, t0.vat_twenty_one AS vat_twenty_one_6, t0.payments AS payments_7, t0.proposal_id AS proposal_id_8 FROM proposals_invoice_summary t0 WHERE t0.proposal_id = ? LIMIT 1

#▲	Time	Info
1	6.28 ms	SELECT t0.id AS id_1, t0.number AS number_2, t0.prefix AS prefix_3, t0.date_at AS date_at_4, t0.type AS type_5, t0.proposal_id AS proposal_id_6, t0.total_net AS total_net_7, t0.vat AS vat_8, t0.total AS total_9, t0.created_at AS created_at_10, t0.created_id AS created_id_11, t0.updated_at AS updated_at_12, t0.updated_id AS updated_id_13 FROM proposals_invoice t0 WHERE t0.proposal_id = ? LIMIT 1 Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.number AS number_2, t0.prefix AS prefix_3, t0.date_at AS date_at_4, t0.type AS type_5, t0.proposal_id AS proposal_id_6, t0.total_net AS total_net_7, t0.vat AS vat_8, t0.total AS total_9, t0.created_at AS created_at_10, t0.created_id AS created_id_11, t0.updated_at AS updated_at_12, t0.updated_id AS updated_id_13 FROM proposals_invoice t0 WHERE t0.proposal_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.number AS number_2, t0.prefix AS prefix_3, t0.date_at AS date_at_4, t0.type AS type_5, t0.proposal_id AS proposal_id_6, t0.total_net AS total_net_7, t0.vat AS vat_8, t0.total AS total_9, t0.created_at AS created_at_10, t0.created_id AS created_id_11, t0.updated_at AS updated_at_12, t0.updated_id AS updated_id_13 FROM proposals_invoice t0 WHERE t0.proposal_id = '5874' LIMIT 1;
2	0.97 ms	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 Parameters: [`"5874"`] View formatted query View runnable query Explain query 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 = '5874' LIMIT 1;
3	30.80 ms	SELECT t0.id AS id_1, t0.service_id_proposal AS service_id_proposal_2, t0.service_id_father AS service_id_father_3, t0.control_id AS control_id_4, t0.proposal_id AS proposal_id_5, t0.destination_id AS destination_id_6, t0.idea_id AS idea_id_7, t0.activity_id AS activity_id_8, t0.supplier_id AS supplier_id_9, t0.assistant_id AS assistant_id_10, t0.service_id AS service_id_11, t0.service_cat_id AS service_cat_id_12, t0.service_cat_name AS service_cat_name_13, t0.name AS name_14, t0.price AS price_15, t0.currency AS currency_16, t0.units AS units_17, t0.op_commission AS op_commission_18, t0.commission AS commission_19, t0.op_over AS op_over_20, t0.price_over AS price_over_21, t0.op_iva AS op_iva_22, t0.iva AS iva_23, t0.pax AS pax_24, t0.hour AS hour_25, t0.date_in_at AS date_in_at_26, t0.date_out_at AS date_out_at_27, t0.created_at AS created_at_28, t0.created_id AS created_id_29, t0.updated_at AS updated_at_30, t0.updated_id AS updated_id_31, t0.contcolor AS contcolor_32, t0.`rank` AS rank_33, t0.renovate AS renovate_34, t0.pay AS pay_35 FROM proposals_supplier_services_costs_client t0 WHERE t0.proposal_id = ? AND t0.service_id_father = ? ORDER BY t0.id ASC Parameters: [`"5874" "0"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.service_id_proposal AS service_id_proposal_2, t0.service_id_father AS service_id_father_3, t0.control_id AS control_id_4, t0.proposal_id AS proposal_id_5, t0.destination_id AS destination_id_6, t0.idea_id AS idea_id_7, t0.activity_id AS activity_id_8, t0.supplier_id AS supplier_id_9, t0.assistant_id AS assistant_id_10, t0.service_id AS service_id_11, t0.service_cat_id AS service_cat_id_12, t0.service_cat_name AS service_cat_name_13, t0.name AS name_14, t0.price AS price_15, t0.currency AS currency_16, t0.units AS units_17, t0.op_commission AS op_commission_18, t0.commission AS commission_19, t0.op_over AS op_over_20, t0.price_over AS price_over_21, t0.op_iva AS op_iva_22, t0.iva AS iva_23, t0.pax AS pax_24, t0.hour AS hour_25, t0.date_in_at AS date_in_at_26, t0.date_out_at AS date_out_at_27, t0.created_at AS created_at_28, t0.created_id AS created_id_29, t0.updated_at AS updated_at_30, t0.updated_id AS updated_id_31, t0.contcolor AS contcolor_32, t0.`rank` AS rank_33, t0.renovate AS renovate_34, t0.pay AS pay_35 FROM proposals_supplier_services_costs_client t0 WHERE t0.proposal_id = ? AND t0.service_id_father = ? ORDER BY t0.id ASC SELECT t0.id AS id_1, t0.service_id_proposal AS service_id_proposal_2, t0.service_id_father AS service_id_father_3, t0.control_id AS control_id_4, t0.proposal_id AS proposal_id_5, t0.destination_id AS destination_id_6, t0.idea_id AS idea_id_7, t0.activity_id AS activity_id_8, t0.supplier_id AS supplier_id_9, t0.assistant_id AS assistant_id_10, t0.service_id AS service_id_11, t0.service_cat_id AS service_cat_id_12, t0.service_cat_name AS service_cat_name_13, t0.name AS name_14, t0.price AS price_15, t0.currency AS currency_16, t0.units AS units_17, t0.op_commission AS op_commission_18, t0.commission AS commission_19, t0.op_over AS op_over_20, t0.price_over AS price_over_21, t0.op_iva AS op_iva_22, t0.iva AS iva_23, t0.pax AS pax_24, t0.hour AS hour_25, t0.date_in_at AS date_in_at_26, t0.date_out_at AS date_out_at_27, t0.created_at AS created_at_28, t0.created_id AS created_id_29, t0.updated_at AS updated_at_30, t0.updated_id AS updated_id_31, t0.contcolor AS contcolor_32, t0.`rank` AS rank_33, t0.renovate AS renovate_34, t0.pay AS pay_35 FROM proposals_supplier_services_costs_client t0 WHERE t0.proposal_id = '5874' AND t0.service_id_father = '0' ORDER BY t0.id ASC;
4	0.73 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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;
5	0.84 ms	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 Parameters: [`5020`] View formatted query View runnable query Explain query 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 = 5020 LIMIT 1;
6	7.05 ms	SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC Parameters: [`"5874" 5020 "0"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = '5874' AND p0_.supplier_id = 5020 AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = '0' ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC;
7	0.41 ms	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 Parameters: [`5020`] View formatted query View runnable query Explain query 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 = 5020 LIMIT 1;
8	0.25 ms	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 Parameters: [`5020`] View formatted query View runnable query Explain query 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 = 5020 LIMIT 1;
9	0.25 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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;
10	0.66 ms	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 Parameters: [`5024`] View formatted query View runnable query Explain query 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 = 5024 LIMIT 1;
11	6.80 ms	SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC Parameters: [`"5874" 5024 "0"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = '5874' AND p0_.supplier_id = 5024 AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = '0' ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC;
12	0.32 ms	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 Parameters: [`5024`] View formatted query View runnable query Explain query 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 = 5024 LIMIT 1;
13	0.19 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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;
14	0.51 ms	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 Parameters: [`4744`] View formatted query View runnable query Explain query 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 = 4744 LIMIT 1;
15	6.65 ms	SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC Parameters: [`"5874" 4744 "0"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = ? AND p0_.supplier_id = ? AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = ? ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC SELECT p0_.id AS id_0, p0_.service_id_proposal AS service_id_proposal_1, p0_.service_id_father AS service_id_father_2, p0_.control_id AS control_id_3, p0_.proposal_id AS proposal_id_4, p0_.destination_id AS destination_id_5, p0_.idea_id AS idea_id_6, p0_.activity_id AS activity_id_7, p0_.supplier_id AS supplier_id_8, p0_.assistant_id AS assistant_id_9, p0_.service_id AS service_id_10, p0_.service_cat_id AS service_cat_id_11, p0_.service_cat_name AS service_cat_name_12, p0_.name AS name_13, p0_.price AS price_14, p0_.currency AS currency_15, p0_.units AS units_16, p0_.op_commission AS op_commission_17, p0_.commission AS commission_18, p0_.op_over AS op_over_19, p0_.price_over AS price_over_20, p0_.op_iva AS op_iva_21, p0_.iva AS iva_22, p0_.pax AS pax_23, p0_.hour AS hour_24, p0_.date_in_at AS date_in_at_25, p0_.date_out_at AS date_out_at_26, p0_.created_at AS created_at_27, p0_.created_id AS created_id_28, p0_.updated_at AS updated_at_29, p0_.updated_id AS updated_id_30, p0_.contcolor AS contcolor_31, p0_.`rank` AS rank_32, p0_.renovate AS renovate_33, p0_.pay AS pay_34 FROM proposals_supplier_services_costs_client p0_ WHERE p0_.proposal_id = '5874' AND p0_.supplier_id = 4744 AND p0_.idea_id IS NULL AND p0_.activity_id IS NULL AND p0_.service_id_father = '0' ORDER BY p0_.service_cat_id ASC, p0_.`rank` ASC;
16	0.26 ms	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 Parameters: [`4744`] View formatted query View runnable query Explain query 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 = 4744 LIMIT 1;
17	0.81 ms	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 Parameters: [`"1"`] View formatted query View runnable query Explain query 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;
18	1.21 ms	SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33, c1_.name AS name_34, r2_.name AS name_35, p3_.name AS name_36, c4_.name AS name_37 FROM clients c0_ INNER JOIN countries c1_ ON (c1_.id = c0_.country) INNER JOIN regions r2_ ON (r2_.id = c0_.region) INNER JOIN provinces p3_ ON (p3_.id = c0_.province) INNER JOIN cities c4_ ON (c4_.id = c0_.population) WHERE c0_.id = ? Parameters: [`4285`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33, c1_.name AS name_34, r2_.name AS name_35, p3_.name AS name_36, c4_.name AS name_37 FROM clients c0_ INNER JOIN countries c1_ ON (c1_.id = c0_.country) INNER JOIN regions r2_ ON (r2_.id = c0_.region) INNER JOIN provinces p3_ ON (p3_.id = c0_.province) INNER JOIN cities c4_ ON (c4_.id = c0_.population) WHERE c0_.id = ? SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33, c1_.name AS name_34, r2_.name AS name_35, p3_.name AS name_36, c4_.name AS name_37 FROM clients c0_ INNER JOIN countries c1_ ON (c1_.id = c0_.country) INNER JOIN regions r2_ ON (r2_.id = c0_.region) INNER JOIN provinces p3_ ON (p3_.id = c0_.province) INNER JOIN cities c4_ ON (c4_.id = c0_.population) WHERE c0_.id = 4285;
19	2.02 ms	SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control t0 WHERE t0.proposal_id = ? Parameters: [`5874`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control t0 WHERE t0.proposal_id = ? SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control t0 WHERE t0.proposal_id = 5874;
20	0.76 ms	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 = ? Parameters: [`"5874"`] View formatted query View runnable query Explain query 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 = '5874';
21	1.72 ms	SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_pay_at AS date_pay_at_3, t0.way_to_pay AS way_to_pay_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_payments_client t0 WHERE t0.proposal_id = ? Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_pay_at AS date_pay_at_3, t0.way_to_pay AS way_to_pay_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_payments_client t0 WHERE t0.proposal_id = ? SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_pay_at AS date_pay_at_3, t0.way_to_pay AS way_to_pay_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_payments_client t0 WHERE t0.proposal_id = '5874';
22	1.00 ms	SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.to_invoice AS to_invoice_8, t0.fee_total AS fee_total_9, t0.created_id AS created_id_10, t0.created_at AS created_at_11, t0.updated_id AS updated_id_12, t0.updated_at AS updated_at_13 FROM proposal_fee t0 WHERE t0.proposal_id = ? Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.to_invoice AS to_invoice_8, t0.fee_total AS fee_total_9, t0.created_id AS created_id_10, t0.created_at AS created_at_11, t0.updated_id AS updated_id_12, t0.updated_at AS updated_at_13 FROM proposal_fee t0 WHERE t0.proposal_id = ? SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.to_invoice AS to_invoice_8, t0.fee_total AS fee_total_9, t0.created_id AS created_id_10, t0.created_at AS created_at_11, t0.updated_id AS updated_id_12, t0.updated_at AS updated_at_13 FROM proposal_fee t0 WHERE t0.proposal_id = '5874';
23	0.88 ms	SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ? Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ? SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = '5874';
24	0.22 ms	SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ? Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = ? SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.type AS type_4, t0.amount AS amount_5, t0.op_iva AS op_iva_6, t0.iva AS iva_7, t0.invoice_id AS invoice_id_8, t0.fee_net AS fee_net_9, t0.to_invoice AS to_invoice_10, t0.fee_total AS fee_total_11, t0.created_id AS created_id_12, t0.created_at AS created_at_13 FROM proposal_fee_invoice t0 WHERE t0.proposal_id = '5874';
25	0.73 ms	SELECT t0.id AS id_1, t0.description AS description_2, t0.net AS net_3, t0.currency AS currency_4, t0.vat_ten AS vat_ten_5, t0.vat_twenty_one AS vat_twenty_one_6, t0.payments AS payments_7, t0.proposal_id AS proposal_id_8 FROM proposals_invoice_summary t0 WHERE t0.proposal_id = ? LIMIT 1 Parameters: [`"5874"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.net AS net_3, t0.currency AS currency_4, t0.vat_ten AS vat_ten_5, t0.vat_twenty_one AS vat_twenty_one_6, t0.payments AS payments_7, t0.proposal_id AS proposal_id_8 FROM proposals_invoice_summary t0 WHERE t0.proposal_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.description AS description_2, t0.net AS net_3, t0.currency AS currency_4, t0.vat_ten AS vat_ten_5, t0.vat_twenty_one AS vat_twenty_one_6, t0.payments AS payments_7, t0.proposal_id AS proposal_id_8 FROM proposals_invoice_summary t0 WHERE t0.proposal_id = '5874' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\MDS\EventsBundle\Entity\ProposalInvoice	No errors.
App\MDS\EventsBundle\Entity\Proposal	No errors.
App\MDS\EventsBundle\Entity\ProposalSupplierServicesCostsClient	No errors.
App\Entity\Destination	No errors.
App\Entity\Supplier	No errors.
App\Entity\SettingsCompany	No errors.
App\Entity\Client	No errors.
App\Entity\Country	No errors.
App\Entity\Regions	No errors.
App\Entity\Provinces	No errors.
App\Entity\Cities	No errors.
App\MDS\EventsBundle\Entity\ProposalInvoiceDepositControl	No errors.
App\MDS\EventsBundle\Entity\ProposalDiscount	No errors.
App\MDS\EventsBundle\Entity\ProposalPaymentsClient	No errors.
App\MDS\EventsBundle\Entity\ProposalFee	No errors.
App\MDS\EventsBundle\Entity\ProposalFeeInvoice	No errors.
App\Entity\ProposalsInvoiceSummary	No errors.

Symfony Profiler

https://inout.mante.solutions/presentation/proposal/invoice/print/5874

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping