Query Metrics
36
Database Queries
17
Different statements
533.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
198.23 ms (37.15%) |
1 |
SELECT t0.id AS id_1, t0.productName AS productName_2, t0.productId AS productId_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.fileId AS fileId_7, t0.pax AS pax_8, t0.type AS type_9, t0.hourStart AS hourStart_10, t0.minStart AS minStart_11, t0.hourEnd AS hourEnd_12, t0.minEnd AS minEnd_13, t0.description AS description_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.supplierExt AS supplierExt_19, t0.supplierExtId AS supplierExtId_20, t0.service_id_proposal AS service_id_proposal_21, t0.service_id_father AS service_id_father_22, t0.control_id AS control_id_23, t0.proposal_id AS proposal_id_24, t0.destination_id AS destination_id_25, t0.idea_id AS idea_id_26, t0.activity_id AS activity_id_27, t0.supplier_id AS supplier_id_28, t0.assistant_id AS assistant_id_29, t0.service_id AS service_id_30, t0.service_cat_id AS service_cat_id_31, t0.service_cat_name AS service_cat_name_32, t0.name AS name_33, t0.price AS price_34, t0.currency AS currency_35, t0.units AS units_36, t0.op_commission AS op_commission_37, t0.commission AS commission_38, t0.op_over AS op_over_39, t0.price_over AS price_over_40, t0.op_iva AS op_iva_41, t0.iva AS iva_42, t0.hour AS hour_43, t0.date_in_at AS date_in_at_44, t0.date_out_at AS date_out_at_45, t0.contcolor AS contcolor_46, t0.`rank` AS rank_47, t0.renovate AS renovate_48, t0.pay AS pay_49, t0.days AS days_50, t0.sub_total_price AS sub_total_price_51, t0.origin_id AS origin_id_52, t0.rank_av AS rank_av_53, t0.location AS location_54 FROM ave_product_file t0 WHERE t0.fileId = ?
Parameters:
[
5854
]
|
|
80.30 ms (15.05%) |
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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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_.rank_av ASC
Parameters:
[ 5854 "Vídeo" "null" 9194 ] |
|
76.23 ms (14.29%) |
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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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 OR a0_.location = ?) AND a1_.proformaId = ? ORDER BY a0_.rank_av ASC
Parameters:
[ 5854 "Vídeo" "" 9194 ] |
|
66.42 ms (12.45%) |
2 |
SELECT t0.id AS id_1, t0.controlId AS controlId_2, t0.type AS type_3, t0.fileId AS fileId_4, t0.proformaId AS proformaId_5 FROM ave_doc_proforma_items t0 WHERE t0.fileId = ? AND t0.proformaId = ? AND t0.controlId = ? LIMIT 1
Parameters:
[ 5854 9194 99537 ] |
|
25.71 ms (4.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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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 OR a0_.location = ?) AND a1_.proformaId = ? ORDER BY a0_.rank_av ASC
Parameters:
[ 5854 "Vídeo" "Sonido" "Iluminación" "" 9194 ] |
|
25.38 ms (4.76%) |
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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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 OR a0_.location = ?) AND a1_.proformaId = ? ORDER BY a0_.rank_av ASC
Parameters:
[ 5854 "" 9194 ] |
|
25.31 ms (4.74%) |
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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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_.rank_av ASC
Parameters:
[ 5854 "Vídeo" "Sonido" "Iluminación" "null" 9194 ] |
|
25.25 ms (4.73%) |
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_.`rank` AS rank_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_.rank_av AS rank_av_52, a0_.location AS location_53 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_.rank_av ASC
Parameters:
[ 5854 "null" 9194 ] |
|
1.49 ms (0.28%) |
3 |
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:
[
5854
]
|
|
1.43 ms (0.27%) |
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.id = ? LIMIT 1
Parameters:
[
"9194"
]
|
|
1.28 ms (0.24%) |
2 |
SELECT t0.id AS id_1, t0.productName AS productName_2, t0.productId AS productId_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.fileId AS fileId_7, t0.pax AS pax_8, t0.type AS type_9, t0.hourStart AS hourStart_10, t0.minStart AS minStart_11, t0.hourEnd AS hourEnd_12, t0.minEnd AS minEnd_13, t0.description AS description_14, t0.createdAt AS createdAt_15, t0.createdId AS createdId_16, t0.updatedAt AS updatedAt_17, t0.updatedId AS updatedId_18, t0.supplierExt AS supplierExt_19, t0.supplierExtId AS supplierExtId_20, t0.service_id_proposal AS service_id_proposal_21, t0.service_id_father AS service_id_father_22, t0.control_id AS control_id_23, t0.proposal_id AS proposal_id_24, t0.destination_id AS destination_id_25, t0.idea_id AS idea_id_26, t0.activity_id AS activity_id_27, t0.supplier_id AS supplier_id_28, t0.assistant_id AS assistant_id_29, t0.service_id AS service_id_30, t0.service_cat_id AS service_cat_id_31, t0.service_cat_name AS service_cat_name_32, t0.name AS name_33, t0.price AS price_34, t0.currency AS currency_35, t0.units AS units_36, t0.op_commission AS op_commission_37, t0.commission AS commission_38, t0.op_over AS op_over_39, t0.price_over AS price_over_40, t0.op_iva AS op_iva_41, t0.iva AS iva_42, t0.hour AS hour_43, t0.date_in_at AS date_in_at_44, t0.date_out_at AS date_out_at_45, t0.contcolor AS contcolor_46, t0.`rank` AS rank_47, t0.renovate AS renovate_48, t0.pay AS pay_49, t0.days AS days_50, t0.sub_total_price AS sub_total_price_51, t0.origin_id AS origin_id_52, t0.rank_av AS rank_av_53, t0.location AS location_54 FROM ave_product_file t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
99537
]
|
|
1.25 ms (0.23%) |
4 |
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:
[
"355651"
]
|
|
1.22 ms (0.23%) |
4 |
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:
[
"566"
]
|
|
1.21 ms (0.23%) |
2 |
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"
]
|
|
1.18 ms (0.22%) |
2 |
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:
[
"5084"
]
|
|
1.06 ms (0.20%) |
4 |
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:
[
"38"
]
|
|
0.68 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.controlId AS controlId_2, t0.name AS name_3, t0.amount AS amount_4, t0.iva AS iva_5, t0.total AS total_6, t0.file_id AS file_id_7, t0.created_at AS created_at_8, t0.created_id AS created_id_9, t0.updated_at AS updated_at_10, t0.updated_id AS updated_id_11 FROM ave_doc_proforma_deposit t0 WHERE t0.file_id = ?
Parameters:
[
5854
]
|
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\AveDocProforma | No errors. |
| App\Entity\SettingsCompany | No errors. |
| App\MDS\AvexpressBundle\Entity\AveFiles | No errors. |
| App\MDS\GreenPatioBundle\Entity\Reservation | 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\AveDocProformaItems | No errors. |
| App\MDS\AvexpressBundle\Entity\AveDocProformaDeposit | No errors. |