Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.26 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

sphinx connection

Time▼	Count	Info
0.26 ms (100.00%)	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 = ? LIMIT 1 Parameters: [`"2-acetamido-2-deoxy-beta-d-glucopyranose-beta1-4-2-acetamido-1-6-anhydro-3-o--r-1-carboxyethyl-2-deoxy-beta-d-glucopyranose-l-alanyl-gamma-d-glutamyl-meso-diaminopimelyl-d-alanine"`] 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 = '2-acetamido-2-deoxy-beta-d-glucopyranose-beta1-4-2-acetamido-1-6-anhydro-3-o--r-1-carboxyethyl-2-deoxy-beta-d-glucopyranose-l-alanyl-gamma-d-glutamyl-meso-diaminopimelyl-d-alanine' LIMIT 1;

Time▼

Count

Info

0.26 ms
(100.00%)

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:

[
  "2-acetamido-2-deoxy-beta-d-glucopyranose-beta1-4-2-acetamido-1-6-anhydro-3-o--r-1-carboxyethyl-2-deoxy-beta-d-glucopyranose-l-alanyl-gamma-d-glutamyl-meso-diaminopimelyl-d-alanine"
]

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 = '2-acetamido-2-deoxy-beta-d-glucopyranose-beta1-4-2-acetamido-1-6-anhydro-3-o--r-1-carboxyethyl-2-deoxy-beta-d-glucopyranose-l-alanyl-gamma-d-glutamyl-meso-diaminopimelyl-d-alanine' 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
App\Entity\Drug	1

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.