GET https://sanmigrafic.verproyecto.es/

Query Metrics

16 Database Queries
16 Different statements
6.71 ms Query time
2 Invalid entities
1880 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.52 ms
(37.59%)
1
SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.nombre AS nombre_2, c0_.apellidos AS apellidos_3, c0_.nif AS nif_4, c0_.iban AS iban_5, c0_.bic AS bic_6, c0_.codigo_forma_pago AS codigo_forma_pago_7, c0_.codigo_tipo_iva AS codigo_tipo_iva_8, c0_.telefono1 AS telefono1_9, c0_.telefono2 AS telefono2_10, c0_.fax AS fax_11, c0_.persona_contacto AS persona_contacto_12, c0_.email1 AS email1_13, c0_.email2 AS email2_14, c0_.numero_proveedor AS numero_proveedor_15, c0_.codigo_cuenta_contable AS codigo_cuenta_contable_16, c0_.iban_empresa AS iban_empresa_17, c0_.codigo_cliente_gestion AS codigo_cliente_gestion_18, c0_.empresa AS empresa_19, c0_.expiration_date AS expiration_date_20, c0_.group_delivery_note AS group_delivery_note_21, c0_.show_prices AS show_prices_22, c0_.observations AS observations_23, c0_.nombre_fiscal AS nombre_fiscal_24, c0_.facturacion_address_id AS facturacion_address_id_25, c0_.postal_address_id AS postal_address_id_26, c0_.payment_method_id AS payment_method_id_27 FROM cliente c0_
Parameters:
[]
0.95 ms
(14.09%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.slug AS slug_5 FROM budget_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.42 ms
(6.24%)
1
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.roles AS roles_2, a0_.password AS password_3, a0_.name AS name_4, a0_.status AS status_5 FROM admin a0_ WHERE a0_.roles LIKE ? AND a0_.status = 1 ORDER BY a0_.name ASC
Parameters:
[
  "%"ROLE_NEGOCIO"%"
]
0.31 ms
(4.63%)
1
SELECT COUNT(b0_.id) AS sclr_0, SUM(CASE WHEN b0_.requested = 1 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN b0_.requested = 0 THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN b0_.work_order = 0 AND b0_.budgeted = 1 THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN b0_.work_order = 1 THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN b0_.work_order = 1 AND b0_.albaranado = 0 THEN 1 ELSE 0 END) AS sclr_5 FROM budget b0_
Parameters:
[]
0.29 ms
(4.32%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM product_type p0_
Parameters:
[]
0.27 ms
(4.03%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM paper_format p0_
Parameters:
[]
0.24 ms
(3.62%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.status AS status_2, s0_.store AS store_3, s0_.price AS price_4 FROM standard_paper s0_
Parameters:
[]
0.23 ms
(3.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.slug AS slug_5 FROM budget_status_billing t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.22 ms
(3.31%)
1
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.status AS status_2 FROM open_format o0_
Parameters:
[]
0.20 ms
(3.01%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.status AS status_2, f0_.price AS price_3 FROM finished_material f0_
Parameters:
[]
0.20 ms
(2.96%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.status AS status_3, b0_.slug AS slug_4 FROM budget_status b0_
Parameters:
[]
0.20 ms
(2.92%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM paper_type p0_
Parameters:
[]
0.17 ms
(2.56%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.price_hour AS price_hour_3 FROM manipulated m0_
Parameters:
[]
0.17 ms
(2.47%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2 FROM shipping s0_
Parameters:
[]
0.16 ms
(2.46%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM paper_weight p0_
Parameters:
[]
0.16 ms
(2.38%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.status AS status_3, b0_.slug AS slug_4 FROM budget_status_billing b0_
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cliente 1581
App\Entity\StandardPaper 81
App\Entity\PaperType 56
App\Entity\FinishedMaterial 35
App\Entity\PaperWeight 29
App\Entity\Manipulated 24
App\Entity\PaperFormat 23
App\Entity\ProductType 11
App\Entity\OpenFormat 10
App\Entity\BudgetStatus 8
App\Entity\Address 8
App\Entity\BudgetStatusBilling 6
App\Entity\Shipping 4
App\Entity\PaymentMethod 3
App\Entity\Admin 1

Entities Mapping

Class Mapping errors
App\Entity\BudgetStatus No errors.
App\Entity\BudgetStatusBilling No errors.
App\Entity\Budget
  • The field 'App\Entity\Budget#shippingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Budget#subtotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Budget#total' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The mappings App\Entity\Budget#productionCover and App\Entity\StandardPaper#budgets are inconsistent with each other.
App\Entity\ProductType No errors.
App\Entity\PaperFormat No errors.
App\Entity\OpenFormat No errors.
App\Entity\StandardPaper No errors.
App\Entity\PaperType No errors.
App\Entity\PaperWeight No errors.
App\Entity\FinishedMaterial No errors.
App\Entity\Shipping No errors.
App\Entity\Manipulated No errors.
App\Entity\Cliente No errors.
App\Entity\Admin No errors.
App\Entity\Address No errors.
App\Entity\PaymentMethod
  • The field App\Entity\PaymentMethod#clientes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cliente#paymentMethod does not contain the required 'inversedBy: "clientes"' attribute.
App\Entity\AdminNotification No errors.