https://inout.mante.solutions/avexpress/avexternal/printinvoice/912

Method
GET
HTTP Status
200
IP
114.119.149.252
Profiled on
Token
fae15c

Query Metrics

30 Database Queries
20 Different statements
448.95 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 110.72 ms 
SELECT t0.id AS id_1, t0.fileId AS fileId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.prdControlId AS prdControlId_5, t0.prdName AS prdName_6, t0.prdProductId AS prdProductId_7, t0.prdDateStart AS prdDateStart_8, t0.prdDateEnd AS prdDateEnd_9, t0.prdServicePrice AS prdServicePrice_10, t0.prdPax AS prdPax_11, t0.prdType AS prdType_12, t0.prdHourStart AS prdHourStart_13, t0.prdMinStart AS prdMinStart_14, t0.prdHourEnd AS prdHourEnd_15, t0.prdMinEnd AS prdMinEnd_16, t0.prdSubTotalPrice AS prdSubTotalPrice_17, t0.prdQty AS prdQty_18, t0.prdDays AS prdDays_19, t0.prdIva AS prdIva_20, t0.prdOpIva AS prdOpIva_21, t0.srvControlId AS srvControlId_22, t0.srvSupplierId AS srvSupplierId_23, t0.srvServiceId AS srvServiceId_24, t0.srvServiceCatId AS srvServiceCatId_25, t0.srvServiceCatName AS srvServiceCatName_26, t0.srvName AS srvName_27, t0.srvPrice AS srvPrice_28, t0.srvCurrency AS srvCurrency_29, t0.srvUnits AS srvUnits_30, t0.srvOpCommission AS srvOpCommission_31, t0.srvCommission AS srvCommission_32, t0.srvOpOver AS srvOpOver_33, t0.srvOver AS srvOver_34, t0.srvOpIva AS srvOpIva_35, t0.srvIva AS srvIva_36, t0.srvPax AS srvPax_37, t0.srvHour AS srvHour_38, t0.srvDateInAt AS srvDateInAt_39, t0.srvDateOutAt AS srvDateOutAt_40, t0.srvContcolor AS srvContcolor_41, t0.srvRank AS srvRank_42, t0.srvAssistantId AS srvAssistantId_43, t0.srvActivityId AS srvActivityId_44, t0.srvPay AS srvPay_45, t0.payControlId AS payControlId_46, t0.payAmount AS payAmount_47, t0.payDatePayAt AS payDatePayAt_48, t0.payWayToPay AS payWayToPay_49, t0.payVat AS payVat_50, t0.payIva AS payIva_51, t0.payAmountTotal AS payAmountTotal_52, t0.createdAt AS createdAt_53, t0.createdId AS createdId_54, t0.updatedAt AS updatedAt_55, t0.updatedId AS updatedId_56, t0.rank_av AS rank_av_57, t0.location AS location_58 FROM ave_doc_invoice_items t0 WHERE t0.invoiceId = ?
Parameters: 
[
  "912"
]
View formatted query    View runnable query    Explain query
2 5.32 ms 
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 FROM ave_doc_invoice t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "912"
]
View formatted query    View runnable query    Explain query
3 2.95 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: 
[
  2144
]
View formatted query    View runnable query    Explain query
4 80.79 ms 
SELECT t0.id AS id_1, t0.fileId AS fileId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.prdControlId AS prdControlId_5, t0.prdName AS prdName_6, t0.prdProductId AS prdProductId_7, t0.prdDateStart AS prdDateStart_8, t0.prdDateEnd AS prdDateEnd_9, t0.prdServicePrice AS prdServicePrice_10, t0.prdPax AS prdPax_11, t0.prdType AS prdType_12, t0.prdHourStart AS prdHourStart_13, t0.prdMinStart AS prdMinStart_14, t0.prdHourEnd AS prdHourEnd_15, t0.prdMinEnd AS prdMinEnd_16, t0.prdSubTotalPrice AS prdSubTotalPrice_17, t0.prdQty AS prdQty_18, t0.prdDays AS prdDays_19, t0.prdIva AS prdIva_20, t0.prdOpIva AS prdOpIva_21, t0.srvControlId AS srvControlId_22, t0.srvSupplierId AS srvSupplierId_23, t0.srvServiceId AS srvServiceId_24, t0.srvServiceCatId AS srvServiceCatId_25, t0.srvServiceCatName AS srvServiceCatName_26, t0.srvName AS srvName_27, t0.srvPrice AS srvPrice_28, t0.srvCurrency AS srvCurrency_29, t0.srvUnits AS srvUnits_30, t0.srvOpCommission AS srvOpCommission_31, t0.srvCommission AS srvCommission_32, t0.srvOpOver AS srvOpOver_33, t0.srvOver AS srvOver_34, t0.srvOpIva AS srvOpIva_35, t0.srvIva AS srvIva_36, t0.srvPax AS srvPax_37, t0.srvHour AS srvHour_38, t0.srvDateInAt AS srvDateInAt_39, t0.srvDateOutAt AS srvDateOutAt_40, t0.srvContcolor AS srvContcolor_41, t0.srvRank AS srvRank_42, t0.srvAssistantId AS srvAssistantId_43, t0.srvActivityId AS srvActivityId_44, t0.srvPay AS srvPay_45, t0.payControlId AS payControlId_46, t0.payAmount AS payAmount_47, t0.payDatePayAt AS payDatePayAt_48, t0.payWayToPay AS payWayToPay_49, t0.payVat AS payVat_50, t0.payIva AS payIva_51, t0.payAmountTotal AS payAmountTotal_52, t0.createdAt AS createdAt_53, t0.createdId AS createdId_54, t0.updatedAt AS updatedAt_55, t0.updatedId AS updatedId_56, t0.rank_av AS rank_av_57, t0.location AS location_58 FROM ave_doc_invoice_items t0 WHERE t0.fileId = ? AND t0.invoiceId = ?
Parameters: 
[
  2144
  "912"
]
View formatted query    View runnable query    Explain query
5 21.57 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location = ? AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Vídeo"
  "null"
  "912"
]
View formatted query    View runnable query    Explain query
6 20.95 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location = ? AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Sonido"
  "null"
  "912"
]
View formatted query    View runnable query    Explain query
7 20.57 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location = ? AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Iluminación"
  "null"
  "912"
]
View formatted query    View runnable query    Explain query
8 21.15 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE (a0_.fileId = ? AND a0_.prdType <> ? AND a0_.prdType <> ? AND a0_.prdType <> ? AND a0_.location = ? AND a0_.invoiceId = ?) ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Vídeo"
  "Sonido"
  "Iluminación"
  "null"
  "912"
]
View formatted query    View runnable query    Explain query
9 20.97 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE (a0_.fileId = ? AND a0_.prdType IS NULL AND a0_.location = ? AND a0_.invoiceId = ?) ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "null"
  "912"
]
View formatted query    View runnable query    Explain query
10 21.17 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location IS NULL AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Vídeo"
  "912"
]
View formatted query    View runnable query    Explain query
11 20.57 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location IS NULL AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Sonido"
  "912"
]
View formatted query    View runnable query    Explain query
12 20.50 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE a0_.fileId = ? AND a0_.prdType = ? AND a0_.location IS NULL AND a0_.invoiceId = ? ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Iluminación"
  "912"
]
View formatted query    View runnable query    Explain query
13 20.69 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE (a0_.fileId = ? AND a0_.prdType <> ? AND a0_.prdType <> ? AND a0_.prdType <> ? AND a0_.location IS NULL AND a0_.invoiceId = ?) ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "Vídeo"
  "Sonido"
  "Iluminación"
  "912"
]
View formatted query    View runnable query    Explain query
14 20.76 ms 
SELECT a0_.id AS id_0, a0_.fileId AS fileId_1, a0_.invoiceId AS invoiceId_2, a0_.itemType AS itemType_3, a0_.prdControlId AS prdControlId_4, a0_.prdName AS prdName_5, a0_.prdProductId AS prdProductId_6, a0_.prdDateStart AS prdDateStart_7, a0_.prdDateEnd AS prdDateEnd_8, a0_.prdServicePrice AS prdServicePrice_9, a0_.prdPax AS prdPax_10, a0_.prdType AS prdType_11, a0_.prdHourStart AS prdHourStart_12, a0_.prdMinStart AS prdMinStart_13, a0_.prdHourEnd AS prdHourEnd_14, a0_.prdMinEnd AS prdMinEnd_15, a0_.prdSubTotalPrice AS prdSubTotalPrice_16, a0_.prdQty AS prdQty_17, a0_.prdDays AS prdDays_18, a0_.prdIva AS prdIva_19, a0_.prdOpIva AS prdOpIva_20, a0_.srvControlId AS srvControlId_21, a0_.srvSupplierId AS srvSupplierId_22, a0_.srvServiceId AS srvServiceId_23, a0_.srvServiceCatId AS srvServiceCatId_24, a0_.srvServiceCatName AS srvServiceCatName_25, a0_.srvName AS srvName_26, a0_.srvPrice AS srvPrice_27, a0_.srvCurrency AS srvCurrency_28, a0_.srvUnits AS srvUnits_29, a0_.srvOpCommission AS srvOpCommission_30, a0_.srvCommission AS srvCommission_31, a0_.srvOpOver AS srvOpOver_32, a0_.srvOver AS srvOver_33, a0_.srvOpIva AS srvOpIva_34, a0_.srvIva AS srvIva_35, a0_.srvPax AS srvPax_36, a0_.srvHour AS srvHour_37, a0_.srvDateInAt AS srvDateInAt_38, a0_.srvDateOutAt AS srvDateOutAt_39, a0_.srvContcolor AS srvContcolor_40, a0_.srvRank AS srvRank_41, a0_.srvAssistantId AS srvAssistantId_42, a0_.srvActivityId AS srvActivityId_43, a0_.srvPay AS srvPay_44, a0_.payControlId AS payControlId_45, a0_.payAmount AS payAmount_46, a0_.payDatePayAt AS payDatePayAt_47, a0_.payWayToPay AS payWayToPay_48, a0_.payVat AS payVat_49, a0_.payIva AS payIva_50, a0_.payAmountTotal AS payAmountTotal_51, a0_.createdAt AS createdAt_52, a0_.createdId AS createdId_53, a0_.updatedAt AS updatedAt_54, a0_.updatedId AS updatedId_55, a0_.rank_av AS rank_av_56, a0_.location AS location_57 FROM ave_doc_invoice_items a0_ WHERE (a0_.fileId = ? AND a0_.prdType IS NULL AND a0_.location IS NULL AND a0_.invoiceId = ?) ORDER BY a0_.rank_av ASC
Parameters: 
[
  2144
  "912"
]
View formatted query    View runnable query    Explain query
15 0.36 ms 
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.note_sin_iva AS note_sin_iva_11, t0.created_at AS created_at_12, t0.created_id AS created_id_13, t0.updated_at AS updated_at_14, t0.updated_id AS updated_id_15, t0.picture AS picture_16, t0.priority AS priority_17, t0.token AS token_18 FROM settings_company t0 WHERE t0.priority = ? LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
16 0.96 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33, t0.typology AS typology_34 FROM clients t0 WHERE t0.id = ?
Parameters: 
[
  "500"
]
View formatted query    View runnable query    Explain query
17 0.48 ms 
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: 
[
  "718002"
]
View formatted query    View runnable query    Explain query
18 0.23 ms 
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"
]
View formatted query    View runnable query    Explain query
19 0.22 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM countries t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "62"
]
View formatted query    View runnable query    Explain query
20 0.22 ms 
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: 
[
  "718002"
]
View formatted query    View runnable query    Explain query
21 0.19 ms 
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"
]
View formatted query    View runnable query    Explain query
22 0.15 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM countries t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "62"
]
View formatted query    View runnable query    Explain query
23 0.16 ms 
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 FROM ave_doc_invoice t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "912"
]
View formatted query    View runnable query    Explain query
24 0.93 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: 
[
  62467
]
View formatted query    View runnable query    Explain query
25 0.28 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: 
[
  62467
]
View formatted query    View runnable query    Explain query
26 6.32 ms 
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 FROM ave_doc_invoice_rec t0 WHERE t0.number = ?
Parameters: 
[
  "REC-AVE-190924-2144-912"
]
View formatted query    View runnable query    Explain query
27 6.70 ms 
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 FROM ave_doc_invoice t0 WHERE t0.file_id = ?
Parameters: 
[
  2144
]
View formatted query    View runnable query    Explain query
28 1.18 ms 
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 FROM ave_doc_invoice_rec t0 WHERE t0.file_id = ?
Parameters: 
[
  2144
]
View formatted query    View runnable query    Explain query
29 21.55 ms 
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: 
[
  2144
]
View formatted query    View runnable query    Explain query
30 0.33 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: 
[
  2144
]
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\MDS\AvexpressBundle\Entity\AveDocInvoiceItems No errors.
App\MDS\AvexpressBundle\Entity\AveDocInvoice No errors.
App\MDS\AvexpressBundle\Entity\AveFiles No errors.
App\MDS\GreenPatioBundle\Entity\Reservation No errors.
App\Entity\SettingsCompany No errors.
App\Entity\Client No errors.
App\Entity\Cities No errors.
App\Entity\Regions No errors.
App\Entity\Country No errors.
App\MDS\AvexpressBundle\Entity\AveProductFile No errors.
App\MDS\AvexpressBundle\Entity\AveDocInvoiceRec No errors.
App\MDS\AvexpressBundle\Entity\AveDocProforma No errors.