Query Metrics
259
Database Queries
11
Different statements
228.37 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
130.47 ms (57.13%) |
64 |
"COMMIT"
Parameters:
[] |
50.13 ms (21.95%) |
64 |
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.`rank` AS rank_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.rank_av AS rank_av_53, t0.location AS location_54 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"100165"
]
|
25.72 ms (11.26%) |
54 |
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters:
[ "2026-02-15 00:00:00" "2026-02-17 00:00:00" "1" "2025-08-28 08:50:35" 34 "2026-02-15 00:00:00" "2026-02-17 00:00:00" 3728 100165 ] |
14.03 ms (6.14%) |
64 |
"START TRANSACTION"
Parameters:
[] |
1.87 ms (0.82%) |
3 |
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ?, location = ? WHERE id = ?
Parameters:
[ "2026-02-15 00:00:00" "2026-02-17 00:00:00" "1" "2025-08-28 08:50:35" 34 "2026-02-15 00:00:00" "2026-02-17 00:00:00" 1095 "Sala Plenaria Imprenta-Green Patio" 100213 ] |
1.81 ms (0.79%) |
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:
[
"ayudantedeproduccion@avexpress.tv"
]
|
1.71 ms (0.75%) |
3 |
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, hourStart = ?, minStart = ?, hourEnd = ?, minEnd = ?, updatedAt = ?, updatedId = ?, currency = ?, commission = ?, price_over = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ?, location = ? WHERE id = ?
Parameters:
[ "2026-02-15 00:00:00" "2026-02-17 00:00:00" "1" "00" "00" "00" "00" "2025-08-28 08:50:35" 34 "Euro" "0" "0" "2026-02-15 00:00:00" "2026-02-17 00:00:00" 900 "" 100277 ] |
1.06 ms (0.47%) |
2 |
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ?, rank_av = ?, location = ? WHERE id = ?
Parameters:
[ "2026-02-15 00:00:00" "2026-02-17 00:00:00" "1" "2025-08-28 08:50:35" 34 "2026-02-15 00:00:00" "2026-02-17 00:00:00" 135.0 46 "Sala Plenaria Imprenta-Green Patio" 100212 ] |
0.59 ms (0.26%) |
1 |
UPDATE ave_product_file SET productName = ?, dateStart = ?, dateEnd = ?, servicePrice = ?, pax = ?, updatedAt = ?, updatedId = ?, units = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters:
[ "STREAMING / Tarima módulos de 2x1 (no incluye moqueta)" "2026-02-15 00:00:00" "2026-02-17 00:00:00" "37" "1" "2025-08-28 08:50:35" 34 "2" "2026-02-15 00:00:00" "2026-02-17 00:00:00" 222 100217 ] |
0.54 ms (0.24%) |
1 |
UPDATE ave_product_file SET productName = ?, dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters:
[ "Tarima módulos de 2x3 (no incluye moqueta) + sobretarima 8X1" "2026-02-15 00:00:00" "2026-02-17 00:00:00" "1" "2025-08-28 08:50:35" 34 "2026-02-15 00:00:00" "2026-02-17 00:00:00" 111 100218 ] |
0.44 ms (0.19%) |
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.id = ? LIMIT 1
Parameters:
[
"5949"
]
|
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\User | No errors. |
App\MDS\AvexpressBundle\Entity\AveProductFile | No errors. |
App\MDS\AvexpressBundle\Entity\AveFiles | No errors. |
App\MDS\GreenPatioBundle\Entity\Reservation | No errors. |