Query Metrics
27
Database Queries
21
Different statements
76.60 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.81 ms |
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:
[
"2895"
]
|
2 | 4.71 ms |
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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
"2895"
]
|
3 | 2.68 ms |
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, t31.id AS id_32, t31.lounge_other AS lounge_other_33, t31.date_start AS date_start_34, t31.hour_end AS hour_end_35, t31.gratitudes AS gratitudes_36, t31.created_at AS created_at_37, t31.updated_at AS updated_at_38, t31.pax AS pax_39, t31.observation AS observation_40, t31.type AS type_41, t31.reservation_service_id AS reservation_service_id_42, t31.lounge_gp_id AS lounge_gp_id_43, t31.created_id_id AS created_id_id_44, t31.updated_id_id AS updated_id_id_45, t31.ht_file_id AS ht_file_id_46 FROM reservation_service t0 LEFT JOIN ht_item t31 ON t31.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
"2895"
]
|
4 | 0.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"2895"
]
|
5 | 0.35 ms |
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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
2895
]
|
6 | 0.37 ms |
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, t31.id AS id_32, t31.lounge_other AS lounge_other_33, t31.date_start AS date_start_34, t31.hour_end AS hour_end_35, t31.gratitudes AS gratitudes_36, t31.created_at AS created_at_37, t31.updated_at AS updated_at_38, t31.pax AS pax_39, t31.observation AS observation_40, t31.type AS type_41, t31.reservation_service_id AS reservation_service_id_42, t31.lounge_gp_id AS lounge_gp_id_43, t31.created_id_id AS created_id_id_44, t31.updated_id_id AS updated_id_id_45, t31.ht_file_id AS ht_file_id_46 FROM reservation_service t0 LEFT JOIN ht_item t31 ON t31.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
2895
]
|
7 | 0.81 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33 FROM clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3614"
]
|
8 | 11.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33 FROM clients t0
Parameters:
[] |
9 | 0.70 ms |
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 FROM suppliers s0_ WHERE (s0_.tags LIKE ?) AND (s0_.company <> ?) ORDER BY s0_.company ASC
Parameters:
[ "CATERING" "HIGO & TRIGO, S.L." ] |
10 | 0.43 ms |
SELECT t0.id AS id_1, t0.company AS company_2, t0.group_id AS group_id_3, t0.contact AS contact_4, t0.type_document AS type_document_5, t0.id_document AS id_document_6, t0.address AS address_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.zip_code AS zip_code_11, t0.country AS country_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.email AS email_15, t0.type AS type_16, t0.tags AS tags_17, t0.preference AS preference_18, t0.created_id AS created_id_19, t0.created_at AS created_at_20, t0.updated_id AS updated_id_21, t0.updated_at AS updated_at_22, t0.state AS state_23, t0.picture AS picture_24, t0.observation AS observation_25, t0.terms AS terms_26, t0.star AS star_27, t0.name AS name_28, t0.url AS url_29, t0.commission AS commission_30, t0.iva AS iva_31, t0.accommodation AS accommodation_32, t0.is_supplier_in_out AS is_supplier_in_out_33, t0.is_supplier_green_patio AS is_supplier_green_patio_34, t0.is_supplier_av_express AS is_supplier_av_express_35, t0.is_supplier_develup AS is_supplier_develup_36 FROM suppliers t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4765
]
|
11 | 0.28 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"106"
]
|
12 | 0.24 ms |
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 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC
Parameters:
[] |
13 | 0.21 ms |
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 FROM reservation_lounge_details t0
Parameters:
[] |
14 | 37.20 ms |
SELECT t0.id AS id_1, t0.company AS company_2, t0.group_id AS group_id_3, t0.contact AS contact_4, t0.type_document AS type_document_5, t0.id_document AS id_document_6, t0.address AS address_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.zip_code AS zip_code_11, t0.country AS country_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.email AS email_15, t0.type AS type_16, t0.tags AS tags_17, t0.preference AS preference_18, t0.created_id AS created_id_19, t0.created_at AS created_at_20, t0.updated_id AS updated_id_21, t0.updated_at AS updated_at_22, t0.state AS state_23, t0.picture AS picture_24, t0.observation AS observation_25, t0.terms AS terms_26, t0.star AS star_27, t0.name AS name_28, t0.url AS url_29, t0.commission AS commission_30, t0.iva AS iva_31, t0.accommodation AS accommodation_32, t0.is_supplier_in_out AS is_supplier_in_out_33, t0.is_supplier_green_patio AS is_supplier_green_patio_34, t0.is_supplier_av_express AS is_supplier_av_express_35, t0.is_supplier_develup AS is_supplier_develup_36 FROM suppliers t0
Parameters:
[] |
15 | 1.52 ms |
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 FROM reservation_invoice t0 WHERE t0.reservationId = ?
Parameters:
[
"2895"
]
|
16 | 0.79 ms |
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 FROM reservation_invoice_rec t0 WHERE t0.reservationId = ?
Parameters:
[
"2895"
]
|
17 | 0.96 ms |
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.client_name AS client_name_12, t0.client_address AS client_address_13, t0.client_document AS client_document_14, t0.client_type AS client_type_15, t0.createdAt AS createdAt_16, t0.createdId AS createdId_17, t0.updatedAt AS updatedAt_18, t0.updatedId AS updatedId_19 FROM cvr_reservation_invoice t0 WHERE t0.reservationId = ?
Parameters:
[
"2895"
]
|
18 | 0.78 ms |
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.invoiceToRec AS invoiceToRec_12, t0.client_name AS client_name_13, t0.client_address AS client_address_14, t0.client_document AS client_document_15, t0.client_type AS client_type_16, t0.createdAt AS createdAt_17, t0.createdId AS createdId_18, t0.updatedAt AS updatedAt_19, t0.updatedId AS updatedId_20 FROM cvr_reservation_invoice_rec t0 WHERE t0.reservationId = ?
Parameters:
[
"2895"
]
|
19 | 0.37 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
2895
]
|
20 | 0.25 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33 FROM clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3614"
]
|
21 | 0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
2895
]
|
22 | 0.31 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33 FROM clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3614"
]
|
23 | 0.96 ms |
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.invoiceId = ? LIMIT 1
Parameters:
[
149
]
|
24 | 3.70 ms |
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.srvControlId AS srvControlId_17, t0.srvSupplierId AS srvSupplierId_18, t0.srvServiceId AS srvServiceId_19, t0.srvServiceCatId AS srvServiceCatId_20, t0.srvServiceCatName AS srvServiceCatName_21, t0.srvName AS srvName_22, t0.srvPrice AS srvPrice_23, t0.srvCurrency AS srvCurrency_24, t0.srvUnits AS srvUnits_25, t0.srvOpCommission AS srvOpCommission_26, t0.srvCommission AS srvCommission_27, t0.srvOpOver AS srvOpOver_28, t0.srvOver AS srvOver_29, t0.srvOpIva AS srvOpIva_30, t0.srvIva AS srvIva_31, t0.srvPax AS srvPax_32, t0.srvHour AS srvHour_33, t0.srvDateInAt AS srvDateInAt_34, t0.srvDateOutAt AS srvDateOutAt_35, t0.srvContcolor AS srvContcolor_36, t0.srvRank AS srvRank_37, t0.srvAssistantId AS srvAssistantId_38, t0.srvActivityId AS srvActivityId_39, t0.srvPay AS srvPay_40, t0.payControlId AS payControlId_41, t0.payAmount AS payAmount_42, t0.payDatePayAt AS payDatePayAt_43, t0.payWayToPay AS payWayToPay_44, t0.payVat AS payVat_45, t0.payAmountTotal AS payAmountTotal_46, t0.createdAt AS createdAt_47, t0.createdId AS createdId_48, t0.updatedAt AS updatedAt_49, t0.updatedId AS updatedId_50 FROM reservation_invoice_items t0 WHERE t0.payControlId = ? LIMIT 1
Parameters:
[
250
]
|
25 | 0.79 ms |
SELECT t0.id AS id_1, t0.controlId AS controlId_2, t0.name AS name_3, t0.amount AS amount_4, t0.iva AS iva_5, t0.reservation_id AS reservation_id_6, t0.created_at AS created_at_7, t0.created_id AS created_id_8, t0.updated_at AS updated_at_9, t0.updated_id AS updated_id_10 FROM reservation_invoice_deposit_items t0 WHERE t0.controlId = ?
Parameters:
[
"master"
]
|
26 | 0.72 ms |
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:
[
"2895"
]
|
27 | 3.43 ms |
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.srvControlId AS srvControlId_17, t0.srvSupplierId AS srvSupplierId_18, t0.srvServiceId AS srvServiceId_19, t0.srvServiceCatId AS srvServiceCatId_20, t0.srvServiceCatName AS srvServiceCatName_21, t0.srvName AS srvName_22, t0.srvPrice AS srvPrice_23, t0.srvCurrency AS srvCurrency_24, t0.srvUnits AS srvUnits_25, t0.srvOpCommission AS srvOpCommission_26, t0.srvCommission AS srvCommission_27, t0.srvOpOver AS srvOpOver_28, t0.srvOver AS srvOver_29, t0.srvOpIva AS srvOpIva_30, t0.srvIva AS srvIva_31, t0.srvPax AS srvPax_32, t0.srvHour AS srvHour_33, t0.srvDateInAt AS srvDateInAt_34, t0.srvDateOutAt AS srvDateOutAt_35, t0.srvContcolor AS srvContcolor_36, t0.srvRank AS srvRank_37, t0.srvAssistantId AS srvAssistantId_38, t0.srvActivityId AS srvActivityId_39, t0.srvPay AS srvPay_40, t0.payControlId AS payControlId_41, t0.payAmount AS payAmount_42, t0.payDatePayAt AS payDatePayAt_43, t0.payWayToPay AS payWayToPay_44, t0.payVat AS payVat_45, t0.payAmountTotal AS payAmountTotal_46, t0.createdAt AS createdAt_47, t0.createdId AS createdId_48, t0.updatedAt AS updatedAt_49, t0.updatedId AS updatedId_50 FROM reservation_invoice_items t0 WHERE t0.reservationId = ? AND t0.payControlId = ?
Parameters:
[ "2895" 250 ] |
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.