Symfony Profiler

Query Metrics

32 Database Queries

23 Different statements

11.32 ms Query time

0 Invalid entities

81 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.96 ms
(17.31%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = ? LIMIT 1

Parameters:

[
  "showNotInStocks"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = 'showNotInStocks' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Util\Tools->inStockCheck (line 44)
4	App\Repository\ProductRepository::findProductsWithCategory (line 34)
5	call_user_func_array (line 311)
6	App\Service\ResponseService::createQueryBuilderWithPersistentObject (line 311)
7	App\Service\ResponseService->proccessQuery (line 318)
8	App\Service\ResponseService->createCollection (line 117)
9	App\Entity\DAO\ProductDAO->findProductsWithCategory (line 1169)
10	App\Service\Catalog\CatalogCategoryService->state (line 100)
11	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 83)
12	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	handle (line 25)

0.88 ms
(7.81%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.ozelkod AS ozelkod_14, p0_.ozelkod2 AS ozelkod2_15, p0_.ozelkod3 AS ozelkod3_16, p0_.ozelkod4 AS ozelkod4_17, p0_.ozelkod5 AS ozelkod5_18, p0_.ozelkod6 AS ozelkod6_19, p0_.ozelkod7 AS ozelkod7_20, p0_.ozelkod8 AS ozelkod8_21, p0_.ozelkod9 AS ozelkod9_22, p0_.ozelkod10 AS ozelkod10_23 FROM product p0_ INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p0_.id = p4_.product_id AND (p0_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c1_.id = ? AND p0_.parent_id IS NULL ORDER BY p0_.name ASC) dctrn_result) dctrn_table

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.code AS code_1,
          p0_.equivalent_code AS equivalent_code_2,
          p0_.name AS name_3,
          p0_.meta_description AS meta_description_4,
          p0_.meta_title AS meta_title_5,
          p0_.meta_keywords AS meta_keywords_6,
          p0_.description AS description_7,
          p0_.seo AS seo_8,
          p0_.default_unit AS default_unit_9,
          p0_.quantity AS quantity_10,
          p0_.tax_rate AS tax_rate_11,
          p0_.image AS image_12,
          p0_.currency AS currency_13,
          p0_.ozelkod AS ozelkod_14,
          p0_.ozelkod2 AS ozelkod2_15,
          p0_.ozelkod3 AS ozelkod3_16,
          p0_.ozelkod4 AS ozelkod4_17,
          p0_.ozelkod5 AS ozelkod5_18,
          p0_.ozelkod6 AS ozelkod6_19,
          p0_.ozelkod7 AS ozelkod7_20,
          p0_.ozelkod8 AS ozelkod8_21,
          p0_.ozelkod9 AS ozelkod9_22,
          p0_.ozelkod10 AS ozelkod10_23
        FROM
          product p0_
          INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id
          INNER JOIN category c1_ ON c1_.id = p2_.category_id
          LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
          INNER JOIN product_unit p4_ ON p0_.id = p4_.product_id
          AND (p0_.default_unit = p4_.value)
          INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
          AND (
            p4_.default_price_order = p5_.price_order
          )
          INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
        WHERE
          c1_.id = ?
          AND p0_.parent_id IS NULL
        ORDER BY
          p0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.ozelkod AS ozelkod_14, p0_.ozelkod2 AS ozelkod2_15, p0_.ozelkod3 AS ozelkod3_16, p0_.ozelkod4 AS ozelkod4_17, p0_.ozelkod5 AS ozelkod5_18, p0_.ozelkod6 AS ozelkod6_19, p0_.ozelkod7 AS ozelkod7_20, p0_.ozelkod8 AS ozelkod8_21, p0_.ozelkod9 AS ozelkod9_22, p0_.ozelkod10 AS ozelkod10_23 FROM product p0_ INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p0_.id = p4_.product_id AND (p0_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c1_.id = 67 AND p0_.parent_id IS NULL ORDER BY p0_.name ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 943)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	App\Service\ResponseService->findTotalRecord (line 255)
8	App\Service\ResponseService->proccessQuery (line 364)
9	App\Service\ResponseService->createCollection (line 117)
10	App\Entity\DAO\ProductDAO->findProductsWithCategory (line 1169)
11	App\Service\Catalog\CatalogCategoryService->state (line 100)
12	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 83)
13	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 197)
17	handle (line 25)

0.86 ms
(7.58%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\BaseController->__construct (line 55)
4	ContainerGH7gbdN\App_KernelDevDebugContainer->getGetCatalogControllerService (line 1922)
5	Symfony\Component\DependencyInjection\Container::make (line 231)
6	Symfony\Component\DependencyInjection\Container::get (line 211)
7	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
8	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
9	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 116)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
11	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

0.80 ms
(7.06%)

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id INNER JOIN product_to_category p6_ ON p2_.id = p6_.product_id INNER JOIN category c5_ ON c5_.id = p6_.category_id INNER JOIN product_unit p7_ ON p2_.id = p7_.product_id AND (p2_.default_unit = p7_.value) INNER JOIN product_price p8_ ON p7_.id = p8_.product_unit_id AND (p7_.default_price_order = p8_.price_order) INNER JOIN currency c9_ ON (c9_.code = p8_.currency) WHERE c5_.id = ? AND p2_.parent_id IS NULL GROUP BY v0_.id ORDER BY v0_.name ASC

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.code AS code_1,
  v0_.name AS name_2
FROM
  variant v0_
  INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id
  INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id
  INNER JOIN product p2_ ON p2_.id = p3_.product_id
  LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id
  INNER JOIN product_to_category p6_ ON p2_.id = p6_.product_id
  INNER JOIN category c5_ ON c5_.id = p6_.category_id
  INNER JOIN product_unit p7_ ON p2_.id = p7_.product_id
  AND (p2_.default_unit = p7_.value)
  INNER JOIN product_price p8_ ON p7_.id = p8_.product_unit_id
  AND (
    p7_.default_price_order = p8_.price_order
  )
  INNER JOIN currency c9_ ON (c9_.code = p8_.currency)
WHERE
  c5_.id = ?
  AND p2_.parent_id IS NULL
GROUP BY
  v0_.id
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id INNER JOIN product_to_category p6_ ON p2_.id = p6_.product_id INNER JOIN category c5_ ON c5_.id = p6_.category_id INNER JOIN product_unit p7_ ON p2_.id = p7_.product_id AND (p2_.default_unit = p7_.value) INNER JOIN product_price p8_ ON p7_.id = p8_.product_unit_id AND (p7_.default_price_order = p8_.price_order) INNER JOIN currency c9_ ON (c9_.code = p8_.currency) WHERE c5_.id = 67 AND p2_.parent_id IS NULL GROUP BY v0_.id ORDER BY v0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Service\ResponseService->proccessQuery (line 353)
7	App\Service\ResponseService->getResult (line 100)
8	App\Entity\DAO\VariantDAO->findVariantValueWithCategory (line 58)
9	App\Service\Catalog\CatalogCategoryService->data (line 137)
10	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 84)
11	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

0.61 ms
(5.37%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.meta_keyword AS meta_keyword_5,
  c0_.seo AS seo_6,
  c0_.order AS order_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\CategoryRepository->findAllCategories (line 72)
7	App\Controller\BaseController->response (line 219)
8	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 25)

0.57 ms
(5.00%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.code AS code_2, COUNT(p1_.id) AS sclr_3, 0 AS sclr_4 FROM brand b0_ INNER JOIN product p1_ ON b0_.id = p1_.brand_id INNER JOIN product_to_category p3_ ON p1_.id = p3_.product_id INNER JOIN category c2_ ON c2_.id = p3_.category_id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c2_.id = ? AND p1_.parent_id IS NULL GROUP BY b0_.id ORDER BY b0_.name ASC

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.code AS code_2,
  COUNT(p1_.id) AS sclr_3,
  0 AS sclr_4
FROM
  brand b0_
  INNER JOIN product p1_ ON b0_.id = p1_.brand_id
  INNER JOIN product_to_category p3_ ON p1_.id = p3_.product_id
  INNER JOIN category c2_ ON c2_.id = p3_.category_id
  INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id
  AND (p1_.default_unit = p4_.value)
  INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
  AND (
    p4_.default_price_order = p5_.price_order
  )
  INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
WHERE
  c2_.id = ?
  AND p1_.parent_id IS NULL
GROUP BY
  b0_.id
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.code AS code_2, COUNT(p1_.id) AS sclr_3, 0 AS sclr_4 FROM brand b0_ INNER JOIN product p1_ ON b0_.id = p1_.brand_id INNER JOIN product_to_category p3_ ON p1_.id = p3_.product_id INNER JOIN category c2_ ON c2_.id = p3_.category_id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c2_.id = 67 AND p1_.parent_id IS NULL GROUP BY b0_.id ORDER BY b0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Service\ResponseService->proccessQuery (line 353)
7	App\Service\ResponseService->getResult (line 100)
8	App\Entity\DAO\BrandDAO->findBrandWithCategory (line 54)
9	App\Service\Catalog\CatalogCategoryService->data (line 139)
10	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 84)
11	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

0.56 ms
(4.92%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, COUNT(p1_.id) AS sclr_8, c0_.parent_id AS parent_id_9 FROM category c0_ INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id INNER JOIN product p1_ ON p1_.id = p2_.product_id LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c0_.parent_id = ? AND p1_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.order ASC

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.meta_keyword AS meta_keyword_5,
  c0_.seo AS seo_6,
  c0_.order AS order_7,
  COUNT(p1_.id) AS sclr_8,
  c0_.parent_id AS parent_id_9
FROM
  category c0_
  INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id
  INNER JOIN product p1_ ON p1_.id = p2_.product_id
  LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id
  INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id
  AND (p1_.default_unit = p4_.value)
  INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
  AND (
    p4_.default_price_order = p5_.price_order
  )
  INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
WHERE
  c0_.parent_id = ?
  AND p1_.parent_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, COUNT(p1_.id) AS sclr_8, c0_.parent_id AS parent_id_9 FROM category c0_ INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id INNER JOIN product p1_ ON p1_.id = p2_.product_id LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c0_.parent_id = 67 AND p1_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.order ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Service\ResponseService->proccessQuery (line 353)
7	App\Service\ResponseService->getResult (line 100)
8	App\Entity\DAO\CategoryDAO->findCategoryWithCategory (line 53)
9	App\Service\Catalog\CatalogCategoryService->data (line 138)
10	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 84)
11	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

0.54 ms
(4.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?

Parameters:

[
  "67"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.seo AS seo_7,
  t0.order AS order_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = '67';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Service\Catalog\CatalogRequestService->parseUrl (line 135)
6	App\Service\Catalog\CatalogRequestService->get (line 56)
7	App\Service\Catalog\CatalogServiceFactory->createCatalogService (line 51)
8	ContainerGH7gbdN\App_KernelDevDebugContainer->getCatalogServiceInterfaceService (line 7490)
9	Symfony\Component\DependencyInjection\Container::getService (line 404)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 84)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
14	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 197)
18	handle (line 25)

0.45 ms
(4.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.seo AS seo_7,
  t0.order AS order_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 67;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 456)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216::block_body (line 196)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->block_mainBody (line 170)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_4dc439a7166ee3f0fb6a314e21ee336f->doDisplay (line 172)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->doDisplay (line 56)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216->doDisplay (line 61)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
26	App\Controller\BaseController->response (line 351)
27	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 197)
31	handle (line 25)

0.36 ms
(3.16%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.currency AS currency_3,
  t0.price_order AS price_order_4,
  t0.product_unit_id AS product_unit_id_5
FROM
  product_price t0
WHERE
  t0.product_unit_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = 49;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\ProductUnit->getDefaultPrice (line 294)
8	App\Entity\ProductUnit->postLoad (line 430)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 83)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3989)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 274)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1036)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1872)
16	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
17	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
18	Doctrine\ORM\PersistentCollection->initialize (line 218)
19	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
20	App\Entity\Product->postLoad (line 950)
21	Doctrine\ORM\Event\ListenersInvoker->invoke (line 83)
22	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
23	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3989)
24	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
25	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 274)
26	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1231)
27	Doctrine\ORM\AbstractQuery->execute (line 1172)
28	Doctrine\ORM\AbstractQuery->getResult (line 907)
29	App\Service\ResponseService->proccessQuery (line 360)
30	App\Service\ResponseService->createCollection (line 117)
31	App\Entity\DAO\ProductDAO->findProductsWithCategory (line 1169)
32	App\Service\Catalog\CatalogCategoryService->state (line 100)
33	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 83)
34	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 197)
38	handle (line 25)

0.35 ms
(3.11%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = ?

Parameters:

[
  125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.barcode AS barcode_3,
  t0.default_price_order AS default_price_order_4,
  t0.list_price_order AS list_price_order_5,
  t0.multiplier AS multiplier_6,
  t0.length AS length_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.weight AS weight_10,
  t0.product_id AS product_id_11
FROM
  product_unit t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = 125;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	App\Entity\Product->postLoad (line 950)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 83)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3989)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 274)
13	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1231)
14	Doctrine\ORM\AbstractQuery->execute (line 1172)
15	Doctrine\ORM\AbstractQuery->getResult (line 907)
16	App\Service\ResponseService->proccessQuery (line 360)
17	App\Service\ResponseService->createCollection (line 117)
18	App\Entity\DAO\ProductDAO->findProductsWithCategory (line 1169)
19	App\Service\Catalog\CatalogCategoryService->state (line 100)
20	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 83)
21	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	handle (line 25)

0.34 ms
(3.04%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = ?

Parameters:

[
  125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.warehouseId AS warehouseId_3,
  t0.date AS date_4,
  t0.warehouseName AS warehouseName_5,
  t0.inventoryId AS inventoryId_6,
  t0.productId AS productId_7
FROM
  stock_inventory t0
WHERE
  t0.productId = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = 125;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 157)
7	JMS\Serializer\Handler\ArrayCollectionHandler->serializeCollection (line 102)
8	call_user_func_array (line 50)
9	JMS\SerializerBundle\Debug\TraceableHandlerRegistry::JMS\SerializerBundle\Debug\{closure} (line 50)
10	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 224)
11	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
12	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
13	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
14	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
15	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
16	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
17	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
18	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
19	JMS\Serializer\Serializer->visit (line 256)
20	JMS\Serializer\Serializer->serialize (line 163)
21	App\Controller\BaseController->serialize (line 76)
22	App\Controller\BaseController->response (line 349)
23	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	handle (line 25)

0.33 ms
(2.93%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.status AS status_2
FROM
  page_category p0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      page p1_
    WHERE
      p1_.page_category_id = p0_.id
  ) > 0
ORDER BY
  p0_.status ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 224)
7	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.33 ms
(2.92%)

SELECT DISTINCT s0_.warehouseId AS warehouseId_0, s0_.warehouseName AS warehouseName_1 FROM stock_inventory s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.warehouseId AS warehouseId_0,
  s0_.warehouseName AS warehouseName_1
FROM
  stock_inventory s0_

SELECT DISTINCT s0_.warehouseId AS warehouseId_0, s0_.warehouseName AS warehouseName_1 FROM stock_inventory s0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\StockInventoryRepository->getWarehouses (line 14)
7	App\Controller\Catalog\Util\BasicFilterController->renderBasicFilter (line 40)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_58f6dfecdfc9d716e0f0d187745b0284->{closure} (line 154)
16	Twig\Extension\CoreExtension->captureOutput (line 2106)
17	__TwigTemplate_58f6dfecdfc9d716e0f0d187745b0284::macro_basic_filter (line 145)
18	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216->block_body (line 416)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->block_mainBody (line 170)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_4dc439a7166ee3f0fb6a314e21ee336f->doDisplay (line 172)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->doDisplay (line 56)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216->doDisplay (line 61)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
35	App\Controller\BaseController->response (line 351)
36	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 197)
40	handle (line 25)

0.33 ms
(2.91%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = ?

Parameters:

[
  125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.equivalent_code AS equivalent_code_3,
  t0.name AS name_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.description AS description_8,
  t0.seo AS seo_9,
  t0.default_unit AS default_unit_10,
  t0.quantity AS quantity_11,
  t0.tax_rate AS tax_rate_12,
  t0.image AS image_13,
  t0.currency AS currency_14,
  t0.ozelkod AS ozelkod_15,
  t0.ozelkod2 AS ozelkod2_16,
  t0.ozelkod3 AS ozelkod3_17,
  t0.ozelkod4 AS ozelkod4_18,
  t0.ozelkod5 AS ozelkod5_19,
  t0.ozelkod6 AS ozelkod6_20,
  t0.ozelkod7 AS ozelkod7_21,
  t0.ozelkod8 AS ozelkod8_22,
  t0.ozelkod9 AS ozelkod9_23,
  t0.ozelkod10 AS ozelkod10_24,
  t0.parent_id AS parent_id_25,
  t0.model_id AS model_id_26,
  t0.brand_id AS brand_id_27
FROM
  product t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = 125;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getValues (line 138)
7	App\Service\ResponseService->createCollection (line 124)
8	App\Entity\DAO\ProductDAO->findProductsWithCategory (line 1169)
9	App\Service\Catalog\CatalogCategoryService->state (line 100)
10	App\Service\Catalog\AbstractCatalogService->getCatalogResult (line 83)
11	App\Controller\Catalog\GetCatalogController->__invoke (line 24)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

0.29 ms
(2.60%)

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?

Parameters:

[
  "firstPageIsLogin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_
WHERE
  s0_.`key` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = 'firstPageIsLogin';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 959)
6	App\Repository\SettingRepository->getSetting (line 17)
7	App\Repository\SettingRepository->getBoolean (line 21)
8	App\Controller\BaseController->__construct (line 59)
9	ContainerGH7gbdN\App_KernelDevDebugContainer->getGetCatalogControllerService (line 1922)
10	Symfony\Component\DependencyInjection\Container::make (line 231)
11	Symfony\Component\DependencyInjection\Container::get (line 211)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 116)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	handle (line 25)

0.27 ms
(2.35%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\BaseController->response (line 120)
5	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 25)

0.26 ms
(2.31%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.description AS description_7,
  t0.logo AS logo_8,
  t0.whatsapp AS whatsapp_9,
  t0.social_media AS social_media_10,
  t0.whatsapp_control AS whatsapp_control_11
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\BaseController->response (line 134)
6	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 25)

0.26 ms
(2.29%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
GROUP BY
  p0_.page_category_id

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 230)
7	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.26 ms
(2.28%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 220)
7	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.25 ms
(2.23%)

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = ?

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.var1 AS var1_2,
  c0_.quantity AS quantity_3,
  c0_.customer_number AS customer_number_4,
  c0_.is_discounted AS is_discounted_5,
  c0_.product_id AS product_id_6,
  c0_.user_id AS user_id_7,
  c0_.product_unit_id AS product_unit_id_8
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\CartRepository->findCartItemsByCookie (line 26)
7	App\Controller\BaseController->getCart (line 404)
8	App\Controller\BaseController->response (line 182)
9	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 25)

0.23 ms
(2.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  brand t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Catalog\Util\BasicFilterController->renderBasicFilter (line 39)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
7	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
8	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
9	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
10	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
11	__TwigTemplate_58f6dfecdfc9d716e0f0d187745b0284->{closure} (line 154)
12	Twig\Extension\CoreExtension->captureOutput (line 2106)
13	__TwigTemplate_58f6dfecdfc9d716e0f0d187745b0284::macro_basic_filter (line 145)
14	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216->block_body (line 416)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->block_mainBody (line 170)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_4dc439a7166ee3f0fb6a314e21ee336f->doDisplay (line 172)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_7536763776677a8ba0fefe19b7c6756d->doDisplay (line 56)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_2fe2541df0405e81e2ea1e16308d1216->doDisplay (line 61)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
31	App\Controller\BaseController->response (line 351)
32	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 197)
36	handle (line 25)

0.23 ms
(2.03%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.exchangeRate AS exchangeRate_5
FROM
  currency t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\BaseController->getCurrencies (line 365)
5	App\Controller\BaseController->response (line 158)
6	App\Controller\Catalog\GetCatalogController->__invoke (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 25)

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\Setting	58
App\Entity\ProductPrice	10
App\Entity\Category	5
App\Entity\Currency	3
App\Entity\Product	1
App\Entity\ProductUnit	1
App\Entity\Store	1
App\Entity\StockInventory	1
App\Entity\Brand	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Setting	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\ProductUnit	No errors.
App\Entity\StockInventory	No errors.
App\Entity\Image	No errors.
App\Entity\VariantValue	No errors.
App\Entity\Campaign	No errors.
App\Entity\Model	No errors.
App\Entity\Brand	No errors.
App\Entity\ProductPrice	No errors.
App\Entity\Variant	No errors.
App\Entity\Store	No errors.
App\Entity\Currency	No errors.
App\Entity\Cart	No errors.
App\Entity\Page	No errors.
App\Entity\PageCategory	No errors.
App\Entity\CustomerBranch	No errors.
App\Entity\SalesRepresentative	No errors.

Symfony Profiler

GET https://devb2b.webticari.net/yedekparca-c-67?page=1&view=grid

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping