Query Metrics
13
Database Queries
5
Different statements
25.30 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.05 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.username AS username_6, t0.password AS password_7, t0.telephone1 AS telephone1_8, t0.telephone2 AS telephone2_9, t0.is_admin AS is_admin_10, t0.enabled AS enabled_11, t0.last_login AS last_login_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 2 | 3.31 ms |
SELECT count(DISTINCT i0_.id) AS sclr_0 FROM invoice i0_ WHERE i0_.deleted IS NULL
Parameters:
[] |
| 3 | 12.93 ms |
SELECT DISTINCT i0_.id AS id_0, i0_.number AS number_1 FROM invoice i0_ WHERE i0_.deleted IS NULL ORDER BY i0_.number DESC LIMIT 20
Parameters:
[] |
| 4 | 1.54 ms |
SELECT i0_.id AS id_0, i0_.sub AS sub_1, i0_.number AS number_2, i0_.guide_number AS guide_number_3, i0_.guide_attachment AS guide_attachment_4, i0_.handling AS handling_5, i0_.copies AS copies_6, i0_.dmc_in AS dmc_in_7, i0_.dmc_in_total AS dmc_in_total_8, i0_.dmc_out AS dmc_out_9, i0_.dmc_out_total AS dmc_out_total_10, i0_.pre_attachment AS pre_attachment_11, i0_.ti_total AS ti_total_12, i0_.ti_cash AS ti_cash_13, i0_.ti_attachment AS ti_attachment_14, i0_.stamp_text AS stamp_text_15, i0_.stamp_total AS stamp_total_16, i0_.stamp_cost AS stamp_cost_17, i0_.online_payment AS online_payment_18, i0_.additional_form AS additional_form_19, i0_.unload_load AS unload_load_20, i0_.ramp AS ramp_21, i0_.forklift AS forklift_22, i0_.overtime AS overtime_23, i0_.warehouse AS warehouse_24, i0_.warehouse_text AS warehouse_text_25, i0_.quarantine AS quarantine_26, i0_.quarantine_bank_charge AS quarantine_bank_charge_27, i0_.apa AS apa_28, i0_.total AS total_29, i0_.expense AS expense_30, i0_.profit AS profit_31, i0_.invoice_date AS invoice_date_32, i0_.paid AS paid_33, i0_.paid_date AS paid_date_34, i0_.deleted AS deleted_35, i0_.customer_id AS customer_id_36, i0_.paid_by AS paid_by_37 FROM invoice i0_ WHERE i0_.deleted IS NULL AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.number DESC
Parameters:
[ 2072 2069 2068 2067 2066 2065 2064 2063 2062 2061 2060 2059 2058 2057 2056 2055 2054 2053 2052 2051 ] |
| 5 | 0.97 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 6 | 0.81 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 1.56 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 8 | 0.59 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 9 | 0.59 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 10 | 0.57 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
103
]
|
| 11 | 0.48 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
102
]
|
| 12 | 0.48 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
52
]
|
| 13 | 0.42 ms |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.business_name AS business_name_5, t0.business_identification AS business_identification_6, t0.code AS code_7, t0.customers AS customers_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.telephone1 AS telephone1_12, t0.telephone2 AS telephone2_13, t0.is_admin AS is_admin_14, t0.enabled AS enabled_15, t0.last_login AS last_login_16 FROM customer t0 WHERE t0.id = ?
Parameters:
[
12
]
|
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\User\User | No errors. |
| App\Entity\Invoice\Invoice |
|
| App\Entity\Customer\Customer | No errors. |
| App\Entity\Invoice\InvoiceDmcIn |
|
| App\Entity\Invoice\InvoiceDmcOut |
|
| App\Entity\Invoice\InvoiceFile |
|