https://sistema.cglstorage.net/invoice/list

Query Metrics

13 Database Queries
5 Different statements
25.30 ms Query time
4 Invalid entities

Queries

Group similar statements

# 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
  • The association App\Entity\Invoice\Invoice#customer refers to the inverse side field App\Entity\Customer\Customer#invoices which does not exist.
  • The mappings App\Entity\Invoice\Invoice#dmc_ins and App\Entity\Invoice\InvoiceDmcIn#invoice are inconsistent with each other.
  • The mappings App\Entity\Invoice\Invoice#dmc_outs and App\Entity\Invoice\InvoiceDmcOut#invoice are inconsistent with each other.
  • The mappings App\Entity\Invoice\Invoice#files and App\Entity\Invoice\InvoiceFile#invoice are inconsistent with each other.
App\Entity\Customer\Customer No errors.
App\Entity\Invoice\InvoiceDmcIn
  • The association App\Entity\Invoice\InvoiceDmcIn#invoice refers to the inverse side field App\Entity\Invoice\Invoice#lines which does not exist.
App\Entity\Invoice\InvoiceDmcOut
  • The association App\Entity\Invoice\InvoiceDmcOut#invoice refers to the inverse side field App\Entity\Invoice\Invoice#lines which does not exist.
App\Entity\Invoice\InvoiceFile
  • The association App\Entity\Invoice\InvoiceFile#invoice refers to the inverse side field App\Entity\Invoice\Invoice#lines which does not exist.