Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

11.91 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.89 ms
(83.09%)

SELECT c0_.id AS id_0, c0_.creation_date AS creation_date_1, c0_.creation_time AS creation_time_2, c0_.order_number AS order_number_3, c0_.purchase_date AS purchase_date_4, c0_.purchase_time AS purchase_time_5, c0_.total_products AS total_products_6, c0_.total_shipping AS total_shipping_7, c0_.commission AS commission_8, c0_.payment_type AS payment_type_9, c0_.payment_order AS payment_order_10, c0_.payment_gateway AS payment_gateway_11, c0_.payment_auth AS payment_auth_12, c0_.payment_status AS payment_status_13, c0_.courier AS courier_14, c0_.shipping_status AS shipping_status_15, c0_.sha AS sha_16, c0_.currency AS currency_17, c0_.status AS status_18, c0_.lang AS lang_19, c0_.items_details AS items_details_20, c0_.transaction_id AS transaction_id_21, c0_.connection_status AS connection_status_22, c0_.promo_code AS promo_code_23, c0_.sale_person_id AS sale_person_id_24, c0_.client_id AS client_id_25, c0_.shipping_address_id AS shipping_address_id_26 FROM cart c0_ WHERE c0_.sha = ?

Parameters:

[
  "ef117a1507b92bf86202e28aecba752f2331ea97"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.creation_date AS creation_date_1,
  c0_.creation_time AS creation_time_2,
  c0_.order_number AS order_number_3,
  c0_.purchase_date AS purchase_date_4,
  c0_.purchase_time AS purchase_time_5,
  c0_.total_products AS total_products_6,
  c0_.total_shipping AS total_shipping_7,
  c0_.commission AS commission_8,
  c0_.payment_type AS payment_type_9,
  c0_.payment_order AS payment_order_10,
  c0_.payment_gateway AS payment_gateway_11,
  c0_.payment_auth AS payment_auth_12,
  c0_.payment_status AS payment_status_13,
  c0_.courier AS courier_14,
  c0_.shipping_status AS shipping_status_15,
  c0_.sha AS sha_16,
  c0_.currency AS currency_17,
  c0_.status AS status_18,
  c0_.lang AS lang_19,
  c0_.items_details AS items_details_20,
  c0_.transaction_id AS transaction_id_21,
  c0_.connection_status AS connection_status_22,
  c0_.promo_code AS promo_code_23,
  c0_.sale_person_id AS sale_person_id_24,
  c0_.client_id AS client_id_25,
  c0_.shipping_address_id AS shipping_address_id_26
FROM
  cart c0_
WHERE
  c0_.sha = ?

SELECT c0_.id AS id_0, c0_.creation_date AS creation_date_1, c0_.creation_time AS creation_time_2, c0_.order_number AS order_number_3, c0_.purchase_date AS purchase_date_4, c0_.purchase_time AS purchase_time_5, c0_.total_products AS total_products_6, c0_.total_shipping AS total_shipping_7, c0_.commission AS commission_8, c0_.payment_type AS payment_type_9, c0_.payment_order AS payment_order_10, c0_.payment_gateway AS payment_gateway_11, c0_.payment_auth AS payment_auth_12, c0_.payment_status AS payment_status_13, c0_.courier AS courier_14, c0_.shipping_status AS shipping_status_15, c0_.sha AS sha_16, c0_.currency AS currency_17, c0_.status AS status_18, c0_.lang AS lang_19, c0_.items_details AS items_details_20, c0_.transaction_id AS transaction_id_21, c0_.connection_status AS connection_status_22, c0_.promo_code AS promo_code_23, c0_.sale_person_id AS sale_person_id_24, c0_.client_id AS client_id_25, c0_.shipping_address_id AS shipping_address_id_26 FROM cart c0_ WHERE c0_.sha = 'ef117a1507b92bf86202e28aecba752f2331ea97';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 56)
7	App\Repository\CartRepository->findBySha (line 52)
8	App\Services\Store\CartService->init (line 46)
9	App\Controller\MainController->__construct (line 24)
10	Container3xoZ8bc\getMainControllerService::do (line 509)
11	Container3xoZ8bc\App_KernelDevDebugContainer->load (line 229)
12	Symfony\Component\DependencyInjection\Container::make (line 211)
13	Symfony\Component\DependencyInjection\Container->get (line 40)
14	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
15	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
18	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 13)

1.51 ms
(12.71%)

SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.number AS number_2, j0_.url_used AS url_used_3, j0_.time AS time_4, j0_.nav_token AS nav_token_5, j0_.origin AS origin_6 FROM jump j0_ WHERE j0_.nav_token = ?

Parameters:

[
  "3d2e33b1964ab2d481d1273bb4370587883ba0c8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.token AS token_1,
  j0_.number AS number_2,
  j0_.url_used AS url_used_3,
  j0_.time AS time_4,
  j0_.nav_token AS nav_token_5,
  j0_.origin AS origin_6
FROM
  jump j0_
WHERE
  j0_.nav_token = ?

SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.number AS number_2, j0_.url_used AS url_used_3, j0_.time AS time_4, j0_.nav_token AS nav_token_5, j0_.origin AS origin_6 FROM jump j0_ WHERE j0_.nav_token = '3d2e33b1964ab2d481d1273bb4370587883ba0c8';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\JumpRepository->getBy (line 56)
8	App\Services\Admin\JumpService->getLastJump (line 83)
9	App\Services\Admin\JumpService->add (line 30)
10	App\Services\Admin\JumpService->init (line 50)
11	App\Controller\MainController->__construct (line 24)
12	Container3xoZ8bc\getMainControllerService::do (line 509)
13	Container3xoZ8bc\App_KernelDevDebugContainer->load (line 229)
14	Symfony\Component\DependencyInjection\Container::make (line 211)
15	Symfony\Component\DependencyInjection\Container->get (line 40)
16	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
17	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
18	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
19	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
20	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 13)

0.23 ms
(1.96%)

INSERT INTO jump (token, number, url_used, time, nav_token, origin) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "ef117a1507b92bf86202e28aecba752f2331ea97"
  4
  "/en/store"
  "1785095327"
  "3d2e33b1964ab2d481d1273bb4370587883ba0c8"
  "no-set"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO jump (
  token, number, url_used, time, nav_token,
  origin
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO jump (token, number, url_used, time, nav_token, origin) VALUES ('ef117a1507b92bf86202e28aecba752f2331ea97', 4, '/en/store', '1785095327', '3d2e33b1964ab2d481d1273bb4370587883ba0c8', 'no-set');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 88)
7	App\Services\Admin\JumpService->add (line 30)
8	App\Services\Admin\JumpService->init (line 50)
9	App\Controller\MainController->__construct (line 24)
10	Container3xoZ8bc\getMainControllerService::do (line 509)
11	Container3xoZ8bc\App_KernelDevDebugContainer->load (line 229)
12	Symfony\Component\DependencyInjection\Container::make (line 211)
13	Symfony\Component\DependencyInjection\Container->get (line 40)
14	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
15	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
18	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 13)

0.15 ms
(1.26%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 88)
5	App\Services\Admin\JumpService->add (line 30)
6	App\Services\Admin\JumpService->init (line 50)
7	App\Controller\MainController->__construct (line 24)
8	Container3xoZ8bc\getMainControllerService::do (line 509)
9	Container3xoZ8bc\App_KernelDevDebugContainer->load (line 229)
10	Symfony\Component\DependencyInjection\Container::make (line 211)
11	Symfony\Component\DependencyInjection\Container->get (line 40)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 13)

0.12 ms
(0.98%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 88)
4	App\Services\Admin\JumpService->add (line 30)
5	App\Services\Admin\JumpService->init (line 50)
6	App\Controller\MainController->__construct (line 24)
7	Container3xoZ8bc\getMainControllerService::do (line 509)
8	Container3xoZ8bc\App_KernelDevDebugContainer->load (line 229)
9	Symfony\Component\DependencyInjection\Container::make (line 211)
10	Symfony\Component\DependencyInjection\Container->get (line 40)
11	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
12	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
15	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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 13)

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\Entity\Cart	No errors.
App\Entity\SalePerson	No errors.
App\Entity\Client	No errors.
App\Entity\ShippingAddress	No errors.
App\Entity\Item	No errors.
App\Entity\Jump	No errors.

Symfony Profiler

GET https://www.test.tierrahuichol.com/en/store

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping