https://inout.mante.solutions/avexpress/updateproductfilegridtwo/ Return to referer URL

Method
POST
HTTP Status
302
IP
83.48.78.112
Profiled on
Token
69d570

Query Metrics

98 Database Queries
8 Different statements
83.12 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.07 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: 
[
  "ayudantedeproduccion2@avexpress.tv"
]
View formatted query    View runnable query    Explain query
2 0.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: 
[
  "ayudantedeproduccion2@avexpress.tv"
]
View formatted query    View runnable query    Explain query
3 0.47 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118471"
]
View formatted query    View runnable query    Explain query
4 0.71 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
5 0.23 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.98 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, hourStart = ?, minStart = ?, hourEnd = ?, minEnd = ?, updatedAt = ?, updatedId = ?, currency = ?, price_over = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ?, rank_av = ?, location = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "00"
  "00"
  "00"
  "00"
  "2026-01-15 11:41:23"
  89
  "Euro"
  "0"
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  550.0
  6
  "Sala 25"
  118471
]
View formatted query    View runnable query    Explain query
7 2.47 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.74 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118175"
]
View formatted query    View runnable query    Explain query
9 0.24 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
10 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.49 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118175
]
View formatted query    View runnable query    Explain query
12 1.61 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 0.70 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118166"
]
View formatted query    View runnable query    Explain query
14 0.25 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
15 0.19 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.45 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118166
]
View formatted query    View runnable query    Explain query
17 1.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.69 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118168"
]
View formatted query    View runnable query    Explain query
19 0.21 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
20 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
21 0.38 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118168
]
View formatted query    View runnable query    Explain query
22 2.21 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
23 0.70 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118179"
]
View formatted query    View runnable query    Explain query
24 0.34 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
25 0.23 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
26 0.47 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118179
]
View formatted query    View runnable query    Explain query
27 2.09 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
28 0.69 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118173"
]
View formatted query    View runnable query    Explain query
29 0.23 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
30 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
31 0.50 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118173
]
View formatted query    View runnable query    Explain query
32 2.01 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
33 0.67 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118169"
]
View formatted query    View runnable query    Explain query
34 0.20 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
35 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
36 0.48 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118169
]
View formatted query    View runnable query    Explain query
37 1.66 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
38 0.62 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118167"
]
View formatted query    View runnable query    Explain query
39 0.20 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
40 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
41 0.48 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118167
]
View formatted query    View runnable query    Explain query
42 1.73 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 0.60 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118183"
]
View formatted query    View runnable query    Explain query
44 0.20 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
45 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
46 0.44 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  71.5
  118183
]
View formatted query    View runnable query    Explain query
47 1.94 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
48 0.64 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118170"
]
View formatted query    View runnable query    Explain query
49 0.25 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
50 0.19 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
51 0.47 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118170
]
View formatted query    View runnable query    Explain query
52 1.70 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
53 0.71 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118171"
]
View formatted query    View runnable query    Explain query
54 0.23 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
55 0.19 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
56 0.49 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118171
]
View formatted query    View runnable query    Explain query
57 1.67 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
58 0.65 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118348"
]
View formatted query    View runnable query    Explain query
59 0.22 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
60 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
61 0.35 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  165.0
  118348
]
View formatted query    View runnable query    Explain query
62 1.80 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
63 0.60 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118351"
]
View formatted query    View runnable query    Explain query
64 0.25 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
65 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
66 0.43 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  33.0
  118351
]
View formatted query    View runnable query    Explain query
67 1.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
68 0.65 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118174"
]
View formatted query    View runnable query    Explain query
69 0.23 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
70 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
71 0.42 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  0.0
  118174
]
View formatted query    View runnable query    Explain query
72 1.86 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
73 0.64 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118182"
]
View formatted query    View runnable query    Explain query
74 0.22 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
75 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
76 0.40 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  585.75
  118182
]
View formatted query    View runnable query    Explain query
77 1.86 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
78 0.65 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118177"
]
View formatted query    View runnable query    Explain query
79 0.20 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala 25"
]
View formatted query    View runnable query    Explain query
80 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
81 0.48 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  41.25
  118177
]
View formatted query    View runnable query    Explain query
82 1.84 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
83 0.70 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118330"
]
View formatted query    View runnable query    Explain query
84 0.41 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  "Sala de Cristal-Green Patio"
]
View formatted query    View runnable query    Explain query
85 0.20 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
86 1.02 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  308.0
  118330
]
View formatted query    View runnable query    Explain query
87 1.69 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
88 0.63 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118176"
]
View formatted query    View runnable query    Explain query
89 0.42 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  ""
]
View formatted query    View runnable query    Explain query
90 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
91 0.38 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  55.0
  118176
]
View formatted query    View runnable query    Explain query
92 1.87 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
93 0.63 ms 
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, t0.idGpLounge AS idGpLounge_55 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "118178"
]
View formatted query    View runnable query    Explain query
94 0.21 ms 
SELECT t0.id AS id_1, t0.Name AS Name_2, t0.Description AS Description_3, t0.idGpLounge AS idGpLounge_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8 FROM ave_product_file_location_names t0 WHERE t0.Name = ? LIMIT 1
Parameters: 
[
  ""
]
View formatted query    View runnable query    Explain query
95 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
96 15.38 ms 
UPDATE ave_product_file SET dateStart = ?, dateEnd = ?, pax = ?, updatedAt = ?, updatedId = ?, date_in_at = ?, date_out_at = ?, sub_total_price = ? WHERE id = ?
Parameters: 
[
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  "1"
  "2026-01-15 11:41:23"
  89
  "2026-01-28 00:00:00"
  "2026-01-28 00:00:00"
  165.0
  118178
]
View formatted query    View runnable query    Explain query
97 2.02 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
98 0.51 ms 
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: 
[
  "8023"
]
View formatted query    View runnable query    Explain query

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\AveProductFileLocationNames No errors.
App\MDS\AvexpressBundle\Entity\AveFiles No errors.
App\MDS\GreenPatioBundle\Entity\Reservation No errors.