Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

1.80 ms Query time

1 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.48 ms
(26.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1

Parameters:

[
  "App\Controller\Plugins\Integrations\Impact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.controller AS controller_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.insert_date AS insert_date_7,
  t0.channel_id AS channel_id_8
FROM
  integrations t0
WHERE
  t0.controller = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = 'App\\Controller\\Plugins\\Integrations\\Impact' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 27)
5	App\Repository\IntegrationsRepository->getByControllerName (line 58)
6	App\Service\Plugins\Integrations\Impact\ImpactService->__construct (line 1668)
7	ContainerCgtrJPN\App_KernelDevDebugContainer::getImpactServiceService (line 1637)
8	ContainerCgtrJPN\App_KernelDevDebugContainer::getImpactFetchService (line 1688)
9	ContainerCgtrJPN\App_KernelDevDebugContainer::getImpactStoresGridService (line 2330)
10	ContainerCgtrJPN\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1037)
11	ContainerCgtrJPN\App_KernelDevDebugContainer::ContainerCgtrJPN\{closure} (line 221)
12	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
13	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 14)

0.38 ms
(21.15%)

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1

Parameters:

[
  "impact_fetch_data"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label_id AS label_id_2,
  t0.integration AS integration_3,
  t0.config AS config_4,
  t0.last_execution AS last_execution_5,
  t0.every_minutes AS every_minutes_6,
  t0.next_execution AS next_execution_7
FROM
  cron t0
WHERE
  t0.label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = 'impact_fetch_data' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 57)
5	App\Service\Plugins\Integrations\Impact\ImpactFetch->__construct (line 1637)
6	ContainerCgtrJPN\App_KernelDevDebugContainer::getImpactFetchService (line 1688)
7	ContainerCgtrJPN\App_KernelDevDebugContainer::getImpactStoresGridService (line 2330)
8	ContainerCgtrJPN\App_KernelDevDebugContainer::getApp_EventListener_MainListenerService (line 1037)
9	ContainerCgtrJPN\App_KernelDevDebugContainer::ContainerCgtrJPN\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 14)

0.33 ms
(18.13%)

SELECT 
                p.name,
                p.*, 
                MATCH(p.name) AGAINST(? IN BOOLEAN MODE) AS score
            FROM products p
            WHERE MATCH(p.name) AGAINST(? IN BOOLEAN MODE) AND p.status = ?
            ORDER BY score DESC
            LIMIT 10

Parameters:

[
  "Daniel dev (!3) · Merge requests · TeamB / ExpertBiz Mobile · GitLab"
  "Daniel dev (!3) · Merge requests · TeamB / ExpertBiz Mobile · GitLab"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.name,
  p.*,
  MATCH(p.name) AGAINST(? IN BOOLEAN MODE) AS score
FROM
  products p
WHERE
  MATCH(p.name) AGAINST(? IN BOOLEAN MODE)
  AND p.status = ?
ORDER BY
  score DESC
LIMIT
  10

SELECT 
                p.name,
                p.*, 
                MATCH(p.name) AGAINST('Daniel dev (!3) · Merge requests · TeamB / ExpertBiz Mobile · GitLab' IN BOOLEAN MODE) AS score
            FROM products p
            WHERE MATCH(p.name) AGAINST('Daniel dev (!3) · Merge requests · TeamB / ExpertBiz Mobile · GitLab' IN BOOLEAN MODE) AND p.status = 1
            ORDER BY score DESC
            LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 33)
3	App\Repository\ProductsRepository->similarProducts (line 58)
4	App\Controller\API\ext\Product->searchProduct (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 14)

0.29 ms
(16.07%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status_id AS status_id_5, t0.role_id AS role_id_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.points AS points_9, t0.language AS language_10, t0.currency AS currency_11, t0.timezone AS timezone_12, t0.country AS country_13, t0.twofa AS twofa_14, t0.twofa_confirmed AS twofa_confirmed_15, t0.payout_id AS payout_id_16, t0.payout_details AS payout_details_17, t0.banned_until AS banned_until_18, t0.login_fails AS login_fails_19, t0.last_login_fail AS last_login_fail_20, t0.insert_date AS insert_date_21, t0.avatar AS avatar_22 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "surugiu.daniel@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.status_id AS status_id_5,
  t0.role_id AS role_id_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.points AS points_9,
  t0.language AS language_10,
  t0.currency AS currency_11,
  t0.timezone AS timezone_12,
  t0.country AS country_13,
  t0.twofa AS twofa_14,
  t0.twofa_confirmed AS twofa_confirmed_15,
  t0.payout_id AS payout_id_16,
  t0.payout_details AS payout_details_17,
  t0.banned_until AS banned_until_18,
  t0.login_fails AS login_fails_19,
  t0.last_login_fail AS last_login_fail_20,
  t0.insert_date AS insert_date_21,
  t0.avatar AS avatar_22
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status_id AS status_id_5, t0.role_id AS role_id_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.points AS points_9, t0.language AS language_10, t0.currency AS currency_11, t0.timezone AS timezone_12, t0.country AS country_13, t0.twofa AS twofa_14, t0.twofa_confirmed AS twofa_confirmed_15, t0.payout_id AS payout_id_16, t0.payout_details AS payout_details_17, t0.banned_until AS banned_until_18, t0.login_fails AS login_fails_19, t0.last_login_fail AS last_login_fail_20, t0.insert_date AS insert_date_21, t0.avatar AS avatar_22 FROM users t0 WHERE t0.email = 'surugiu.daniel@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 14)

0.20 ms
(11.30%)

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?

Parameters:

[
  "paths"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = 'paths';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 154)
5	App\Service\Utils\Options->getAllCategory (line 25)
6	App\Service\FrontEndRouter->__construct (line 23)
7	ContainerCgtrJPN\getFrontEndRouterService::do (line 779)
8	ContainerCgtrJPN\App_KernelDevDebugContainer->load (line 39)
9	ContainerCgtrJPN\getGetDataServiceService::do (line 779)
10	ContainerCgtrJPN\App_KernelDevDebugContainer->load (line 399)
11	Symfony\Component\DependencyInjection\Container->getService (line 36)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 56)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 37)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 14)

0.12 ms
(6.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "api_ext_search_product"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.route AS route_3,
  t0.icon AS icon_4,
  t0.parent AS parent_5,
  t0.menu_position AS menu_position_6,
  t0.popup_open AS popup_open_7,
  t0.mandatory AS mandatory_8,
  t0.menu_default AS menu_default_9
FROM
  modules t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = 'api_ext_search_product' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Service\ModulesManager->checkRoute (line 75)
6	App\EventListener\MainListener->onKernelController (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 14)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Options	6
App\Entity\Integrations	4
App\Entity\Channels	4
App\Entity\Cron	3
App\Entity\Users	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Users	The field 'App\Entity\Users#points' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Integrations	No errors.
App\Entity\Channels	No errors.
App\Entity\Cron	No errors.
App\Entity\Modules	No errors.
App\Entity\Options	No errors.
App\Entity\Products	No errors.

Symfony Profiler

POST https://couponscode.com/api/ext/search-product

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping