https://inout.mante.solutions/higotrigo/ht/invoice/htexternal/viewprintproforma/589

Query Metrics

5 Database Queries
5 Different statements
9.66 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.04 ms
SELECT t0.id AS id_1, t0.ht_file AS ht_file_2, t0.id_num AS id_num_3, t0.prefix AS prefix_4, t0.date_at AS date_at_5, t0.type AS type_6, t0.total_net AS total_net_7, t0.vat_total_group AS vat_total_group_8, t0.total AS total_9, t0.client_name AS client_name_10, t0.client_address AS client_address_11, t0.client_document AS client_document_12, t0.client_type AS client_type_13, t0.benefit AS benefit_14 FROM ht_proforma t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "589"
]
2 2.13 ms
SELECT t0.id AS id_1, t0.ht_file AS ht_file_2, t0.item_type AS item_type_3, t0.item_id_origin AS item_id_origin_4, t0.item_name AS item_name_5, t0.item_date_start AS item_date_start_6, t0.item_date_end AS item_date_end_7, t0.item_price AS item_price_8, t0.item_units AS item_units_9, t0.item_pax AS item_pax_10, t0.item_kg_lt AS item_kg_lt_11, t0.item_rank AS item_rank_12, t0.item_location AS item_location_13, t0.item_iva AS item_iva_14, t0.item_op_iva AS item_op_iva_15, t0.item_commission AS item_commission_16, t0.item_op_commission AS item_op_commission_17, t0.item_over AS item_over_18, t0.item_op_over AS item_op_over_19, t0.item_sub_total_price AS item_sub_total_price_20, t0.item_coste_directo AS item_coste_directo_21, t0.item_beneficio AS item_beneficio_22, t0.proforma_id AS proforma_id_23 FROM ht_proforma_items t0 WHERE t0.proforma_id = ?
Parameters:
[
  589
]
3 2.94 ms
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.proposal_id AS proposal_id_17, t0.created_id_id AS created_id_id_18, t0.updated_id_id AS updated_id_id_19, t0.client_contact_id AS client_contact_id_20, t0.reservation_id AS reservation_id_21 FROM ht_file t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "589"
]
4 0.45 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:
[
  "5"
]
5 2.11 ms
SELECT t0.id AS id_1, t0.id_num AS id_num_2, t0.prefix AS prefix_3, t0.date_at AS date_at_4, t0.type AS type_5, t0.total_net AS total_net_6, t0.vat_total_group AS vat_total_group_7, t0.total AS total_8, t0.client_name AS client_name_9, t0.client_address AS client_address_10, t0.client_document AS client_document_11, t0.client_type AS client_type_12, t0.benefit AS benefit_13, t0.invoice_to_rec AS invoice_to_rec_14, t0.ht_file_id AS ht_file_id_15 FROM ht_invoice t0 WHERE t0.ht_file_id = ?
Parameters:
[
  589
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\HtProforma No errors.
App\Entity\HtProformaItems No errors.
App\Entity\HtFile No errors.
App\Entity\Client No errors.
App\MDS\EventsBundle\Entity\Proposal No errors.
App\Entity\User No errors.
App\Entity\ClientContact No errors.
App\MDS\GreenPatioBundle\Entity\Reservation No errors.
App\Entity\HtItem
  • The mappings App\Entity\HtItem#htMenus and App\Entity\HtMenu#htItem are inconsistent with each other.
App\Entity\HtVisit No errors.
App\Entity\SettingsCompany No errors.
App\Entity\HtInvoice
  • The association App\Entity\HtInvoice#htFile refers to the inverse side field App\Entity\HtFile#htInvoices which does not exist.