GET https://anexe.revoidea.com/admin/order/order-list/ajax/1?_=1764959500325

Query Metrics

8 Database Queries
6 Different statements
2.45 ms Query time
2 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.23 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.roles AS roles_7, t0.show_records_from_others AS show_records_from_others_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.57 ms
SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ WHERE o0_.responsible_id = ? ORDER BY o0_.id DESC LIMIT 10
Parameters:
[
  2
]
3 0.40 ms
SELECT o0_.id AS id_0, o0_.brand AS brand_1, o0_.number AS number_2, o0_.date_from AS date_from_3, o0_.date_to AS date_to_4, o0_.formula AS formula_5, o0_.po AS po_6, o0_.status AS status_7, o0_.currency_name AS currency_name_8, o0_.currency_symbol AS currency_symbol_9, o0_.currency_iso_code AS currency_iso_code_10, o0_.tax_value AS tax_value_11, o0_.publicity_tax_cost AS publicity_tax_cost_12, o0_.services_cost AS services_cost_13, o0_.net_cost AS net_cost_14, o0_.tax_cost AS tax_cost_15, o0_.cost AS cost_16, o0_.client_name AS client_name_17, o0_.client_administrator AS client_administrator_18, o0_.client_county_name AS client_county_name_19, o0_.client_registration_number AS client_registration_number_20, o0_.client_publicity_tax_included AS client_publicity_tax_included_21, o0_.supplier_name AS supplier_name_22, o0_.supplier_administrator AS supplier_administrator_23, o0_.supplier_county_name AS supplier_county_name_24, o0_.supplier_registration_number AS supplier_registration_number_25, o0_.contract_number AS contract_number_26, o0_.contract_date AS contract_date_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, o0_.contract_id AS contract_id_30, o0_.user_id AS user_id_31, o0_.responsible_id AS responsible_id_32, o0_.contract_annex_number_id AS contract_annex_number_id_33, o0_.currency_id AS currency_id_34, o0_.tax_id AS tax_id_35 FROM `order` o0_ WHERE o0_.responsible_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.id DESC
Parameters:
[
  2
  19
  18
  17
  16
  15
  14
  13
  12
  11
  10
]
4 0.20 ms
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.responsible_id = ?
Parameters:
[
  2
]
5 0.30 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.brand AS brand_3, t0.date AS date_4, t0.due_days AS due_days_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.client_id AS client_id_8, t0.user_id AS user_id_9, t0.responsible_id AS responsible_id_10 FROM contract t0 WHERE t0.id = ?
Parameters:
[
  44
]
6 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.vat_number AS vat_number_4, t0.is_tax_payer AS is_tax_payer_5, t0.analytic_account AS analytic_account_6, t0.registration_number AS registration_number_7, t0.address AS address_8, t0.phone AS phone_9, t0.email AS email_10, t0.bank_account AS bank_account_11, t0.bank AS bank_12, t0.administrator AS administrator_13, t0.publicity_tax_included AS publicity_tax_included_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.supplier_id AS supplier_id_17, t0.locality_id AS locality_id_18 FROM client t0 WHERE t0.id = ?
Parameters:
[
  58
]
7 0.20 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.brand AS brand_3, t0.date AS date_4, t0.due_days AS due_days_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.client_id AS client_id_8, t0.user_id AS user_id_9, t0.responsible_id AS responsible_id_10 FROM contract t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.vat_number AS vat_number_4, t0.is_tax_payer AS is_tax_payer_5, t0.analytic_account AS analytic_account_6, t0.registration_number AS registration_number_7, t0.address AS address_8, t0.phone AS phone_9, t0.email AS email_10, t0.bank_account AS bank_account_11, t0.bank AS bank_12, t0.administrator AS administrator_13, t0.publicity_tax_included AS publicity_tax_included_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.supplier_id AS supplier_id_17, t0.locality_id AS locality_id_18 FROM client t0 WHERE t0.id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
audit doctrine.dbal.audit_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 No errors.
App\Entity\Order No errors.
App\Entity\Contract
  • The field App\Entity\Contract#contractAnnexNumbers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractAnnexNumber#contract does not contain the required 'inversedBy="contractAnnexNumbers"' attribute.
App\Entity\ContractAnnexNumber No errors.
App\Entity\Currency No errors.
App\Entity\Tax No errors.
App\Entity\OrderLine
  • The mappings App\Entity\OrderLine#orderLineIntervals and App\Entity\OrderLineInterval#orderLine are inconsistent with each other.
App\Entity\Client No errors.
App\Entity\Supplier No errors.
App\Entity\Locality No errors.