Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.59 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

sphinx connection

Time▼	Count	Info
0.59 ms (100.00%)	1	SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.symbol AS symbol_3, t0.chromosome AS chromosome_4, t0.chromosomeSort AS chromosomeSort_5, t0.start AS start_6, t0.end AS end_7, t0.original AS original_8, t0.coverage AS coverage_9 FROM Gene t0 WHERE t0.symbol = ? LIMIT 1 Parameters: [`"INSIG2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.symbol AS symbol_3, t0.chromosome AS chromosome_4, t0.chromosomeSort AS chromosomeSort_5, t0.start AS start_6, t0.end AS end_7, t0.original AS original_8, t0.coverage AS coverage_9 FROM Gene t0 WHERE t0.symbol = ? LIMIT 1 SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.symbol AS symbol_3, t0.chromosome AS chromosome_4, t0.chromosomeSort AS chromosomeSort_5, t0.start AS start_6, t0.end AS end_7, t0.original AS original_8, t0.coverage AS coverage_9 FROM Gene t0 WHERE t0.symbol = 'INSIG2' LIMIT 1;

Time▼

Count

Info

0.59 ms
(100.00%)

SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.symbol AS symbol_3, t0.chromosome AS chromosome_4, t0.chromosomeSort AS chromosomeSort_5, t0.start AS start_6, t0.end AS end_7, t0.original AS original_8, t0.coverage AS coverage_9 FROM Gene t0 WHERE t0.symbol = ? LIMIT 1

Parameters:

[
  "INSIG2"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.pharm_id AS pharm_id_2,
  t0.symbol AS symbol_3,
  t0.chromosome AS chromosome_4,
  t0.chromosomeSort AS chromosomeSort_5,
  t0.start AS start_6,
  t0.end AS end_7,
  t0.original AS original_8,
  t0.coverage AS coverage_9
FROM
  Gene t0
WHERE
  t0.symbol = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pharm_id AS pharm_id_2, t0.symbol AS symbol_3, t0.chromosome AS chromosome_4, t0.chromosomeSort AS chromosomeSort_5, t0.start AS start_6, t0.end AS end_7, t0.original AS original_8, t0.coverage AS coverage_9 FROM Gene t0 WHERE t0.symbol = 'INSIG2' 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\Gene	1

Entities Mapping

Class	Mapping 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.
App\Entity\Drug	No errors.
App\Entity\Variant	No errors.