Symfony Profiler

Query Metrics

187 Database Queries

5 Different statements

26.73 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.74 ms
(40.18%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.title AS title_3, t0.price AS price_4, t0.position AS position_5, t0.inventory_policy AS inventory_policy_6, t0.compare_at_price AS compare_at_price_7, t0.option1 AS option1_8, t0.option2 AS option2_9, t0.option3 AS option3_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.taxable AS taxable_13, t0.barcode AS barcode_14, t0.fulfillment_service AS fulfillment_service_15, t0.grams AS grams_16, t0.inventory_management AS inventory_management_17, t0.requires_shipping AS requires_shipping_18, t0.sku AS sku_19, t0.weight AS weight_20, t0.weight_unit AS weight_unit_21, t0.inventory_item_id AS inventory_item_id_22, t0.inventory_quantity AS inventory_quantity_23, t0.old_inventory_quantity AS old_inventory_quantity_24, t0.admin_graphql_api_id AS admin_graphql_api_id_25, t0.image_id AS image_id_26 FROM shopify_product_variant t0 WHERE t0.id = ?

Parameters:

[
  42518572236915
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.title AS title_3,
  t0.price AS price_4,
  t0.position AS position_5,
  t0.inventory_policy AS inventory_policy_6,
  t0.compare_at_price AS compare_at_price_7,
  t0.option1 AS option1_8,
  t0.option2 AS option2_9,
  t0.option3 AS option3_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.taxable AS taxable_13,
  t0.barcode AS barcode_14,
  t0.fulfillment_service AS fulfillment_service_15,
  t0.grams AS grams_16,
  t0.inventory_management AS inventory_management_17,
  t0.requires_shipping AS requires_shipping_18,
  t0.sku AS sku_19,
  t0.weight AS weight_20,
  t0.weight_unit AS weight_unit_21,
  t0.inventory_item_id AS inventory_item_id_22,
  t0.inventory_quantity AS inventory_quantity_23,
  t0.old_inventory_quantity AS old_inventory_quantity_24,
  t0.admin_graphql_api_id AS admin_graphql_api_id_25,
  t0.image_id AS image_id_26
FROM
  shopify_product_variant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.title AS title_3, t0.price AS price_4, t0.position AS position_5, t0.inventory_policy AS inventory_policy_6, t0.compare_at_price AS compare_at_price_7, t0.option1 AS option1_8, t0.option2 AS option2_9, t0.option3 AS option3_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.taxable AS taxable_13, t0.barcode AS barcode_14, t0.fulfillment_service AS fulfillment_service_15, t0.grams AS grams_16, t0.inventory_management AS inventory_management_17, t0.requires_shipping AS requires_shipping_18, t0.sku AS sku_19, t0.weight AS weight_20, t0.weight_unit AS weight_unit_21, t0.inventory_item_id AS inventory_item_id_22, t0.inventory_quantity AS inventory_quantity_23, t0.old_inventory_quantity AS old_inventory_quantity_24, t0.admin_graphql_api_id AS admin_graphql_api_id_25, t0.image_id AS image_id_26 FROM shopify_product_variant t0 WHERE t0.id = 42518572236915;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 64)
6	App\EventListener\ShopifyContextInitializer->onKernelRequest (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 159)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
13	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

7.84 ms
(29.33%)

UPDATE shopify_product_variant SET id = ?, product_id = ?, created_at = ?, updated_at = ?, inventory_item_id = ? WHERE id = ?

Parameters:

[
  42518572236915
  7824669474931
  "2024-11-08 09:10:57"
  "2025-01-07 08:13:40"
  44543956320371
  "42518572236915"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  shopify_product_variant
SET
  id = ?,
  product_id = ?,
  created_at = ?,
  updated_at = ?,
  inventory_item_id = ?
WHERE
  id = ?

UPDATE shopify_product_variant SET id = 42518572236915, product_id = 7824669474931, created_at = '2024-11-08 09:10:57', updated_at = '2025-01-07 08:13:40', inventory_item_id = 44543956320371 WHERE id = '42518572236915';

#	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 90)
7	App\EventListener\ShopifyContextInitializer->onKernelRequest (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
14	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

3.89 ms
(14.56%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.vendor AS vendor_3, t0.product_type AS product_type_4, t0.price AS price_5, t0.inventory_quantity AS inventory_quantity_6, t0.status AS status_7 FROM shopify_product t0 WHERE t0.id = ?

Parameters:

[
  7824669474931
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.vendor AS vendor_3,
  t0.product_type AS product_type_4,
  t0.price AS price_5,
  t0.inventory_quantity AS inventory_quantity_6,
  t0.status AS status_7
FROM
  shopify_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.vendor AS vendor_3, t0.product_type AS product_type_4, t0.price AS price_5, t0.inventory_quantity AS inventory_quantity_6, t0.status AS status_7 FROM shopify_product t0 WHERE t0.id = 7824669474931;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 55)
6	App\EventListener\ShopifyContextInitializer->onKernelRequest (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 159)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
13	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

2.19 ms
(8.19%)

"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 90)
4	App\EventListener\ShopifyContextInitializer->onKernelRequest (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
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 5)

2.07 ms
(7.73%)

"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 90)
5	App\EventListener\ShopifyContextInitializer->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
12	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
17	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
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 5)

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\ShopifyProduct	No errors.
App\Entity\ShopifyProductVariant	No errors.

Symfony Profiler

GET http://pocshopi.prestarocket.com/aws/credentials

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping