Query Metrics
47
Database Queries
33
Different statements
146.31 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.98 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.email = ? LIMIT 1
Parameters:
[
"ana.martin@greenpatio.es"
]
|
| 2 | 0.40 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.email = ? LIMIT 1
Parameters:
[
"ana.martin@greenpatio.es"
]
|
| 3 | 0.57 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, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21 FROM reservation_lounge_details t0
Parameters:
[] |
| 4 | 53.74 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, 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
"14695"
]
|
| 5 | 0.46 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, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
"14695"
]
|
| 6 | 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, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"14695"
]
|
| 7 | 0.48 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, 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
14695
]
|
| 8 | 0.27 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, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
14695
]
|
| 9 | 0.22 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, t0.typology AS typology_34 FROM clients t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 10 | 34.13 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, t0.typology AS typology_34 FROM clients t0
Parameters:
[] |
| 11 | 0.77 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, s0_.typology AS typology_36 FROM suppliers s0_ WHERE (s0_.tags LIKE ?) AND (s0_.company <> ?) ORDER BY s0_.company ASC
Parameters:
[ "CATERING" "HIGO & TRIGO, S.L." ] |
| 12 | 0.29 ms |
SELECT t0.id AS id_1, t0.company AS company_2, t0.group_id AS group_id_3, t0.contact AS contact_4, t0.type_document AS type_document_5, t0.id_document AS id_document_6, t0.address AS address_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.zip_code AS zip_code_11, t0.country AS country_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.email AS email_15, t0.type AS type_16, t0.tags AS tags_17, t0.preference AS preference_18, t0.created_id AS created_id_19, t0.created_at AS created_at_20, t0.updated_id AS updated_id_21, t0.updated_at AS updated_at_22, t0.state AS state_23, t0.picture AS picture_24, t0.observation AS observation_25, t0.terms AS terms_26, t0.star AS star_27, t0.name AS name_28, t0.url AS url_29, t0.commission AS commission_30, t0.iva AS iva_31, t0.accommodation AS accommodation_32, t0.is_supplier_in_out AS is_supplier_in_out_33, t0.is_supplier_green_patio AS is_supplier_green_patio_34, t0.is_supplier_av_express AS is_supplier_av_express_35, t0.is_supplier_develup AS is_supplier_develup_36, t0.typology AS typology_37 FROM suppliers t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4765
]
|
| 13 | 0.20 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:
[
"151"
]
|
| 14 | 0.41 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, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC
Parameters:
[] |
| 15 | 0.31 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, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21 FROM reservation_lounge_details t0
Parameters:
[] |
| 16 | 1.93 ms |
SELECT s0_.id AS id_0, s0_.company AS company_1 FROM suppliers s0_
Parameters:
[] |
| 17 | 0.34 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:
[
"14695"
]
|
| 18 | 0.30 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:
[
"14695"
]
|
| 19 | 0.39 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:
[
"14695"
]
|
| 20 | 0.25 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 blv_reservation_invoice t0 WHERE t0.reservationId = ?
Parameters:
[
"14695"
]
|
| 21 | 0.26 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:
[
"14695"
]
|
| 22 | 0.33 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 blv_reservation_invoice_rec t0 WHERE t0.reservationId = ?
Parameters:
[
"14695"
]
|
| 23 | 0.23 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:
[
"14695"
]
|
| 24 | 0.19 ms |
SELECT c0_.id AS id_0, c0_.client_id AS client_id_1, c0_.position AS position_2, c0_.department AS department_3, c0_.type_client AS type_client_4, c0_.name AS name_5, c0_.last_name AS last_name_6, c0_.email AS email_7, c0_.password AS password_8, c0_.token AS token_9, c0_.phone AS phone_10, c0_.mobile AS mobile_11, c0_.birthday AS birthday_12, c0_.assigned_agent AS assigned_agent_13, c0_.situation AS situation_14, c0_.status AS status_15, c0_.created_id AS created_id_16, c0_.created_at AS created_at_17, c0_.updated_id AS updated_id_18, c0_.updated_at AS updated_at_19, c0_.picture AS picture_20, c0_.newsletter AS newsletter_21 FROM clients_contact c0_ WHERE c0_.client_id = ? ORDER BY c0_.name ASC
Parameters:
[
0
]
|
| 25 | 0.30 ms |
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:
[
"14695"
]
|
| 26 | 0.50 ms |
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_.id_office AS id_office_12, u0_.status AS status_13, u0_.id_company AS id_company_14, u0_.id_user_rol AS id_user_rol_15, u0_.id_team AS id_team_16, u0_.team_leader AS team_leader_17, u0_.role AS role_18, u0_.access_key AS access_key_19, u0_.language AS language_20, u0_.color AS color_21, u0_.vacations AS vacations_22, u0_.half_days AS half_days_23, u0_.sidebar AS sidebar_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.description AS description_27, u0_.job_title AS job_title_28 FROM users u0_ WHERE u0_.status = ? ORDER BY u0_.name ASC
Parameters:
[
1
]
|
| 27 | 0.31 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.telephone AS telephone_7, t0.mobile AS mobile_8, t0.id_office AS id_office_9, t0.status AS status_10, t0.id_company AS id_company_11, t0.id_user_rol AS id_user_rol_12, t0.id_team AS id_team_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.description AS description_16, t0.job_title AS job_title_17, t0.createdAt AS createdAt_18, t0.createdBy AS createdBy_19, t0.updatedAt AS updatedAt_20, t0.updatedBy AS updatedBy_21, t0.price AS price_22 FROM external_user t0
Parameters:
[] |
| 28 | 0.45 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, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"14695"
]
|
| 29 | 0.29 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, 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
"14695"
]
|
| 30 | 0.22 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, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
"14695"
]
|
| 31 | 0.41 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21406
]
|
| 32 | 0.21 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21407
]
|
| 33 | 0.19 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21408
]
|
| 34 | 0.26 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21409
]
|
| 35 | 0.22 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21410
]
|
| 36 | 0.20 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.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 FROM reservation_invoice_items t0 WHERE t0.lngControlId = ? LIMIT 1
Parameters:
[
21411
]
|
| 37 | 1.14 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1 FROM clients c0_ WHERE c0_.is_client_green_patio = 1 ORDER BY c0_.name ASC
Parameters:
[] |
| 38 | 0.33 ms |
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 FROM reservation_deposit t0 WHERE t0.reservationId = ?
Parameters:
[
"14695"
]
|
| 39 | 0.22 ms |
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 FROM reservation_deposit t0 WHERE t0.reservationId = ? AND t0.isDone = ?
Parameters:
[ "14695" 1 ] |
| 40 | 0.32 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, 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
"14695"
]
|
| 41 | 0.21 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, 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
"14695"
]
|
| 42 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_type AS client_type_15, t0.client_id AS client_id_16, t0.proposal_id AS proposal_id_17, t0.created_id_id AS created_id_id_18, t0.updated_id_id AS updated_id_id_19, t0.client_contact_id AS client_contact_id_20, t0.reservation_id AS reservation_id_21 FROM ht_file t0 WHERE t0.reservation_id = ? LIMIT 1
Parameters:
[
14695
]
|
| 43 | 0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.priority AS priority_4, t0.supplier AS supplier_5, t0.status AS status_6, t0.daysBlock AS daysBlock_7, t0.advancePayment AS advancePayment_8, t0.idProposal AS idProposal_9, t0.cateringName AS cateringName_10, t0.boolCatering AS boolCatering_11, t0.dateStart AS dateStart_12, t0.dateEnd AS dateEnd_13, t0.pax AS pax_14, t0.deposit AS deposit_15, t0.access_key AS access_key_16, t0.description AS description_17, t0.destinoId AS destinoId_18, t0.createdAt AS createdAt_19, t0.createdId AS createdId_20, t0.updatedAt AS updatedAt_21, t0.updatedId AS updatedId_22, t0.comments AS comments_23, t0.comments_in_inv AS comments_in_inv_24, t0.comments_in_pro AS comments_in_pro_25, t0.xtra_field_one AS xtra_field_one_26, t0.xtra_field_two AS xtra_field_two_27, t0.reservation_id AS reservation_id_28 FROM ave_files t0 WHERE t0.reservation_id = ? LIMIT 1
Parameters:
[
14695
]
|
| 44 | 33.68 ms |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33 FROM clients c0_
Parameters:
[] |
| 45 | 0.68 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, s0_.typology AS typology_36 FROM suppliers s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.company ASC
Parameters:
[
"catering"
]
|
| 46 | 0.66 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, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20 FROM reservation_lounge_details r0_
Parameters:
[] |
| 47 | 7.08 ms |
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:
[] |
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.