https://inout.mante.solutions/reservations-greenpatio/payment/10478

Query Metrics

19 Database Queries
16 Different statements
17.59 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.45 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:
[
  "maria.martinez@greenpatio.es"
]
2 0.37 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:
[
  "maria.martinez@greenpatio.es"
]
3 0.52 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:
[
  "10478"
]
4 0.40 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:
[
  "10478"
]
5 0.40 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:
[
  "10478"
]
6 1.17 ms
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.reservationId AS reservationId_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.items AS items_9, t0.accessKey AS accessKey_10 FROM reservation_proforma t0 WHERE t0.reservationId = ? LIMIT 1
Parameters:
[
  "10478"
]
7 0.33 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:
[
  "10478"
]
8 0.69 ms
SELECT t0.id AS id_1, t0.controlId AS controlId_2, t0.type AS type_3, t0.reservationId AS reservationId_4, t0.proformaId AS proformaId_5 FROM reservation_invoice_proforma_items t0 WHERE t0.reservationId = ?
Parameters:
[
  10478
]
9 0.74 ms
SELECT t0.id AS id_1, t0.company AS company_2, t0.id_document AS id_document_3, t0.registry AS registry_4, t0.address AS address_5, t0.zip_code AS zip_code_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.email AS email_9, t0.note AS note_10, t0.note_sin_iva AS note_sin_iva_11, t0.created_at AS created_at_12, t0.created_id AS created_id_13, t0.updated_at AS updated_at_14, t0.updated_id AS updated_id_15, t0.picture AS picture_16, t0.priority AS priority_17, t0.token AS token_18 FROM settings_company t0 WHERE t0.priority = ? LIMIT 1
Parameters:
[
  "2"
]
10 1.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 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  "4290"
]
11 0.35 ms
SELECT t0.id AS id_1, t0.region_id AS region_id_2, t0.country_id AS country_id_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.name AS name_6, t0.province_id AS province_id_7, t0.zipcode AS zipcode_8 FROM cities t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "713549"
]
12 0.30 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM regions t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "969"
]
13 0.26 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM countries t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "62"
]
14 0.37 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:
[
  "10478"
]
15 0.18 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:
[
  "10478"
]
16 2.10 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 = ? AND t0.toinvoice = ?
Parameters:
[
  "10478"
  1
]
17 3.58 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.lngControlId = ?
Parameters:
[
  6443
]
18 1.61 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 cvr_reservation_invoice_items t0 WHERE t0.lngControlId = ?
Parameters:
[
  6443
]
19 1.62 ms
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.reservation_id AS reservation_id_5, t0.name AS name_6, t0.amount AS amount_7, t0.iva AS iva_8, t0.total AS total_9, t0.created_at AS created_at_10, t0.created_id AS created_id_11, t0.updated_at AS updated_at_12, t0.updated_id AS updated_id_13 FROM reservation_proforma_deposit t0 WHERE t0.reservation_id = ?
Parameters:
[
  "10478"
]

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.