Query Metrics
46
Database Queries
31
Different statements
1102.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
243.27 ms (22.08%) |
3 |
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:
[
12548
]
|
|
226.71 ms (20.57%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54, CASE WHEN a0_.type = 'Vídeo' THEN 1 WHEN a0_.type = 'Sonido' THEN 2 WHEN a0_.type = 'Iluminación' THEN 3 WHEN a0_.type = 'Paquete' THEN 4 WHEN a0_.type IS NULL THEN 6 ELSE 5 END AS sclr_55, CASE WHEN a0_.location IS NULL OR a0_.location = '' THEN 1 ELSE 0 END AS sclr_56, CASE WHEN a1_.id IS NULL THEN 1 ELSE 0 END AS sclr_57 FROM ave_product_file a0_ LEFT JOIN ave_product_file_location_names a1_ ON (a0_.location = a1_.Name) WHERE a0_.fileId = ? ORDER BY sclr_56 ASC, sclr_57 ASC, a1_.id ASC, a0_.location ASC, sclr_55 ASC, a0_.rankquote_av ASC
Parameters:
[
12548
]
|
|
168.69 ms (15.31%) |
1 |
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, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
17726
]
|
|
108.75 ms (9.87%) |
3 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE a0_.fileId = ? AND a0_.type = ? AND a0_.location = ? AND a1_.proformaId = ? ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" "Vídeo" "null" 16280 ] |
|
108.24 ms (9.82%) |
3 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE a0_.fileId = ? AND a0_.type = ? AND a0_.location IS NULL AND a1_.proformaId = ? ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" "Vídeo" 16280 ] |
|
42.15 ms (3.82%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE a0_.fileId = ? AND a1_.proformaId = ? ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" 16280 ] |
|
37.31 ms (3.39%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE (a0_.fileId = ? AND a0_.type <> ? AND a0_.type <> ? AND a0_.type <> ? AND a0_.location = ? AND a1_.proformaId = ?) ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" "Vídeo" "Sonido" "Iluminación" "null" 16280 ] |
|
36.42 ms (3.30%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE (a0_.fileId = ? AND a0_.type <> ? AND a0_.type <> ? AND a0_.type <> ? AND a0_.location IS NULL AND a1_.proformaId = ?) ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" "Vídeo" "Sonido" "Iluminación" 16280 ] |
|
35.83 ms (3.25%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE (a0_.fileId = ? AND a0_.type IS NULL AND a0_.location IS NULL AND a1_.proformaId = ?) ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" 16280 ] |
|
35.82 ms (3.25%) |
1 |
SELECT a0_.id AS id_0, a0_.productName AS productName_1, a0_.productId AS productId_2, a0_.dateStart AS dateStart_3, a0_.dateEnd AS dateEnd_4, a0_.servicePrice AS servicePrice_5, a0_.fileId AS fileId_6, a0_.pax AS pax_7, a0_.type AS type_8, a0_.hourStart AS hourStart_9, a0_.minStart AS minStart_10, a0_.hourEnd AS hourEnd_11, a0_.minEnd AS minEnd_12, a0_.description AS description_13, a0_.createdAt AS createdAt_14, a0_.createdId AS createdId_15, a0_.updatedAt AS updatedAt_16, a0_.updatedId AS updatedId_17, a0_.supplierExt AS supplierExt_18, a0_.supplierExtId AS supplierExtId_19, a0_.service_id_proposal AS service_id_proposal_20, a0_.service_id_father AS service_id_father_21, a0_.control_id AS control_id_22, a0_.proposal_id AS proposal_id_23, a0_.destination_id AS destination_id_24, a0_.idea_id AS idea_id_25, a0_.activity_id AS activity_id_26, a0_.supplier_id AS supplier_id_27, a0_.assistant_id AS assistant_id_28, a0_.service_id AS service_id_29, a0_.service_cat_id AS service_cat_id_30, a0_.service_cat_name AS service_cat_name_31, a0_.name AS name_32, a0_.price AS price_33, a0_.currency AS currency_34, a0_.units AS units_35, a0_.op_commission AS op_commission_36, a0_.commission AS commission_37, a0_.op_over AS op_over_38, a0_.price_over AS price_over_39, a0_.op_iva AS op_iva_40, a0_.iva AS iva_41, a0_.hour AS hour_42, a0_.date_in_at AS date_in_at_43, a0_.date_out_at AS date_out_at_44, a0_.contcolor AS contcolor_45, a0_.rankquote AS rankquote_46, a0_.renovate AS renovate_47, a0_.pay AS pay_48, a0_.days AS days_49, a0_.sub_total_price AS sub_total_price_50, a0_.origin_id AS origin_id_51, a0_.rankquote_av AS rankquote_av_52, a0_.location AS location_53, a0_.idGpLounge AS idGpLounge_54 FROM ave_product_file a0_ INNER JOIN ave_doc_proforma_items a1_ ON (a1_.controlId = a0_.id) WHERE (a0_.fileId = ? AND a0_.type IS NULL AND a0_.location = ? AND a1_.proformaId = ?) ORDER BY a0_.rankquote_av ASC
Parameters:
[ "12548" "null" 16280 ] |
|
30.16 ms (2.74%) |
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.created_at AS created_at_19, t0.created_id AS created_id_20, t0.updated_at AS updated_at_21, t0.updated_id AS updated_id_22, t0.status AS status_23, t0.picture AS picture_24, t0.competency AS competency_25, t0.action AS action_26, t0.return_investment AS return_investment_27, t0.typology AS typology_28, t0.sage_code AS sage_code_29, t0.iban AS iban_30, t0.swift AS swift_31, t0.bank_name AS bank_name_32, t0.sent_to_sage AS sent_to_sage_33, t0.sync_date AS sync_date_34, t0.sage_payment_method_id AS sage_payment_method_id_35 FROM clients t0
Parameters:
[] |
|
9.60 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.fileId AS fileId_4, t0.items AS items_5, t0.accessKey AS accessKey_6, t0.createdAt AS createdAt_7, t0.createdId AS createdId_8, t0.updatedAt AS updatedAt_9, t0.updatedId AS updatedId_10 FROM ave_doc_proforma t0 WHERE t0.fileId = ?
Parameters:
[
"12548"
]
|
|
4.32 ms (0.39%) |
8 |
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.id = ? LIMIT 1
Parameters:
[
147648
]
|
|
3.85 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.file_id AS file_id_2, t0.dateAt AS dateAt_3, t0.name AS name_4, t0.totalNet AS totalNet_5, t0.iva AS iva_6, t0.vat AS vat_7, t0.total AS total_8, t0.master AS master_9, t0.number AS number_10, t0.prefix AS prefix_11, t0.type AS type_12, t0.balance AS balance_13, t0.created_at AS created_at_14, t0.created_id AS created_id_15, t0.updated_at AS updated_at_16, t0.updated_id AS updated_id_17, t0.access_key AS access_key_18, t0.client_name AS client_name_19, t0.client_address AS client_address_20, t0.client_document AS client_document_21, t0.client_type AS client_type_22, t0.benefit AS benefit_23, t24.id AS id_25, t24.sage_delivery_number AS sage_delivery_number_26, t24.sage_invoice_number AS sage_invoice_number_27, t24.sage_almacen AS sage_almacen_28, t24.factured AS factured_29, t24.is_rectificative AS is_rectificative_30, t24.sent_to_sage AS sent_to_sage_31, t24.sync_date AS sync_date_32, t24.factured_at AS factured_at_33, t24.created_at AS created_at_34, t24.updated_at AS updated_at_35, t24.last_error AS last_error_36, t24.letter AS letter_37, t24.pdf AS pdf_38, t24.client_id AS client_id_39, t24.rectifies_id AS rectifies_id_40, t24.sage_company_id AS sage_company_id_41, t24.reservation_invoice_id AS reservation_invoice_id_42, t24.reservation_invoice_rec_id AS reservation_invoice_rec_id_43, t24.ht_invoice_id AS ht_invoice_id_44, t24.ave_doc_invoice_id AS ave_doc_invoice_id_45, t24.ave_doc_invoice_rec_id AS ave_doc_invoice_rec_id_46 FROM ave_doc_invoice t0 LEFT JOIN delivery_note t24 ON t24.ave_doc_invoice_id = t0.id WHERE t0.file_id = ?
Parameters:
[
"12548"
]
|
|
1.83 ms (0.17%) |
1 |
SELECT t0.id AS id_1, t0.file_id AS file_id_2, t0.doc_id AS doc_id_3, t0.doc_type AS doc_type_4, t0.supplier_id AS supplier_id_5, t0.supplier_name AS supplier_name_6, t0.description AS description_7, t0.benefit_supplier AS benefit_supplier_8 FROM ave_benefits_supplier t0 WHERE t0.file_id = ?
Parameters:
[
"12548"
]
|
|
1.39 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.file_id AS file_id_2, t0.invoiceToRec AS invoiceToRec_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.totalNet AS totalNet_7, t0.iva AS iva_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.master AS master_12, t0.number AS number_13, t0.name AS name_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.client_name AS client_name_19, t0.client_address AS client_address_20, t0.client_document AS client_document_21, t0.client_type AS client_type_22, t23.id AS id_24, t23.sage_delivery_number AS sage_delivery_number_25, t23.sage_invoice_number AS sage_invoice_number_26, t23.sage_almacen AS sage_almacen_27, t23.factured AS factured_28, t23.is_rectificative AS is_rectificative_29, t23.sent_to_sage AS sent_to_sage_30, t23.sync_date AS sync_date_31, t23.factured_at AS factured_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.last_error AS last_error_35, t23.letter AS letter_36, t23.pdf AS pdf_37, t23.client_id AS client_id_38, t23.rectifies_id AS rectifies_id_39, t23.sage_company_id AS sage_company_id_40, t23.reservation_invoice_id AS reservation_invoice_id_41, t23.reservation_invoice_rec_id AS reservation_invoice_rec_id_42, t23.ht_invoice_id AS ht_invoice_id_43, t23.ave_doc_invoice_id AS ave_doc_invoice_id_44, t23.ave_doc_invoice_rec_id AS ave_doc_invoice_rec_id_45 FROM ave_doc_invoice_rec t0 LEFT JOIN delivery_note t23 ON t23.ave_doc_invoice_rec_id = t0.id WHERE t0.file_id = ?
Parameters:
[
"12548"
]
|
|
1.14 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
17726
]
|
|
1.04 ms (0.09%) |
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:
[
"12548"
]
|
|
0.96 ms (0.09%) |
2 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.signature AS signature_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.movil_password AS movil_password_7, t0.pass_gmail AS pass_gmail_8, t0.firm_gmail AS firm_gmail_9, t0.name AS name_10, t0.last_name AS last_name_11, t0.telephone AS telephone_12, t0.mobile AS mobile_13, t0.status AS status_14, t0.team_leader AS team_leader_15, t0.role AS role_16, t0.access_key AS access_key_17, t0.language AS language_18, t0.color AS color_19, t0.sidebar AS sidebar_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.description AS description_23, t0.job_title AS job_title_24, t0.reset_token AS reset_token_25, t0.id_office AS id_office_26, t0.id_company AS id_company_27, t0.id_user_rol AS id_user_rol_28, t0.id_team AS id_team_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admon@avexpress.tv"
]
|
|
0.62 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_type AS client_type_15, t0.client_id AS client_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = ? LIMIT 1
Parameters:
[
17726
]
|
|
0.43 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = ? LIMIT 1
Parameters:
[
"av"
]
|
|
0.43 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.service_id_father AS service_id_father_2, t0.control_id AS control_id_3, t0.origin_id AS origin_id_4, t0.proposal_id AS proposal_id_5, t0.destination_id AS destination_id_6, t0.activity_id AS activity_id_7, t0.idea_id AS idea_id_8, t0.supplier_id AS supplier_id_9, t0.assistant_id AS assistant_id_10, t0.service_id AS service_id_11, t0.service_cat_id AS service_cat_id_12, t0.service_cat_name AS service_cat_name_13, t0.name AS name_14, t0.price AS price_15, t0.pre_commission AS pre_commission_16, t0.pre_iva AS pre_iva_17, t0.currency AS currency_18, t0.units AS units_19, t0.op_commission AS op_commission_20, t0.commission AS commission_21, t0.op_over AS op_over_22, t0.price_over AS price_over_23, t0.op_iva AS op_iva_24, t0.iva AS iva_25, t0.original_op_iva AS original_op_iva_26, t0.original_iva AS original_iva_27, t0.original_price AS original_price_28, t0.pax AS pax_29, t0.hour AS hour_30, t0.date_in_at AS date_in_at_31, t0.date_out_at AS date_out_at_32, t0.direct_payment AS direct_payment_33, t0.date_block_limit AS date_block_limit_34, t0.status_internal AS status_internal_35, t0.status AS status_36, t0.status_recommended AS status_recommended_37, t0.breakdown AS breakdown_38, t0.is_father AS is_father_39, t0.rankquote AS rankquote_40, t0.user_confirmed_id AS user_confirmed_id_41, t0.proposal_title AS proposal_title_42, t0.user_confirmed_full_name AS user_confirmed_full_name_43, t0.text_tooltip AS text_tooltip_44, t0.briefing AS briefing_45, t0.created_at AS created_at_46, t0.created_id AS created_id_47, t0.updated_at AS updated_at_48, t0.updated_id AS updated_id_49 FROM ave_budget_pending t0 WHERE t0.proposal_id IS NULL
Parameters:
[] |
|
0.43 ms (0.04%) |
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.created_at AS created_at_19, t0.created_id AS created_id_20, t0.updated_at AS updated_at_21, t0.updated_id AS updated_id_22, t0.status AS status_23, t0.picture AS picture_24, t0.competency AS competency_25, t0.action AS action_26, t0.return_investment AS return_investment_27, t0.typology AS typology_28, t0.sage_code AS sage_code_29, t0.iban AS iban_30, t0.swift AS swift_31, t0.bank_name AS bank_name_32, t0.sent_to_sage AS sent_to_sage_33, t0.sync_date AS sync_date_34, t0.sage_payment_method_id AS sage_payment_method_id_35 FROM clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"5820"
]
|
|
0.41 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameEn AS nameEn_3, t0.price AS price_4, t0.type AS type_5, t0.description AS description_6, t0.descriptionEn AS descriptionEn_7, t0.createdAt AS createdAt_8, t0.createdId AS createdId_9, t0.updatedAt AS updatedAt_10, t0.updatedId AS updatedId_11, t0.supplierExt AS supplierExt_12, t0.supplierExtId AS supplierExtId_13 FROM ave_product t0
Parameters:
[] |
|
0.38 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.region AS region_3, t0.province AS province_4, t0.population AS population_5, t0.title AS title_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10 FROM destinations t0
Parameters:
[] |
|
0.37 ms (0.03%) |
1 |
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.created_at AS created_at_11, t0.created_id AS created_id_12, t0.updated_at AS updated_at_13, t0.updated_id AS updated_id_14, t0.picture AS picture_15, t0.token AS token_16, t0.sage_company AS sage_company_17, t0.sage_group AS sage_group_18, t0.comision AS comision_19, t0.priority AS priority_20, t0.business_type AS business_type_21, t0.state AS state_22, t0.supplier_id AS supplier_id_23 FROM settings_company t0 WHERE t0.business_type = ? LIMIT 1
Parameters:
[
"audiovisual"
]
|
|
0.34 ms (0.03%) |
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.created_at AS created_at_19, t0.created_id AS created_id_20, t0.updated_at AS updated_at_21, t0.updated_id AS updated_id_22, t0.status AS status_23, t0.picture AS picture_24, t0.competency AS competency_25, t0.action AS action_26, t0.return_investment AS return_investment_27, t0.typology AS typology_28, t0.sage_code AS sage_code_29, t0.iban AS iban_30, t0.swift AS swift_31, t0.bank_name AS bank_name_32, t0.sent_to_sage AS sent_to_sage_33, t0.sync_date AS sync_date_34, t0.sage_payment_method_id AS sage_payment_method_id_35 FROM clients t0 WHERE t0.id = ?
Parameters:
[
"5820"
]
|
|
0.33 ms (0.03%) |
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.28 ms (0.03%) |
1 |
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"
]
|
|
0.27 ms (0.02%) |
1 |
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"
]
|
|
0.24 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sage_code AS sage_code_4 FROM countries t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"62"
]
|
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.