Symfony Profiler

Query Metrics

39 Database Queries

7 Different statements

279.62 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

133.43 ms
(47.72%)

SELECT DISTINCT p0_.id AS id_0, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_1, COALESCE(v2_.priority, 99999) AS sclr_2, COALESCE(v3_.priority, 99999) AS sclr_3, p0_.vendor AS vendor_4, p0_.model AS model_5 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = ?) LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN ? AND ?) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_1 DESC, sclr_2 ASC, sclr_3 ASC, p0_.vendor ASC, p0_.model ASC LIMIT 32

Parameters:

[
  "nsk"
  2190
  174080
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  MAX(
    CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END
  ) AS sclr_1,
  COALESCE(v2_.priority, 99999) AS sclr_2,
  COALESCE(v3_.priority, 99999) AS sclr_3,
  p0_.vendor AS vendor_4,
  p0_.model AS model_5
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.calculated_price BETWEEN ?
      AND ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority
ORDER BY
  sclr_1 DESC,
  sclr_2 ASC,
  sclr_3 ASC,
  p0_.vendor ASC,
  p0_.model ASC
LIMIT
  32

SELECT DISTINCT p0_.id AS id_0, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_1, COALESCE(v2_.priority, 99999) AS sclr_2, COALESCE(v3_.priority, 99999) AS sclr_3, p0_.vendor AS vendor_4, p0_.model AS model_5 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'nsk') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN 2190 AND 174080) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_1 DESC, sclr_2 ASC, sclr_3 ASC, p0_.vendor ASC, p0_.model ASC LIMIT 32;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerG0Am81P\PaginatorProxy9cc2a8f->paginate (line 496)
16	App\Controller\MainController->shiny_filter (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

99.79 ms
(35.69%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = ?) LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN ? AND ?) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority

Parameters:

[
  "nsk"
  2190
  174080
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.calculated_price BETWEEN ?
      AND ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'nsk') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN 2190 AND 174080) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerG0Am81P\PaginatorProxy9cc2a8f->paginate (line 496)
16	App\Controller\MainController->shiny_filter (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

35.13 ms
(12.56%)

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.sale = true) AND (p0_.available=true)) AND p0_.p_type IN ('1')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  p0_.p_type AS p_type_34
FROM
  product p0_
WHERE
  (
    (p0_.sale = true)
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.sale = true) AND (p0_.available=true)) AND p0_.p_type IN ('1');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 186)
7	App\Controller\MainController->App\Controller\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 178)
13	App\Controller\MainController->getSale (line 507)
14	App\Controller\MainController->shiny_filter (line 178)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

7.65 ms
(2.74%)

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = ?

Parameters:

[
  "S_[CORDIANT]_732076783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_732076783';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 462)
8	App\Entity\Product->getTownCount (line 1635)
9	twig_get_attribute (line 43)
10	__TwigTemplate_a1ba83f2b13799c33e47deca6833b070->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 165)
13	__TwigTemplate_84819288042a54e187276d9190c0e53b->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 112)
16	__TwigTemplate_3c9eb42677d51db7b70bd30c9b0d5a76->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 81)
19	__TwigTemplate_6022a392a729f12d1d1a2adc7b1ecc94->block_shiny (line 171)
20	Twig\Template->displayBlock (line 96)
21	__TwigTemplate_f8271fa7f4d2d49d8dadd7b6af1efa51->block_content (line 171)
22	Twig\Template->displayBlock (line 80)
23	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
24	Twig\Template->displayBlock (line 151)
25	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 50)
28	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 53)
31	__TwigTemplate_f8271fa7f4d2d49d8dadd7b6af1efa51->doDisplay (line 394)
32	Twig\Template->displayWithErrorHandling (line 367)
33	Twig\Template->display (line 50)
34	__TwigTemplate_6022a392a729f12d1d1a2adc7b1ecc94->doDisplay (line 394)
35	Twig\Template->displayWithErrorHandling (line 367)
36	Twig\Template->display (line 379)
37	Twig\Template->render (line 38)
38	Twig\TemplateWrapper->render (line 280)
39	Twig\Environment->render (line 431)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 505)
43	App\Controller\MainController->shiny_filter (line 178)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 5)

2.68 ms
(0.96%)

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_34, COALESCE(v2_.priority, 99999) AS sclr_35, COALESCE(v3_.priority, 99999) AS sclr_36, p0_.p_type AS p_type_37 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = ?) LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN ? AND ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_34 DESC, sclr_35 ASC, sclr_36 ASC, p0_.vendor ASC, p0_.model ASC

Parameters:

[
  "nsk"
  2190
  174080
  "S_[CORDIANT]_1366253208"
  "S_[CORDIANT]_1429118343"
  "S_[CORDIANT]_650853919"
  "S_[CORDIANT]_732059768"
  "S_[CORDIANT]_732066289"
  "S_[CORDIANT]_732066311"
  "S_[CORDIANT]_732076783"
  "S_[CORDIANT]_732076975"
  "S_[CORDIANT]_04610088354337"
  "S_[CORDIANT]_04610088354351"
  "S_[CORDIANT]_04680197181209"
  "S_[CORDIANT]_1391885004"
  "S_[CORDIANT]_1439292091"
  "S_[CORDIANT]_1439292386"
  "S_[CORDIANT]_1439292561"
  "S_[CORDIANT]_1439292629"
  "S_[CORDIANT]_1439292673"
  "S_[CORDIANT]_1439294054"
  "S_[CORDIANT]_1439294063"
  "S_[CORDIANT]_1550000079"
  "S_[CORDIANT]_1550000080"
  "S_[CORDIANT]_1550000081"
  "S_[CORDIANT]_1550000082"
  "S_[CORDIANT]_1550000340"
  "S_[CORDIANT]_1358813109"
  "S_[CORDIANT]_1358813123"
  "S_[CORDIANT]_1305232007"
  "S_[CORDIANT]_1305232055"
  "S_[CORDIANT]_355816419"
  "S_[CORDIANT]_355816430"
  "S_[CORDIANT]_355816447"
  "S_[CORDIANT]_355816458"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  MAX(
    CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END
  ) AS sclr_34,
  COALESCE(v2_.priority, 99999) AS sclr_35,
  COALESCE(v3_.priority, 99999) AS sclr_36,
  p0_.p_type AS p_type_37
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.calculated_price BETWEEN ?
      AND ?
      AND p0_.id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?
      )
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority
ORDER BY
  sclr_34 DESC,
  sclr_35 ASC,
  sclr_36 ASC,
  p0_.vendor ASC,
  p0_.model ASC

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_34, COALESCE(v2_.priority, 99999) AS sclr_35, COALESCE(v3_.priority, 99999) AS sclr_36, p0_.p_type AS p_type_37 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'nsk') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.calculated_price BETWEEN 2190 AND 174080 AND p0_.id IN ('S_[CORDIANT]_1366253208', 'S_[CORDIANT]_1429118343', 'S_[CORDIANT]_650853919', 'S_[CORDIANT]_732059768', 'S_[CORDIANT]_732066289', 'S_[CORDIANT]_732066311', 'S_[CORDIANT]_732076783', 'S_[CORDIANT]_732076975', 'S_[CORDIANT]_04610088354337', 'S_[CORDIANT]_04610088354351', 'S_[CORDIANT]_04680197181209', 'S_[CORDIANT]_1391885004', 'S_[CORDIANT]_1439292091', 'S_[CORDIANT]_1439292386', 'S_[CORDIANT]_1439292561', 'S_[CORDIANT]_1439292629', 'S_[CORDIANT]_1439292673', 'S_[CORDIANT]_1439294054', 'S_[CORDIANT]_1439294063', 'S_[CORDIANT]_1550000079', 'S_[CORDIANT]_1550000080', 'S_[CORDIANT]_1550000081', 'S_[CORDIANT]_1550000082', 'S_[CORDIANT]_1550000340', 'S_[CORDIANT]_1358813109', 'S_[CORDIANT]_1358813123', 'S_[CORDIANT]_1305232007', 'S_[CORDIANT]_1305232055', 'S_[CORDIANT]_355816419', 'S_[CORDIANT]_355816430', 'S_[CORDIANT]_355816447', 'S_[CORDIANT]_355816458')) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_34 DESC, sclr_35 ASC, sclr_36 ASC, p0_.vendor ASC, p0_.model ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerG0Am81P\PaginatorProxy9cc2a8f->paginate (line 496)
16	App\Controller\MainController->shiny_filter (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.66 ms
(0.24%)

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = ? LIMIT 1

Parameters:

[
  "nsk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'nsk' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\EnvironmentProcessors\KolexTownProcessor->getEnv (line 368)
5	Symfony\Component\DependencyInjection\Container->getEnv (line 2200)
6	ContainerG0Am81P\App_KernelDevDebugContainer::getTwigService (line 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 431)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 505)
12	App\Controller\MainController->shiny_filter (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.28 ms
(0.10%)

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 76)
7	App\Service\Kolex->getTowns (line 1635)
8	twig_get_attribute (line 54)
9	__TwigTemplate_af3255f4a26e139158aac2b1209ce55b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 99)
12	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
13	Twig\Template->displayBlock (line 151)
14	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 50)
17	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 53)
20	__TwigTemplate_f8271fa7f4d2d49d8dadd7b6af1efa51->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 50)
23	__TwigTemplate_6022a392a729f12d1d1a2adc7b1ecc94->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 379)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 280)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 505)
32	App\Controller\MainController->shiny_filter (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	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\Product	No errors.
App\Entity\Tire	No errors.
App\Entity\Disk	No errors.
App\Entity\Order	No errors.
App\Entity\Rest	No errors.
App\Entity\VendorPriority	No errors.
App\Entity\Town	No errors.
App\Entity\Store	No errors.

Symfony Profiler

GET https://nsk.stokuznecov.ru/shiny/filter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping