Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

42.75 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	42.75 ms	SELECT b.id as batchId, b.batchNumber, b.name, count(s.id) as number FROM sp_startup_profiles s, sp_applications a, sp_batches b WHERE s.id = a.startupId and a.batchId = b.id and a.programId = :programId and a.batchStatus = 'pitch' GROUP BY b.batchNumber Parameters: [`"programId" => 1`] View formatted query View runnable query Explain query SELECT b.id as batchId, b.batchNumber, b.name, count(s.id) as number FROM sp_startup_profiles s, sp_applications a, sp_batches b WHERE s.id = a.startupId and a.batchId = b.id and a.programId = :programId and a.batchStatus = 'pitch' GROUP BY b.batchNumber SELECT b.id as batchId, b.batchNumber, b.name, count(s.id) as number FROM sp_startup_profiles s, sp_applications a, sp_batches b WHERE s.id = a.startupId and a.batchId = b.id and a.programId = 1 and a.batchStatus = 'pitch' GROUP BY b.batchNumber ;

#▲

Time

Info

42.75 ms

SELECT b.id as batchId, b.batchNumber, b.name, count(s.id) as number
            FROM   sp_startup_profiles s, sp_applications a, sp_batches b
            WHERE  s.id = a.startupId and a.batchId = b.id and a.programId = :programId and a.batchStatus = 'pitch'
            GROUP BY b.batchNumber

Parameters:

[
  "programId" => 1
]

View formatted query View runnable query Explain query

SELECT
  b.id as batchId,
  b.batchNumber,
  b.name,
  count(s.id) as number
FROM
  sp_startup_profiles s,
  sp_applications a,
  sp_batches b
WHERE
  s.id = a.startupId
  and a.batchId = b.id
  and a.programId = :programId
  and a.batchStatus = 'pitch'
GROUP BY
  b.batchNumber

SELECT b.id as batchId, b.batchNumber, b.name, count(s.id) as number
            FROM   sp_startup_profiles s, sp_applications a, sp_batches b
            WHERE  s.id = a.startupId and a.batchId = b.id and a.programId = 1 and a.batchStatus = 'pitch'
            GROUP BY b.batchNumber
                    ;

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.

Entities Mapping

Class	Mapping errors
App\StartPlatz\Bundle\MetaBundle\Entity\Tag	No errors.
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Startup	No errors.