Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.57 ms Query time

1 Invalid entities

1 Managed entities

#▲	Time	Info
1	0.57 ms	SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.name AS name_3, t0.slug AS slug_4 FROM drug t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"lapatinib"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.name AS name_3, t0.slug AS slug_4 FROM drug t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.name AS name_3, t0.slug AS slug_4 FROM drug t0 WHERE t0.slug = 'lapatinib' LIMIT 1;

#▲

Time

Info

0.57 ms

SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.name AS name_3, t0.slug AS slug_4 FROM drug t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "lapatinib"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.pharm_id AS pharm_id_2,
  t0.name AS name_3,
  t0.slug AS slug_4
FROM
  drug t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.name AS name_3, t0.slug AS slug_4 FROM drug t0 WHERE t0.slug = 'lapatinib' LIMIT 1;

Name	Service
sphinx	doctrine.dbal.sphinx_connection
aux	doctrine.dbal.aux_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects
App\Entity\Drug	1

Class	Mapping errors
App\Entity\Drug	No errors.
App\Entity\Gene	The field App\Entity\Gene#drugs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Drug#genes does not contain the required 'inversedBy: "drugs"' attribute.