Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

57 Database Queries

34 Different statements

67.51 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
28.90 ms (42.81%)	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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0 Parameters: [] 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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0 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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0;
20.09 ms (29.76%)	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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_ Parameters: [] 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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_ 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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_;
4.80 ms (7.11%)	1	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.rankListing AS rankListing_3, t0.titleOne AS titleOne_4, t0.titleTwo AS titleTwo_5, t0.titleThree AS titleThree_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.description AS description_9, t0.picture AS picture_10, t0.sourceId AS sourceId_11, t0.sourceType AS sourceType_12, t0.createdAt AS createdAt_13, t0.createdId AS createdId_14, t0.updatedAt AS updatedAt_15, t0.updatedId AS updatedId_16 FROM reservation_agenda_item t0 WHERE t0.reservationId = ? Parameters: [`"15887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.rankListing AS rankListing_3, t0.titleOne AS titleOne_4, t0.titleTwo AS titleTwo_5, t0.titleThree AS titleThree_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.description AS description_9, t0.picture AS picture_10, t0.sourceId AS sourceId_11, t0.sourceType AS sourceType_12, t0.createdAt AS createdAt_13, t0.createdId AS createdId_14, t0.updatedAt AS updatedAt_15, t0.updatedId AS updatedId_16 FROM reservation_agenda_item t0 WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.rankListing AS rankListing_3, t0.titleOne AS titleOne_4, t0.titleTwo AS titleTwo_5, t0.titleThree AS titleThree_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.description AS description_9, t0.picture AS picture_10, t0.sourceId AS sourceId_11, t0.sourceType AS sourceType_12, t0.createdAt AS createdAt_13, t0.createdId AS createdId_14, t0.updatedAt AS updatedAt_15, t0.updatedId AS updatedId_16 FROM reservation_agenda_item t0 WHERE t0.reservationId = '15887';
1.92 ms (2.84%)	12	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.lngControlId = ? LIMIT 1 Parameters: [`26294`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.lngControlId = ? LIMIT 1 SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.lngControlId = 26294 LIMIT 1;
1.35 ms (2.01%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = 15887;
1.21 ms (1.79%)	2	SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = ? LIMIT 1 Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = 15887 LIMIT 1;
1.12 ms (1.66%)	5	SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 15887;
1.08 ms (1.60%)	1	SELECT r0_.id AS id_0, r0_.loungeId AS loungeId_1, r0_.periodId AS periodId_2, r0_.price AS price_3, r0_.description AS description_4, r0_.created_id AS created_id_5, r0_.created_at AS created_at_6, r0_.updated_id AS updated_id_7, r0_.updated_at AS updated_at_8, r0_.year1 AS year1_9, r0_.year2 AS year2_10, r0_.month1 AS month1_11, r0_.month2 AS month2_12, r0_.month3 AS month3_13, r0_.month4 AS month4_14, r0_.month5 AS month5_15, r0_.month6 AS month6_16, r0_.month7 AS month7_17, r0_.month8 AS month8_18, r0_.month9 AS month9_19, r0_.month10 AS month10_20, r0_.month11 AS month11_21, r0_.month12 AS month12_22, r0_.day1 AS day1_23, r0_.day2 AS day2_24, r0_.day3 AS day3_25, r0_.day4 AS day4_26, r0_.day5 AS day5_27, r0_.day6 AS day6_28, r0_.day7 AS day7_29, r0_.title AS title_30, r0_.priceIsActive AS priceIsActive_31, r0_.dateStart AS dateStart_32, r0_.dateEnd AS dateEnd_33, r0_.type_price AS type_price_34, r0_.level_price AS level_price_35 FROM reservation_lounge_profile r0_ Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.loungeId AS loungeId_1, r0_.periodId AS periodId_2, r0_.price AS price_3, r0_.description AS description_4, r0_.created_id AS created_id_5, r0_.created_at AS created_at_6, r0_.updated_id AS updated_id_7, r0_.updated_at AS updated_at_8, r0_.year1 AS year1_9, r0_.year2 AS year2_10, r0_.month1 AS month1_11, r0_.month2 AS month2_12, r0_.month3 AS month3_13, r0_.month4 AS month4_14, r0_.month5 AS month5_15, r0_.month6 AS month6_16, r0_.month7 AS month7_17, r0_.month8 AS month8_18, r0_.month9 AS month9_19, r0_.month10 AS month10_20, r0_.month11 AS month11_21, r0_.month12 AS month12_22, r0_.day1 AS day1_23, r0_.day2 AS day2_24, r0_.day3 AS day3_25, r0_.day4 AS day4_26, r0_.day5 AS day5_27, r0_.day6 AS day6_28, r0_.day7 AS day7_29, r0_.title AS title_30, r0_.priceIsActive AS priceIsActive_31, r0_.dateStart AS dateStart_32, r0_.dateEnd AS dateEnd_33, r0_.type_price AS type_price_34, r0_.level_price AS level_price_35 FROM reservation_lounge_profile r0_ SELECT r0_.id AS id_0, r0_.loungeId AS loungeId_1, r0_.periodId AS periodId_2, r0_.price AS price_3, r0_.description AS description_4, r0_.created_id AS created_id_5, r0_.created_at AS created_at_6, r0_.updated_id AS updated_id_7, r0_.updated_at AS updated_at_8, r0_.year1 AS year1_9, r0_.year2 AS year2_10, r0_.month1 AS month1_11, r0_.month2 AS month2_12, r0_.month3 AS month3_13, r0_.month4 AS month4_14, r0_.month5 AS month5_15, r0_.month6 AS month6_16, r0_.month7 AS month7_17, r0_.month8 AS month8_18, r0_.month9 AS month9_19, r0_.month10 AS month10_20, r0_.month11 AS month11_21, r0_.month12 AS month12_22, r0_.day1 AS day1_23, r0_.day2 AS day2_24, r0_.day3 AS day3_25, r0_.day4 AS day4_26, r0_.day5 AS day5_27, r0_.day6 AS day6_28, r0_.day7 AS day7_29, r0_.title AS title_30, r0_.priceIsActive AS priceIsActive_31, r0_.dateStart AS dateStart_32, r0_.dateEnd AS dateEnd_33, r0_.type_price AS type_price_34, r0_.level_price AS level_price_35 FROM reservation_lounge_profile r0_;
0.74 ms (1.10%)	2	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.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = ? LIMIT 1 Parameters: [`"gabriela.bracho@greenpatio.es"`] View formatted query View runnable query Explain query 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.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 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.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = 'gabriela.bracho@greenpatio.es' LIMIT 1;
0.54 ms (0.80%)	3	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = 15887;
0.45 ms (0.67%)	1	SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_;
0.43 ms (0.64%)	2	SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19, t20.id AS id_21, t20.sage_delivery_number AS sage_delivery_number_22, t20.sage_invoice_number AS sage_invoice_number_23, t20.sage_almacen AS sage_almacen_24, t20.factured AS factured_25, t20.is_rectificative AS is_rectificative_26, t20.sent_to_sage AS sent_to_sage_27, t20.sync_date AS sync_date_28, t20.factured_at AS factured_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.last_error AS last_error_32, t20.letter AS letter_33, t20.pdf AS pdf_34, t20.client_id AS client_id_35, t20.rectifies_id AS rectifies_id_36, t20.sage_company_id AS sage_company_id_37, t20.reservation_invoice_id AS reservation_invoice_id_38, t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39, t40.id AS id_41, t40.prefix AS prefix_42, t40.number AS number_43, t40.date_at AS date_at_44, t40.reservation_id AS reservation_id_45, t40.name AS name_46, t40.amount AS amount_47, t40.iva AS iva_48, t40.total AS total_49, t40.created_at AS created_at_50, t40.created_id AS created_id_51, t40.updated_at AS updated_at_52, t40.updated_id AS updated_id_53, t40.sage_iva AS sage_iva_54, t40.reservation_invoice_id AS reservation_invoice_id_55 FROM reservation_invoice t0 LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id LEFT JOIN reservation_proforma_deposit t40 ON t40.reservation_invoice_id = t0.id WHERE t0.reservationId = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19, t20.id AS id_21, t20.sage_delivery_number AS sage_delivery_number_22, t20.sage_invoice_number AS sage_invoice_number_23, t20.sage_almacen AS sage_almacen_24, t20.factured AS factured_25, t20.is_rectificative AS is_rectificative_26, t20.sent_to_sage AS sent_to_sage_27, t20.sync_date AS sync_date_28, t20.factured_at AS factured_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.last_error AS last_error_32, t20.letter AS letter_33, t20.pdf AS pdf_34, t20.client_id AS client_id_35, t20.rectifies_id AS rectifies_id_36, t20.sage_company_id AS sage_company_id_37, t20.reservation_invoice_id AS reservation_invoice_id_38, t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39, t40.id AS id_41, t40.prefix AS prefix_42, t40.number AS number_43, t40.date_at AS date_at_44, t40.reservation_id AS reservation_id_45, t40.name AS name_46, t40.amount AS amount_47, t40.iva AS iva_48, t40.total AS total_49, t40.created_at AS created_at_50, t40.created_id AS created_id_51, t40.updated_at AS updated_at_52, t40.updated_id AS updated_id_53, t40.sage_iva AS sage_iva_54, t40.reservation_invoice_id AS reservation_invoice_id_55 FROM reservation_invoice t0 LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id LEFT JOIN reservation_proforma_deposit t40 ON t40.reservation_invoice_id = t0.id WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19, t20.id AS id_21, t20.sage_delivery_number AS sage_delivery_number_22, t20.sage_invoice_number AS sage_invoice_number_23, t20.sage_almacen AS sage_almacen_24, t20.factured AS factured_25, t20.is_rectificative AS is_rectificative_26, t20.sent_to_sage AS sent_to_sage_27, t20.sync_date AS sync_date_28, t20.factured_at AS factured_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.last_error AS last_error_32, t20.letter AS letter_33, t20.pdf AS pdf_34, t20.client_id AS client_id_35, t20.rectifies_id AS rectifies_id_36, t20.sage_company_id AS sage_company_id_37, t20.reservation_invoice_id AS reservation_invoice_id_38, t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39, t40.id AS id_41, t40.prefix AS prefix_42, t40.number AS number_43, t40.date_at AS date_at_44, t40.reservation_id AS reservation_id_45, t40.name AS name_46, t40.amount AS amount_47, t40.iva AS iva_48, t40.total AS total_49, t40.created_at AS created_at_50, t40.created_id AS created_id_51, t40.updated_at AS updated_at_52, t40.updated_id AS updated_id_53, t40.sage_iva AS sage_iva_54, t40.reservation_invoice_id AS reservation_invoice_id_55 FROM reservation_invoice t0 LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id LEFT JOIN reservation_proforma_deposit t40 ON t40.reservation_invoice_id = t0.id WHERE t0.reservationId = 15887;
0.43 ms (0.63%)	3	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.srvControlId = ? LIMIT 1 Parameters: [`13978`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.srvControlId = ? LIMIT 1 SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52, t53.id AS id_54, t53.controlId AS controlId_55, t53.name AS name_56, t53.amount AS amount_57, t53.iva AS iva_58, t53.reservation_id AS reservation_id_59, t53.created_at AS created_at_60, t53.created_id AS created_id_61, t53.updated_at AS updated_at_62, t53.updated_id AS updated_id_63, t53.reservation_invoice_item_id AS reservation_invoice_item_id_64 FROM reservation_invoice_items t0 LEFT JOIN reservation_invoice_deposit_items t53 ON t53.reservation_invoice_item_id = t0.id WHERE t0.srvControlId = 13978 LIMIT 1;
0.32 ms (0.48%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21, t0.space_id AS space_id_22 FROM reservation_lounge_details t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21, t0.space_id AS space_id_22 FROM reservation_lounge_details t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21, t0.space_id AS space_id_22 FROM reservation_lounge_details t0;
0.32 ms (0.47%)	2	SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.invoiceToRec AS invoiceToRec_16, t0.client_name AS client_name_17, t0.client_address AS client_address_18, t0.client_document AS client_document_19, t0.client_type AS client_type_20, t21.id AS id_22, t21.sage_delivery_number AS sage_delivery_number_23, t21.sage_invoice_number AS sage_invoice_number_24, t21.sage_almacen AS sage_almacen_25, t21.factured AS factured_26, t21.is_rectificative AS is_rectificative_27, t21.sent_to_sage AS sent_to_sage_28, t21.sync_date AS sync_date_29, t21.factured_at AS factured_at_30, t21.created_at AS created_at_31, t21.updated_at AS updated_at_32, t21.last_error AS last_error_33, t21.letter AS letter_34, t21.pdf AS pdf_35, t21.client_id AS client_id_36, t21.rectifies_id AS rectifies_id_37, t21.sage_company_id AS sage_company_id_38, t21.reservation_invoice_id AS reservation_invoice_id_39, t21.reservation_invoice_rec_id AS reservation_invoice_rec_id_40 FROM reservation_invoice_rec t0 LEFT JOIN delivery_note t21 ON t21.reservation_invoice_rec_id = t0.id WHERE t0.reservationId = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.invoiceToRec AS invoiceToRec_16, t0.client_name AS client_name_17, t0.client_address AS client_address_18, t0.client_document AS client_document_19, t0.client_type AS client_type_20, t21.id AS id_22, t21.sage_delivery_number AS sage_delivery_number_23, t21.sage_invoice_number AS sage_invoice_number_24, t21.sage_almacen AS sage_almacen_25, t21.factured AS factured_26, t21.is_rectificative AS is_rectificative_27, t21.sent_to_sage AS sent_to_sage_28, t21.sync_date AS sync_date_29, t21.factured_at AS factured_at_30, t21.created_at AS created_at_31, t21.updated_at AS updated_at_32, t21.last_error AS last_error_33, t21.letter AS letter_34, t21.pdf AS pdf_35, t21.client_id AS client_id_36, t21.rectifies_id AS rectifies_id_37, t21.sage_company_id AS sage_company_id_38, t21.reservation_invoice_id AS reservation_invoice_id_39, t21.reservation_invoice_rec_id AS reservation_invoice_rec_id_40 FROM reservation_invoice_rec t0 LEFT JOIN delivery_note t21 ON t21.reservation_invoice_rec_id = t0.id WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.invoiceToRec AS invoiceToRec_16, t0.client_name AS client_name_17, t0.client_address AS client_address_18, t0.client_document AS client_document_19, t0.client_type AS client_type_20, t21.id AS id_22, t21.sage_delivery_number AS sage_delivery_number_23, t21.sage_invoice_number AS sage_invoice_number_24, t21.sage_almacen AS sage_almacen_25, t21.factured AS factured_26, t21.is_rectificative AS is_rectificative_27, t21.sent_to_sage AS sent_to_sage_28, t21.sync_date AS sync_date_29, t21.factured_at AS factured_at_30, t21.created_at AS created_at_31, t21.updated_at AS updated_at_32, t21.last_error AS last_error_33, t21.letter AS letter_34, t21.pdf AS pdf_35, t21.client_id AS client_id_36, t21.rectifies_id AS rectifies_id_37, t21.sage_company_id AS sage_company_id_38, t21.reservation_invoice_id AS reservation_invoice_id_39, t21.reservation_invoice_rec_id AS reservation_invoice_rec_id_40 FROM reservation_invoice_rec t0 LEFT JOIN delivery_note t21 ON t21.reservation_invoice_rec_id = t0.id WHERE t0.reservationId = 15887;
0.28 ms (0.42%)	1	SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.created_at AS created_at_3, t0.created_id AS created_id_4, t0.updated_at AS updated_at_5, t0.updated_id AS updated_id_6, t0.date_at AS date_at_7, t0.booking_data AS booking_data_8, t0.client_proxy AS client_proxy_9, t0.client_job AS client_job_10, t0.model_id AS model_id_11, t0.reservation_id AS reservation_id_12 FROM doc_contract t0 WHERE t0.reservation_id = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.created_at AS created_at_3, t0.created_id AS created_id_4, t0.updated_at AS updated_at_5, t0.updated_id AS updated_id_6, t0.date_at AS date_at_7, t0.booking_data AS booking_data_8, t0.client_proxy AS client_proxy_9, t0.client_job AS client_job_10, t0.model_id AS model_id_11, t0.reservation_id AS reservation_id_12 FROM doc_contract t0 WHERE t0.reservation_id = ? SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.created_at AS created_at_3, t0.created_id AS created_id_4, t0.updated_at AS updated_at_5, t0.updated_id AS updated_id_6, t0.date_at AS date_at_7, t0.booking_data AS booking_data_8, t0.client_proxy AS client_proxy_9, t0.client_job AS client_job_10, t0.model_id AS model_id_11, t0.reservation_id AS reservation_id_12 FROM doc_contract t0 WHERE t0.reservation_id = 15887;
0.27 ms (0.39%)	1	SELECT s0_.id AS id_0, s0_.company AS company_1, s0_.group_id AS group_id_2, s0_.contact AS contact_3, s0_.type_document AS type_document_4, s0_.id_document AS id_document_5, s0_.address AS address_6, s0_.population AS population_7, s0_.province AS province_8, s0_.region AS region_9, s0_.zip_code AS zip_code_10, s0_.country AS country_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.email AS email_14, s0_.type AS type_15, s0_.tags AS tags_16, s0_.preference AS preference_17, s0_.created_id AS created_id_18, s0_.created_at AS created_at_19, s0_.updated_id AS updated_id_20, s0_.updated_at AS updated_at_21, s0_.state AS state_22, s0_.picture AS picture_23, s0_.observation AS observation_24, s0_.terms AS terms_25, s0_.star AS star_26, s0_.name AS name_27, s0_.url AS url_28, s0_.commission AS commission_29, s0_.iva AS iva_30, s0_.accommodation AS accommodation_31, s0_.is_supplier_in_out AS is_supplier_in_out_32, s0_.is_supplier_green_patio AS is_supplier_green_patio_33, s0_.is_supplier_av_express AS is_supplier_av_express_34, s0_.is_supplier_develup AS is_supplier_develup_35, s0_.typology AS typology_36, s0_.sage_code AS sage_code_37, s0_.iban AS iban_38, s0_.swift AS swift_39, s0_.bank_name AS bank_name_40, s0_.sent_to_sage AS sent_to_sage_41, s0_.sync_date AS sync_date_42, s0_.sage_payment_method_id AS sage_payment_method_id_43, s0_.supplier_id AS supplier_id_44 FROM suppliers s0_ WHERE s0_.tags LIKE ? AND s0_.company <> ? ORDER BY s0_.company ASC Parameters: [`"%CATERING%" "HIGO & TRIGO, S.L."`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.company AS company_1, s0_.group_id AS group_id_2, s0_.contact AS contact_3, s0_.type_document AS type_document_4, s0_.id_document AS id_document_5, s0_.address AS address_6, s0_.population AS population_7, s0_.province AS province_8, s0_.region AS region_9, s0_.zip_code AS zip_code_10, s0_.country AS country_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.email AS email_14, s0_.type AS type_15, s0_.tags AS tags_16, s0_.preference AS preference_17, s0_.created_id AS created_id_18, s0_.created_at AS created_at_19, s0_.updated_id AS updated_id_20, s0_.updated_at AS updated_at_21, s0_.state AS state_22, s0_.picture AS picture_23, s0_.observation AS observation_24, s0_.terms AS terms_25, s0_.star AS star_26, s0_.name AS name_27, s0_.url AS url_28, s0_.commission AS commission_29, s0_.iva AS iva_30, s0_.accommodation AS accommodation_31, s0_.is_supplier_in_out AS is_supplier_in_out_32, s0_.is_supplier_green_patio AS is_supplier_green_patio_33, s0_.is_supplier_av_express AS is_supplier_av_express_34, s0_.is_supplier_develup AS is_supplier_develup_35, s0_.typology AS typology_36, s0_.sage_code AS sage_code_37, s0_.iban AS iban_38, s0_.swift AS swift_39, s0_.bank_name AS bank_name_40, s0_.sent_to_sage AS sent_to_sage_41, s0_.sync_date AS sync_date_42, s0_.sage_payment_method_id AS sage_payment_method_id_43, s0_.supplier_id AS supplier_id_44 FROM suppliers s0_ WHERE s0_.tags LIKE ? AND s0_.company <> ? ORDER BY s0_.company ASC SELECT s0_.id AS id_0, s0_.company AS company_1, s0_.group_id AS group_id_2, s0_.contact AS contact_3, s0_.type_document AS type_document_4, s0_.id_document AS id_document_5, s0_.address AS address_6, s0_.population AS population_7, s0_.province AS province_8, s0_.region AS region_9, s0_.zip_code AS zip_code_10, s0_.country AS country_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.email AS email_14, s0_.type AS type_15, s0_.tags AS tags_16, s0_.preference AS preference_17, s0_.created_id AS created_id_18, s0_.created_at AS created_at_19, s0_.updated_id AS updated_id_20, s0_.updated_at AS updated_at_21, s0_.state AS state_22, s0_.picture AS picture_23, s0_.observation AS observation_24, s0_.terms AS terms_25, s0_.star AS star_26, s0_.name AS name_27, s0_.url AS url_28, s0_.commission AS commission_29, s0_.iva AS iva_30, s0_.accommodation AS accommodation_31, s0_.is_supplier_in_out AS is_supplier_in_out_32, s0_.is_supplier_green_patio AS is_supplier_green_patio_33, s0_.is_supplier_av_express AS is_supplier_av_express_34, s0_.is_supplier_develup AS is_supplier_develup_35, s0_.typology AS typology_36, s0_.sage_code AS sage_code_37, s0_.iban AS iban_38, s0_.swift AS swift_39, s0_.bank_name AS bank_name_40, s0_.sent_to_sage AS sent_to_sage_41, s0_.sync_date AS sync_date_42, s0_.sage_payment_method_id AS sage_payment_method_id_43, s0_.supplier_id AS supplier_id_44 FROM suppliers s0_ WHERE s0_.tags LIKE '%CATERING%' AND s0_.company <> 'HIGO & TRIGO, S.L.' ORDER BY s0_.company ASC;
0.26 ms (0.39%)	1	SELECT t0.id AS id_1, t0.dateAt AS dateAt_2, t0.text AS text_3, t0.agent_id AS agent_id_4, t0.reservation_id AS reservation_id_5, t0.viewed AS viewed_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 reservation_tracing t0 WHERE t0.reservation_id = ? ORDER BY t0.created_at DESC Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.dateAt AS dateAt_2, t0.text AS text_3, t0.agent_id AS agent_id_4, t0.reservation_id AS reservation_id_5, t0.viewed AS viewed_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 reservation_tracing t0 WHERE t0.reservation_id = ? ORDER BY t0.created_at DESC SELECT t0.id AS id_1, t0.dateAt AS dateAt_2, t0.text AS text_3, t0.agent_id AS agent_id_4, t0.reservation_id AS reservation_id_5, t0.viewed AS viewed_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 reservation_tracing t0 WHERE t0.reservation_id = 15887 ORDER BY t0.created_at DESC;
0.25 ms (0.37%)	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.created_at AS created_at_11, t0.created_id AS created_id_12, t0.updated_at AS updated_at_13, t0.updated_id AS updated_id_14, t0.picture AS picture_15, t0.token AS token_16, t0.sage_company AS sage_company_17, t0.sage_group AS sage_group_18, t0.comision AS comision_19, t0.priority AS priority_20, t0.business_type AS business_type_21, t0.state AS state_22, t0.supplier_id AS supplier_id_23 FROM settings_company t0 WHERE t0.business_type = ? LIMIT 1 Parameters: [`"venues"`] 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.created_at AS created_at_11, t0.created_id AS created_id_12, t0.updated_at AS updated_at_13, t0.updated_id AS updated_id_14, t0.picture AS picture_15, t0.token AS token_16, t0.sage_company AS sage_company_17, t0.sage_group AS sage_group_18, t0.comision AS comision_19, t0.priority AS priority_20, t0.business_type AS business_type_21, t0.state AS state_22, t0.supplier_id AS supplier_id_23 FROM settings_company t0 WHERE t0.business_type = ? 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.created_at AS created_at_11, t0.created_id AS created_id_12, t0.updated_at AS updated_at_13, t0.updated_id AS updated_id_14, t0.picture AS picture_15, t0.token AS token_16, t0.sage_company AS sage_company_17, t0.sage_group AS sage_group_18, t0.comision AS comision_19, t0.priority AS priority_20, t0.business_type AS business_type_21, t0.state AS state_22, t0.supplier_id AS supplier_id_23 FROM settings_company t0 WHERE t0.business_type = 'venues' LIMIT 1;
0.24 ms (0.35%)	1	SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = ? LIMIT 1 Parameters: [`"venues"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = ? LIMIT 1 SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = 'venues' LIMIT 1;
0.23 ms (0.34%)	1	SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC;
0.22 ms (0.32%)	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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0 WHERE t0.id = ? Parameters: [`4765`] 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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0 WHERE t0.id = ? 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, t0.sage_code AS sage_code_38, t0.iban AS iban_39, t0.swift AS swift_40, t0.bank_name AS bank_name_41, t0.sent_to_sage AS sent_to_sage_42, t0.sync_date AS sync_date_43, t0.sage_payment_method_id AS sage_payment_method_id_44, t0.supplier_id AS supplier_id_45 FROM suppliers t0 WHERE t0.id = 4765;
0.22 ms (0.32%)	1	SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0;
0.19 ms (0.28%)	1	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = ? AND t0.isDone = ? Parameters: [`15887 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = ? AND t0.isDone = ? SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = 15887 AND t0.isDone = 1;
0.18 ms (0.27%)	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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_ INNER JOIN client_settings_company c2_ ON c0_.id = c2_.client_id INNER JOIN settings_company s1_ ON s1_.id = c2_.settings_company_id WHERE s1_.id = ? ORDER BY c0_.name ASC Parameters: [`7`] 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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_ INNER JOIN client_settings_company c2_ ON c0_.id = c2_.client_id INNER JOIN settings_company s1_ ON s1_.id = c2_.settings_company_id WHERE s1_.id = ? ORDER BY c0_.name ASC 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_.created_at AS created_at_18, c0_.created_id AS created_id_19, c0_.updated_at AS updated_at_20, c0_.updated_id AS updated_id_21, c0_.status AS status_22, c0_.picture AS picture_23, c0_.competency AS competency_24, c0_.action AS action_25, c0_.return_investment AS return_investment_26, c0_.typology AS typology_27, c0_.sage_code AS sage_code_28, c0_.iban AS iban_29, c0_.swift AS swift_30, c0_.bank_name AS bank_name_31, c0_.sent_to_sage AS sent_to_sage_32, c0_.sync_date AS sync_date_33, c0_.sage_payment_method_id AS sage_payment_method_id_34 FROM clients c0_ INNER JOIN client_settings_company c2_ ON c0_.id = c2_.client_id INNER JOIN settings_company s1_ ON s1_.id = c2_.settings_company_id WHERE s1_.id = 7 ORDER BY c0_.name ASC;
0.18 ms (0.27%)	1	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.agentId AS agentId_3, t0.agentMail AS agentMail_4, t0.clientId AS clientId_5, t0.clientMail AS clientMail_6, t0.alertDateTime AS alertDateTime_7, t0.alertSended AS alertSended_8, t0.cancelDateTime AS cancelDateTime_9, t0.cancelSended AS cancelSended_10, t0.created_at AS created_at_11, t0.created_id AS created_id_12, t0.oldReservationId AS oldReservationId_13 FROM reservation_mail_alert_client t0 WHERE t0.reservationId = ? LIMIT 1 Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.agentId AS agentId_3, t0.agentMail AS agentMail_4, t0.clientId AS clientId_5, t0.clientMail AS clientMail_6, t0.alertDateTime AS alertDateTime_7, t0.alertSended AS alertSended_8, t0.cancelDateTime AS cancelDateTime_9, t0.cancelSended AS cancelSended_10, t0.created_at AS created_at_11, t0.created_id AS created_id_12, t0.oldReservationId AS oldReservationId_13 FROM reservation_mail_alert_client t0 WHERE t0.reservationId = ? LIMIT 1 SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.agentId AS agentId_3, t0.agentMail AS agentMail_4, t0.clientId AS clientId_5, t0.clientMail AS clientMail_6, t0.alertDateTime AS alertDateTime_7, t0.alertSended AS alertSended_8, t0.cancelDateTime AS cancelDateTime_9, t0.cancelSended AS cancelSended_10, t0.created_at AS created_at_11, t0.created_id AS created_id_12, t0.oldReservationId AS oldReservationId_13 FROM reservation_mail_alert_client t0 WHERE t0.reservationId = 15887 LIMIT 1;
0.18 ms (0.26%)	1	SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.status AS status_12, u0_.team_leader AS team_leader_13, u0_.role AS role_14, u0_.access_key AS access_key_15, u0_.language AS language_16, u0_.color AS color_17, u0_.sidebar AS sidebar_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.description AS description_21, u0_.job_title AS job_title_22, u0_.id_office AS id_office_23, u0_.id_company AS id_company_24, u0_.id_user_rol AS id_user_rol_25, u0_.id_team AS id_team_26 FROM users u0_ WHERE u0_.status = ? AND u0_.id_team = ? ORDER BY u0_.name ASC Parameters: [`1 16`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.status AS status_12, u0_.team_leader AS team_leader_13, u0_.role AS role_14, u0_.access_key AS access_key_15, u0_.language AS language_16, u0_.color AS color_17, u0_.sidebar AS sidebar_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.description AS description_21, u0_.job_title AS job_title_22, u0_.id_office AS id_office_23, u0_.id_company AS id_company_24, u0_.id_user_rol AS id_user_rol_25, u0_.id_team AS id_team_26 FROM users u0_ WHERE u0_.status = ? AND u0_.id_team = ? ORDER BY u0_.name ASC SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.status AS status_12, u0_.team_leader AS team_leader_13, u0_.role AS role_14, u0_.access_key AS access_key_15, u0_.language AS language_16, u0_.color AS color_17, u0_.sidebar AS sidebar_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.description AS description_21, u0_.job_title AS job_title_22, u0_.id_office AS id_office_23, u0_.id_company AS id_company_24, u0_.id_user_rol AS id_user_rol_25, u0_.id_team AS id_team_26 FROM users u0_ WHERE u0_.status = 1 AND u0_.id_team = 16 ORDER BY u0_.name ASC;
0.17 ms (0.26%)	1	SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 WHERE t0.sage_code = ? LIMIT 1 Parameters: [`"03"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 WHERE t0.sage_code = ? LIMIT 1 SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 WHERE t0.sage_code = '03' LIMIT 1;
0.16 ms (0.24%)	1	SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.type AS type_3, t0.idLounge AS idLounge_4, t0.idPeriod AS idPeriod_5, t0.dateStart AS dateStart_6, t0.hourStart AS hourStart_7, t0.minStart AS minStart_8, t0.dateEnd AS dateEnd_9, t0.hourEnd AS hourEnd_10, t0.minEnd AS minEnd_11, t0.idService AS idService_12, t0.serviceName AS serviceName_13, t0.servicePrice AS servicePrice_14, t0.idReservation AS idReservation_15, t0.createdAt AS createdAt_16, t0.createdBy AS createdBy_17, t0.otherPriceSave AS otherPriceSave_18, t0.mounting AS mounting_19, t0.mountingLapse AS mountingLapse_20, t0.mountingDate AS mountingDate_21, t0.mountingHourStart AS mountingHourStart_22, t0.mountingMinStart AS mountingMinStart_23, t0.mountingHourEnd AS mountingHourEnd_24, t0.mountingMinEnd AS mountingMinEnd_25, t0.mountingPrice AS mountingPrice_26, t0.removalLapse AS removalLapse_27, t0.removalDate AS removalDate_28, t0.removalHourStart AS removalHourStart_29, t0.removalMinStart AS removalMinStart_30, t0.removalHourEnd AS removalHourEnd_31, t0.removalMinEnd AS removalMinEnd_32, t0.removalPrice AS removalPrice_33, t0.updatedAt AS updatedAt_34, t0.updatedBy AS updatedBy_35, t0.pax AS pax_36 FROM reservation_lounge t0 WHERE t0.idReservation = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.type AS type_3, t0.idLounge AS idLounge_4, t0.idPeriod AS idPeriod_5, t0.dateStart AS dateStart_6, t0.hourStart AS hourStart_7, t0.minStart AS minStart_8, t0.dateEnd AS dateEnd_9, t0.hourEnd AS hourEnd_10, t0.minEnd AS minEnd_11, t0.idService AS idService_12, t0.serviceName AS serviceName_13, t0.servicePrice AS servicePrice_14, t0.idReservation AS idReservation_15, t0.createdAt AS createdAt_16, t0.createdBy AS createdBy_17, t0.otherPriceSave AS otherPriceSave_18, t0.mounting AS mounting_19, t0.mountingLapse AS mountingLapse_20, t0.mountingDate AS mountingDate_21, t0.mountingHourStart AS mountingHourStart_22, t0.mountingMinStart AS mountingMinStart_23, t0.mountingHourEnd AS mountingHourEnd_24, t0.mountingMinEnd AS mountingMinEnd_25, t0.mountingPrice AS mountingPrice_26, t0.removalLapse AS removalLapse_27, t0.removalDate AS removalDate_28, t0.removalHourStart AS removalHourStart_29, t0.removalMinStart AS removalMinStart_30, t0.removalHourEnd AS removalHourEnd_31, t0.removalMinEnd AS removalMinEnd_32, t0.removalPrice AS removalPrice_33, t0.updatedAt AS updatedAt_34, t0.updatedBy AS updatedBy_35, t0.pax AS pax_36 FROM reservation_lounge t0 WHERE t0.idReservation = ? SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.type AS type_3, t0.idLounge AS idLounge_4, t0.idPeriod AS idPeriod_5, t0.dateStart AS dateStart_6, t0.hourStart AS hourStart_7, t0.minStart AS minStart_8, t0.dateEnd AS dateEnd_9, t0.hourEnd AS hourEnd_10, t0.minEnd AS minEnd_11, t0.idService AS idService_12, t0.serviceName AS serviceName_13, t0.servicePrice AS servicePrice_14, t0.idReservation AS idReservation_15, t0.createdAt AS createdAt_16, t0.createdBy AS createdBy_17, t0.otherPriceSave AS otherPriceSave_18, t0.mounting AS mounting_19, t0.mountingLapse AS mountingLapse_20, t0.mountingDate AS mountingDate_21, t0.mountingHourStart AS mountingHourStart_22, t0.mountingMinStart AS mountingMinStart_23, t0.mountingHourEnd AS mountingHourEnd_24, t0.mountingMinEnd AS mountingMinEnd_25, t0.mountingPrice AS mountingPrice_26, t0.removalLapse AS removalLapse_27, t0.removalDate AS removalDate_28, t0.removalHourStart AS removalHourStart_29, t0.removalMinStart AS removalMinStart_30, t0.removalHourEnd AS removalHourEnd_31, t0.removalMinEnd AS removalMinEnd_32, t0.removalPrice AS removalPrice_33, t0.updatedAt AS updatedAt_34, t0.updatedBy AS updatedBy_35, t0.pax AS pax_36 FROM reservation_lounge t0 WHERE t0.idReservation = 15887;
0.16 ms (0.23%)	1	SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_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, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = 15887;
0.16 ms (0.23%)	1	SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21 FROM clients_contact t0 WHERE t0.client_id = ? ORDER BY t0.name ASC Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21 FROM clients_contact t0 WHERE t0.client_id = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21 FROM clients_contact t0 WHERE t0.client_id = 0 ORDER BY t0.name ASC;
0.15 ms (0.23%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC;
0.15 ms (0.23%)	1	SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.reservationId AS reservationId_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.items AS items_9, t0.accessKey AS accessKey_10 FROM reservation_proforma t0 WHERE t0.reservationId = ? ORDER BY t0.id DESC Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.reservationId AS reservationId_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.items AS items_9, t0.accessKey AS accessKey_10 FROM reservation_proforma t0 WHERE t0.reservationId = ? ORDER BY t0.id DESC SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.reservationId AS reservationId_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.items AS items_9, t0.accessKey AS accessKey_10 FROM reservation_proforma t0 WHERE t0.reservationId = 15887 ORDER BY t0.id DESC;
0.15 ms (0.22%)	1	SELECT t0.id AS id_1, t0.amount AS amount_2, t0.datePayAt AS datePayAt_3, t0.wayToPay AS wayToPay_4, t0.reservationId AS reservationId_5, t0.vat AS vat_6, t0.amountTotal AS amountTotal_7, t0.createdAt AS createdAt_8, t0.createdId AS createdId_9, t0.updatedAt AS updatedAt_10, t0.updatedId AS updatedId_11, t0.invoiceId AS invoiceId_12 FROM reservation_payments_client t0 WHERE t0.reservationId = ? Parameters: [`15887`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amount AS amount_2, t0.datePayAt AS datePayAt_3, t0.wayToPay AS wayToPay_4, t0.reservationId AS reservationId_5, t0.vat AS vat_6, t0.amountTotal AS amountTotal_7, t0.createdAt AS createdAt_8, t0.createdId AS createdId_9, t0.updatedAt AS updatedAt_10, t0.updatedId AS updatedId_11, t0.invoiceId AS invoiceId_12 FROM reservation_payments_client t0 WHERE t0.reservationId = ? SELECT t0.id AS id_1, t0.amount AS amount_2, t0.datePayAt AS datePayAt_3, t0.wayToPay AS wayToPay_4, t0.reservationId AS reservationId_5, t0.vat AS vat_6, t0.amountTotal AS amountTotal_7, t0.createdAt AS createdAt_8, t0.createdId AS createdId_9, t0.updatedAt AS updatedAt_10, t0.updatedId AS updatedId_11, t0.invoiceId AS invoiceId_12 FROM reservation_payments_client t0 WHERE t0.reservationId = 15887;

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\Entity\Configuration	No errors.
App\Entity\User	No errors.
App\Entity\SettingsOffice	No errors.
App\Entity\SettingsCompany	No errors.
App\Entity\SettingsRol	No errors.
App\Entity\SettingsTeam	No errors.
App\Entity\UserNotification	No errors.
App\Entity\ManteApp	No errors.
App\Entity\Space	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeDetails	No errors.
App\MDS\VenuesBundle\Entity\Reservation	No errors.
App\Entity\Client	No errors.
App\Entity\HtFile	No errors.
App\Entity\ClientContact	No errors.
App\MDS\AvexpressBundle\Entity\AveFiles	No errors.
App\Entity\DocContract	No errors.
App\Entity\HtItem	No errors.
App\Entity\HtVisit	No errors.
App\Entity\Supplier	No errors.
App\Entity\DeliveryNote	No errors.
App\MDS\VenuesBundle\Entity\ReservationDeposit	No errors.
App\MDS\VenuesBundle\Entity\ReservationProformaDeposit	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeSimple	No errors.
App\Entity\SageVatRates	No errors.
App\Entity\SageArticle	No errors.
App\MDS\VenuesBundle\Entity\ReservationInvoice	No errors.
App\MDS\VenuesBundle\Entity\ReservationInvoiceRec	No errors.
App\MDS\VenuesBundle\Entity\ReservationLounge	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeProfile	No errors.
App\MDS\VenuesBundle\Entity\ReservationService	No errors.
App\Entity\SagePaymentMethod	No errors.
App\Entity\SupplierAccountingAccount	No errors.
App\MDS\VenuesBundle\Entity\ReservationPaymentsClient	No errors.
App\MDS\VenuesBundle\Entity\ReservationMailAlertClient	No errors.
App\MDS\VenuesBundle\Entity\ReservationInvoiceItems	No errors.
App\MDS\VenuesBundle\Entity\ReservationInvoiceDepositItems	No errors.
App\Entity\ClientAccountingAccount	No errors.
App\Entity\SagePayment	No errors.
App\MDS\VenuesBundle\Entity\ReservationProforma	No errors.
App\Entity\ReservationLoungeWebDescription	No errors.
App\MDS\VenuesBundle\Entity\ReservationAgendaItem	No errors.
App\MDS\VenuesBundle\Entity\ReservationTracing	No errors.
App\Entity\DocContractModel	No errors.
App\Entity\SettingsBranding	No errors.

Symfony Profiler

https://mantevenues.mante.solutions/venues/editsimple/15887

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping