Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

4.92 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(29.05%)

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:

[
  "63b322bc649ae2a71ba9959f113573035e9cf1fd"
]

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 = '63b322bc649ae2a71ba9959f113573035e9cf1fd';

#	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	ContainerVUdOdP2\getMainControllerService::do (line 509)
13	ContainerVUdOdP2\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)

1.26 ms
(25.55%)

SELECT s0_.id AS id_0, s0_.full_name AS full_name_1, s0_.email AS email_2, s0_.phone AS phone_3, s0_.url AS url_4, s0_.status AS status_5, s0_.galery AS galery_6 FROM sale_person s0_ WHERE s0_.url = ?

Parameters:

[
  "th"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.full_name AS full_name_1,
  s0_.email AS email_2,
  s0_.phone AS phone_3,
  s0_.url AS url_4,
  s0_.status AS status_5,
  s0_.galery AS galery_6
FROM
  sale_person s0_
WHERE
  s0_.url = ?

SELECT s0_.id AS id_0, s0_.full_name AS full_name_1, s0_.email AS email_2, s0_.phone AS phone_3, s0_.url AS url_4, s0_.status AS status_5, s0_.galery AS galery_6 FROM sale_person s0_ WHERE s0_.url = 'th';

#	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 38)
7	App\Repository\SalePersonRepository->getBy (line 88)
8	App\Services\Store\CartService->getSalePersonBySlug (line 107)
9	App\Services\Store\CartService->initRecord (line 75)
10	App\Services\Store\CartService->init (line 46)
11	App\Controller\MainController->__construct (line 24)
12	ContainerVUdOdP2\getMainControllerService::do (line 509)
13	ContainerVUdOdP2\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.50 ms
(10.25%)

SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.url = ?

Parameters:

[
  "imessage:"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.url AS url_1,
  p0_.name AS name_2,
  p0_.sku AS sku_3,
  p0_.length AS length_4,
  p0_.width AS width_5,
  p0_.height AS height_6,
  p0_.description AS description_7,
  p0_.material AS material_8,
  p0_.status AS status_9,
  p0_.variant_type AS variant_type_10,
  p0_.related_products AS related_products_11,
  p0_.weight AS weight_12,
  p0_.priority AS priority_13,
  p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14,
  p0_.is_especial AS is_especial_15,
  p0_.is_collection AS is_collection_16,
  p0_.search_term_variations AS search_term_variations_17,
  p0_.wooden_base_price AS wooden_base_price_18,
  p0_.is_recognition AS is_recognition_19,
  p0_.main_variant_id AS main_variant_id_20
FROM
  product p0_
WHERE
  p0_.url = ?

SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.length AS length_4, p0_.width AS width_5, p0_.height AS height_6, p0_.description AS description_7, p0_.material AS material_8, p0_.status AS status_9, p0_.variant_type AS variant_type_10, p0_.related_products AS related_products_11, p0_.weight AS weight_12, p0_.priority AS priority_13, p0_.only_for_pick_up_in_store AS only_for_pick_up_in_store_14, p0_.is_especial AS is_especial_15, p0_.is_collection AS is_collection_16, p0_.search_term_variations AS search_term_variations_17, p0_.wooden_base_price AS wooden_base_price_18, p0_.is_recognition AS is_recognition_19, p0_.main_variant_id AS main_variant_id_20 FROM product p0_ WHERE p0_.url = 'imessage:';

#	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 41)
7	App\Repository\ProductRepository->getDetails (line 110)
8	App\Services\Store\StoreService->getProduct (line 134)
9	App\Controller\MainController->productsReturn (line 120)
10	App\Controller\MainController->productos_variant (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 13)

0.44 ms
(8.95%)

"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 111)
4	App\Services\Store\CartService->initRecord (line 75)
5	App\Services\Store\CartService->init (line 46)
6	App\Controller\MainController->__construct (line 24)
7	ContainerVUdOdP2\getMainControllerService::do (line 509)
8	ContainerVUdOdP2\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)

0.42 ms
(8.60%)

INSERT INTO cart (creation_date, creation_time, order_number, purchase_date, purchase_time, total_products, total_shipping, commission, payment_type, payment_order, payment_gateway, payment_auth, payment_status, courier, shipping_status, sha, currency, STATUS, lang, items_details, transaction_id, connection_status, promo_code, sale_person_id, client_id, shipping_address_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-03-28"
  "17:40:47"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "Open"
  null
  null
  null
  null
  null
  1
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO cart (
  creation_date, creation_time, order_number,
  purchase_date, purchase_time, total_products,
  total_shipping, commission, payment_type,
  payment_order, payment_gateway,
  payment_auth, payment_status, courier,
  shipping_status, sha, currency, STATUS,
  lang, items_details, transaction_id,
  connection_status, promo_code, sale_person_id,
  client_id, shipping_address_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO cart (creation_date, creation_time, order_number, purchase_date, purchase_time, total_products, total_shipping, commission, payment_type, payment_order, payment_gateway, payment_auth, payment_status, courier, shipping_status, sha, currency, STATUS, lang, items_details, transaction_id, connection_status, promo_code, sale_person_id, client_id, shipping_address_id) VALUES ('2026-03-28', '17:40:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Open', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL);

#	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 111)
7	App\Services\Store\CartService->initRecord (line 75)
8	App\Services\Store\CartService->init (line 46)
9	App\Controller\MainController->__construct (line 24)
10	ContainerVUdOdP2\getMainControllerService::do (line 509)
11	ContainerVUdOdP2\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.40 ms
(8.17%)

"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 111)
5	App\Services\Store\CartService->initRecord (line 75)
6	App\Services\Store\CartService->init (line 46)
7	App\Controller\MainController->__construct (line 24)
8	ContainerVUdOdP2\getMainControllerService::do (line 509)
9	ContainerVUdOdP2\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.27 ms
(5.45%)

UPDATE cart SET sha = ? WHERE id = ?

Parameters:

[
  "cf779502838e66266cefcaca7dfb3afd8a6be87c"
  965
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  cart
SET
  sha = ?
WHERE
  id = ?

UPDATE cart SET sha = 'cf779502838e66266cefcaca7dfb3afd8a6be87c' WHERE id = 965;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 114)
7	App\Services\Store\CartService->initRecord (line 75)
8	App\Services\Store\CartService->init (line 46)
9	App\Controller\MainController->__construct (line 24)
10	ContainerVUdOdP2\getMainControllerService::do (line 509)
11	ContainerVUdOdP2\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.20 ms
(3.98%)

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

Parameters:

[
  "cf779502838e66266cefcaca7dfb3afd8a6be87c"
  0
  "/en/products/imessage:/abelcasianaguilar@gmail.com"
  "1774744848"
  "63b322bc649ae2a71ba9959f113573035e9cf1fd"
  "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 ('cf779502838e66266cefcaca7dfb3afd8a6be87c', 0, '/en/products/imessage:/abelcasianaguilar@gmail.com', '1774744848', '63b322bc649ae2a71ba9959f113573035e9cf1fd', '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	ContainerVUdOdP2\getMainControllerService::do (line 509)
11	ContainerVUdOdP2\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)

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

Symfony Profiler

GET https://www.test.tierrahuichol.com/en/products/imessage:/abelcasianaguilar@gmail.com

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping