Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.51 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

sphinx connection

#▲	Time	Info
1	0.51 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: [`"4r-5r-1-2-dithiane-4-5-diol"`] 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 = '4r-5r-1-2-dithiane-4-5-diol' LIMIT 1;

#▲

Time

Info

0.51 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:

[
  "4r-5r-1-2-dithiane-4-5-diol"
]

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 = '4r-5r-1-2-dithiane-4-5-diol' LIMIT 1;

Database Connections

Name	Service
sphinx	doctrine.dbal.sphinx_connection
aux	doctrine.dbal.aux_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

Entities Mapping

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.