Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.58 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.58 ms

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1

Parameters:

[
  "https://rct.dev.bbntimes.com/smartfren/ayce/product.php?adid=9496&agent=Mozilla%2F5.0%20%28Linux%3B%20Android%205.1%3B%20ConeXis%20A1%20Build%2FLMY47D%3B%20wv%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Version%2F4.0%20Chrome%2F50.0.2661.86%20Mobile%20Safari%2F537.36&clickme=1&country_id=100&crt_param=default&from=adid-434932&fromcrt=1&lan=id&operator=100199&phoneId=15413&product=79&sv=126sctfxxvc5nso5e0hd4ppo4"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_url AS original_url_2,
  t0.redirection_url AS redirection_url_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  redirection t0
WHERE
  t0.original_url = ?
  AND t0.status = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/smartfren/ayce/product.php?adid=9496&agent=Mozilla%2F5.0%20%28Linux%3B%20Android%205.1%3B%20ConeXis%20A1%20Build%2FLMY47D%3B%20wv%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Version%2F4.0%20Chrome%2F50.0.2661.86%20Mobile%20Safari%2F537.36&clickme=1&country_id=100&crt_param=default&from=adid-434932&fromcrt=1&lan=id&operator=100199&phoneId=15413&product=79&sv=126sctfxxvc5nso5e0hd4ppo4' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 26)
4	App\EventListener\RedirectionListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
App\Entity\Redirection	No errors.

Symfony Profiler

GET https://rct.dev.bbntimes.com/smartfren/ayce/product.php?adid=9496&agent=Mozilla%2F5.0%20%28Linux%3B%20Android%205.1%3B%20ConeXis%20A1%20Build%2FLMY47D%3B%20wv%2…

Configuration Settings

Theme