Query Metrics
22
Database Queries
18
Different statements
75.60 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
41.15 ms (54.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
Parameters:
[] |
|
12.07 ms (15.96%) |
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:
[] |
|
4.99 ms (6.60%) |
2 |
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:
[
"2686"
]
|
|
2.86 ms (3.79%) |
2 |
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:
[
"2435"
]
|
|
2.84 ms (3.75%) |
2 |
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:
[
"2686"
]
|
|
2.75 ms (3.64%) |
2 |
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:
[
"2686"
]
|
|
1.54 ms (2.04%) |
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:
[
"2686"
]
|
|
1.15 ms (1.52%) |
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:
[
"2686"
]
|
|
0.97 ms (1.28%) |
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.email IS NULL LIMIT 1
Parameters:
[] |
|
0.93 ms (1.23%) |
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:
[
"2686"
]
|
|
0.89 ms (1.17%) |
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:
[
"2686"
]
|
|
0.86 ms (1.14%) |
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:
[
"2686"
]
|
|
0.72 ms (0.95%) |
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." ] |
|
0.70 ms (0.93%) |
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:
[
"2686"
]
|
|
0.36 ms (0.47%) |
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.31 ms (0.41%) |
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.27 ms (0.36%) |
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.25 ms (0.33%) |
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:
[] |
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.