https://inout.mante.solutions/pdf/pdfhtinvoice/GP264

Query Metrics

3 Database Queries
3 Different statements
15.15 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 8.98 ms
SELECT h0_.id AS id_0, h0_.id_num AS id_num_1, h0_.prefix AS prefix_2, h0_.date_at AS date_at_3, h0_.type AS type_4, h0_.total_net AS total_net_5, h0_.vat_total_group AS vat_total_group_6, h0_.total AS total_7, h0_.client_name AS client_name_8, h0_.client_address AS client_address_9, h0_.client_document AS client_document_10, h0_.client_type AS client_type_11, h0_.benefit AS benefit_12, h0_.invoice_to_rec AS invoice_to_rec_13, h0_.ht_file_id AS ht_file_id_14 FROM ht_invoice h0_ WHERE h0_.id_num = ? AND h0_.prefix = ?
Parameters:
[
  "264"
  "GP"
]
2 5.05 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 = ?
Parameters:
[
  417
]
3 1.11 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 = ? LIMIT 1
Parameters:
[
  3416
]

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\HtInvoice
  • The association App\Entity\HtInvoice#htFile refers to the inverse side field App\Entity\HtFile#htInvoices which does not exist.
App\Entity\HtFile No errors.
App\Entity\HtInvoiceItems 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.