Query Metrics
54
Database Queries
37
Different statements
176.31 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
36.55 ms (20.73%) |
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 FROM suppliers t0
Parameters:
[] |
|
28.55 ms (16.19%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33 FROM clients t0
Parameters:
[] |
|
26.04 ms (14.77%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32 FROM clients c0_
Parameters:
[] |
|
15.23 ms (8.64%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32 FROM clients c0_ WHERE c0_.is_client_green_patio = 1 ORDER BY c0_.name ASC
Parameters:
[] |
|
6.91 ms (3.92%) |
2 |
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:
[
278
]
|
|
6.88 ms (3.90%) |
2 |
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.lngControlId = ? LIMIT 1
Parameters:
[
5976
]
|
|
6.75 ms (3.83%) |
2 |
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.srvControlId = ? LIMIT 1
Parameters:
[
805
]
|
|
6.52 ms (3.70%) |
2 |
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:
[ "10252" 278 ] |
|
5.34 ms (3.03%) |
4 |
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:
[
"10252"
]
|
|
4.97 ms (2.82%) |
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 FROM suppliers s0_ WHERE (s0_.tags LIKE ?) AND (s0_.company <> ?) ORDER BY s0_.company ASC
Parameters:
[ "CATERING" "HIGO & TRIGO, S.L." ] |
|
4.80 ms (2.72%) |
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 FROM suppliers s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.company ASC
Parameters:
[
"catering"
]
|
|
3.07 ms (1.74%) |
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, 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:
[
"10252"
]
|
|
2.99 ms (1.70%) |
1 |
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:
[
3913
]
|
|
1.74 ms (0.98%) |
4 |
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:
[
"10252"
]
|
|
1.69 ms (0.96%) |
2 |
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:
[
172
]
|
|
1.49 ms (0.85%) |
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_.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
]
|
|
1.38 ms (0.78%) |
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.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:
[
"gabriela.bracho@greenpatio.es"
]
|
|
1.16 ms (0.66%) |
3 |
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:
[
"3913"
]
|
|
1.05 ms (0.59%) |
2 |
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"
]
|
|
0.99 ms (0.56%) |
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:
[
"10252"
]
|
|
0.92 ms (0.52%) |
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:
[
"10252"
]
|
|
0.92 ms (0.52%) |
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 FROM reservation_deposit t0 WHERE t0.reservationId = ?
Parameters:
[
"10252"
]
|
|
0.91 ms (0.51%) |
1 |
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:
[
"10252"
]
|
|
0.85 ms (0.48%) |
1 |
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:
[
10252
]
|
|
0.83 ms (0.47%) |
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 FROM reservation_lounge_details r0_
Parameters:
[] |
|
0.83 ms (0.47%) |
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 FROM reservation_lounge_profile r0_
Parameters:
[] |
|
0.82 ms (0.47%) |
1 |
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:
[
"10252"
]
|
|
0.78 ms (0.44%) |
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 FROM reservation_deposit t0 WHERE t0.reservationId = ? AND t0.isDone = ?
Parameters:
[ "10252" 1 ] |
|
0.76 ms (0.43%) |
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 FROM suppliers t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4765
]
|
|
0.74 ms (0.42%) |
1 |
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:
[] |
|
0.65 ms (0.37%) |
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:
[
"10252"
]
|
|
0.63 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"82"
]
|
|
0.62 ms (0.35%) |
1 |
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_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = ? LIMIT 1
Parameters:
[
10252
]
|
|
0.54 ms (0.30%) |
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 FROM reservation_lounge_details r0_ ORDER BY r0_.rank_lounge ASC
Parameters:
[] |
|
0.49 ms (0.28%) |
1 |
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:
[
"10252"
]
|
|
0.46 ms (0.26%) |
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 FROM reservation_lounge_details t0
Parameters:
[] |
|
0.46 ms (0.26%) |
1 |
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:
[
"10252"
]
|
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.