Query Metrics
12
Database Queries
10
Different statements
11.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.81 ms (34.48%) |
1 |
"COMMIT"
Parameters:
[] |
|
2.49 ms (22.52%) |
2 |
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.id = ? LIMIT 1
Parameters:
[
"10908"
]
|
|
1.03 ms (9.35%) |
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.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"ayudantedeproduccion2@avexpress.tv"
]
|
|
0.92 ms (8.31%) |
1 |
INSERT INTO ave_product_file (productName, productId, dateStart, dateEnd, servicePrice, fileId, pax, type, hourStart, minStart, hourEnd, minEnd, description, createdAt, createdId, updatedAt, updatedId, supplierExt, supplierExtId, service_id_proposal, service_id_father, control_id, proposal_id, destination_id, idea_id, activity_id, supplier_id, assistant_id, service_id, service_cat_id, service_cat_name, name, price, currency, units, op_commission, commission, op_over, price_over, op_iva, iva, hour, date_in_at, date_out_at, contcolor, rankquote, renovate, pay, days, sub_total_price, origin_id, rankquote_av, location, idGpLounge) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "PC Sonido" 118 "2026-10-03 00:00:00" "2026-10-06 00:00:00" "71.50" "10908" null "Sonido" null null null null "" "2026-06-11 16:20:58" 89 "2026-06-11 16:20:58" 89 "AV EXPRESS S.L." 80 null "0" null null null null null null null null null null null null null "1" "0" null "0" null true "21" null "2026-10-03 00:00:00" "2026-10-06 00:00:00" null null null "0" 4 286.0 null 33 null null ] |
|
0.83 ms (7.52%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.type AS type_4, t0.description AS description_5, t0.createdAt AS createdAt_6, t0.createdId AS createdId_7, t0.updatedAt AS updatedAt_8, t0.updatedId AS updatedId_9, t0.supplierExt AS supplierExt_10, t0.supplierExtId AS supplierExtId_11 FROM ave_product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"118"
]
|
|
0.51 ms (4.61%) |
1 |
SELECT t0.id AS id_1, t0.productName AS productName_2, t0.productId AS productId_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.fileId AS fileId_7, t0.pax AS pax_8, t0.type AS type_9, t0.hourStart AS hourStart_10, t0.minStart AS minStart_11, t0.hourEnd AS hourEnd_12, t0.minEnd AS minEnd_13, t0.description AS description_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.supplierExt AS supplierExt_19, t0.supplierExtId AS supplierExtId_20, t0.service_id_proposal AS service_id_proposal_21, t0.service_id_father AS service_id_father_22, t0.control_id AS control_id_23, t0.proposal_id AS proposal_id_24, t0.destination_id AS destination_id_25, t0.idea_id AS idea_id_26, t0.activity_id AS activity_id_27, t0.supplier_id AS supplier_id_28, t0.assistant_id AS assistant_id_29, t0.service_id AS service_id_30, t0.service_cat_id AS service_cat_id_31, t0.service_cat_name AS service_cat_name_32, t0.name AS name_33, t0.price AS price_34, t0.currency AS currency_35, t0.units AS units_36, t0.op_commission AS op_commission_37, t0.commission AS commission_38, t0.op_over AS op_over_39, t0.price_over AS price_over_40, t0.op_iva AS op_iva_41, t0.iva AS iva_42, t0.hour AS hour_43, t0.date_in_at AS date_in_at_44, t0.date_out_at AS date_out_at_45, t0.contcolor AS contcolor_46, t0.rankquote AS rankquote_47, t0.renovate AS renovate_48, t0.pay AS pay_49, t0.days AS days_50, t0.sub_total_price AS sub_total_price_51, t0.origin_id AS origin_id_52, t0.rankquote_av AS rankquote_av_53, t0.location AS location_54, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.fileId = ?
Parameters:
[
"10908"
]
|
|
0.47 ms (4.22%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.34 ms (3.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.33 ms (3.02%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.createdAt AS createdAt_4, t0.createdId AS createdId_5, t0.updatedAt AS updatedAt_6, t0.updatedId AS updatedId_7 FROM ave_template t0 WHERE t0.id = ? LIMIT 1
Parameters:
[ "" ] |
|
0.32 ms (2.90%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_net_price AS total_net_price_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.aveProductFileId AS aveProductFileId_9, t0.is_featured AS is_featured_10 FROM ave_package_template t0 WHERE t0.id = ? LIMIT 1
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Configuration | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SettingsOffice | No errors. |
| App\Entity\SettingsCompany | No errors. |
| App\Entity\SettingsRol | No errors. |
| App\Entity\SettingsTeam | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\ManteApp | No errors. |
| App\Entity\Space | No errors. |
| App\MDS\VenuesBundle\Entity\ReservationLoungeDetails | No errors. |
| App\MDS\AvexpressBundle\Entity\AveFiles | No errors. |
| App\MDS\VenuesBundle\Entity\Reservation | No errors. |
| App\MDS\AvexpressBundle\Entity\AveTemplate | No errors. |
| App\MDS\AvexpressBundle\Entity\AvePackageTemplate | No errors. |
| App\MDS\AvexpressBundle\Entity\AveProduct | No errors. |
| App\MDS\AvexpressBundle\Entity\AveProductFile | No errors. |