Query Metrics
5
Database Queries
5
Different statements
9.66 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.94 ms (30.38%) |
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.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"
]
|
2.13 ms (22.00%) |
1 |
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
]
|
2.11 ms (21.87%) |
1 |
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
]
|
2.04 ms (21.13%) |
1 |
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"
]
|
0.45 ms (4.61%) |
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.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"
]
|
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 |
|
App\Entity\HtVisit | No errors. |
App\Entity\SettingsCompany | No errors. |
App\Entity\HtInvoice |
|