Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

3.16 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.23 ms
(38.84%)

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:

[
  "050ad2182024ab2203d04be2dd2603d26442f2cc"
]

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 = '050ad2182024ab2203d04be2dd2603d26442f2cc';

#	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.10 ms
(34.83%)

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:

[
  "3b07b420040a322d2a53afe66b3f1fe036745008"
]

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 = '3b07b420040a322d2a53afe66b3f1fe036745008';

#	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	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.34 ms
(10.90%)

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:

[
  "torso-hombre"
]

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 = 'torso-hombre';

#	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 113)
10	App\Controller\MainController->productos (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.22 ms
(6.92%)

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

Parameters:

[
  "3b07b420040a322d2a53afe66b3f1fe036745008"
  3
  "/productos/torso-hombre"
  "1774740679"
  "050ad2182024ab2203d04be2dd2603d26442f2cc"
  "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 ('3b07b420040a322d2a53afe66b3f1fe036745008', 3, '/productos/torso-hombre', '1774740679', '050ad2182024ab2203d04be2dd2603d26442f2cc', '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)

0.14 ms
(4.43%)

"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	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.13 ms
(4.08%)

"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	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)

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.
App\Entity\Product	No errors.
App\Entity\Variant	No errors.

Symfony Profiler

GET https://www.test.tierrahuichol.com/productos/torso-hombre

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping