Symfony Profiler

Query Metrics

119 Database Queries

13 Different statements

51.49 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.44 ms
(39.69%)

SELECT DISTINCT s0_.id AS id_0, p1_.name AS name_1 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (?, ?) AND s2_.is_active = ? AND s0_.is_active = ? AND s0_.price > 0) AND ((h4_.hotel_id = ? OR h4_.hotel_id IS NULL)) AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s2_.id NOT IN (?, ?) AND ((p1_.name LIKE ? OR p1_.id = ? OR p3_.name = ? OR s0_.supplier_code = ? OR p1_.manufacturer LIKE ?)) AND s2_.id = ? ORDER BY p1_.name ASC LIMIT 50

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  p1_.name AS name_1
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?
ORDER BY
  p1_.name ASC
LIMIT
  50

SELECT DISTINCT s0_.id AS id_0, p1_.name AS name_1 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 24 OR h4_.hotel_id IS NULL)) AND s2_.id IN (4, 37, 32, 30, 31, 27, 25, 24, 23, 22, 18, 17, 16, 38, 39, 35, 36, 48, 44, 50, 26, 61, 74, 47) AND s2_.id NOT IN (23, 17) AND ((p1_.name LIKE '%RYŻ%' OR p1_.id = 'RYŻ' OR p3_.name = 'RYŻ' OR s0_.supplier_code = 'RYŻ' OR p1_.manufacturer LIKE 'RYŻ')) AND s2_.id = '74' ORDER BY p1_.name ASC LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
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 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerFaXN2MD\PaginatorProxy9cc2a8f->paginate (line 172)
16	App\Repository\SupplierHasProductRepository->getForUser (line 316)
17	App\Controller\ProductController->searchForUser (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

20.41 ms
(39.64%)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (?, ?) AND s2_.is_active = ? AND s0_.is_active = ? AND s0_.price > 0) AND ((h4_.hotel_id = ? OR h4_.hotel_id IS NULL)) AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s2_.id NOT IN (?, ?) AND ((p1_.name LIKE ? OR p1_.id = ? OR p3_.name = ? OR s0_.supplier_code = ? OR p1_.manufacturer LIKE ?)) AND s2_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 24 OR h4_.hotel_id IS NULL)) AND s2_.id IN (4, 37, 32, 30, 31, 27, 25, 24, 23, 22, 18, 17, 16, 38, 39, 35, 36, 48, 44, 50, 26, 61, 74, 47) AND s2_.id NOT IN (23, 17) AND ((p1_.name LIKE '%RYŻ%' OR p1_.id = 'RYŻ' OR p3_.name = 'RYŻ' OR s0_.supplier_code = 'RYŻ' OR p1_.manufacturer LIKE 'RYŻ')) AND s2_.id = '74';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
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 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerFaXN2MD\PaginatorProxy9cc2a8f->paginate (line 172)
16	App\Repository\SupplierHasProductRepository->getForUser (line 316)
17	App\Controller\ProductController->searchForUser (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

4.60 ms
(8.92%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 INNER JOIN user_product ON t0.id = user_product.user_id WHERE user_product.product_id = ?

Parameters:

[
  47918
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
  INNER JOIN user_product ON t0.id = user_product.user_id
WHERE
  user_product.product_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 INNER JOIN user_product ON t0.id = user_product.user_id WHERE user_product.product_id = 47918;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 463)
8	App\Entity\Product->ifFavUser (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 110)
10	__TwigTemplate_fdf0d517e4e84af2d7af1ecb1f365e13->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 307)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 316)
18	App\Controller\ProductController->searchForUser (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

4.22 ms
(8.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = ?

Parameters:

[
  47918
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.is_active AS is_active_4,
  t0.max_limit AS max_limit_5,
  t0.unit AS unit_6,
  t0.ean AS ean_7,
  t0.pieces AS pieces_8,
  t0.dimension AS dimension_9,
  t0.manufacturer AS manufacturer_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = 47918;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Product::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Product->__get (line 121)
8	App\Entity\Product->getPhoto (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_fdf0d517e4e84af2d7af1ecb1f365e13->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 307)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 316)
18	App\Controller\ProductController->searchForUser (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.73 ms
(1.41%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = 36;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ProductCategory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\ProductCategory->__get (line 88)
8	App\Entity\ProductCategory->__toString (line 114)
9	Twig\Runtime\EscaperRuntime->escape (line 160)
10	__TwigTemplate_fdf0d517e4e84af2d7af1ecb1f365e13->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 307)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 316)
18	App\Controller\ProductController->searchForUser (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.22 ms
(0.43%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = ?

Parameters:

[
  95
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sell_limit AS sell_limit_3,
  t0.hotel_id AS hotel_id_4
FROM
  hotel_department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = 95;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\HotelDepartment::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\HotelDepartment->__get (line 164)
8	App\Entity\HotelDepartment->getHotelSupplierExcludeDepartments (line 58)
9	App\Repository\SupplierHasProductRepository->getForUser (line 316)
10	App\Controller\ProductController->searchForUser (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.21 ms
(0.41%)

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.supplier_code AS supplier_code_2, s0_.image AS image_3, s0_.last_price AS last_price_4, s0_.price_changed_at AS price_changed_at_5, s0_.price_last_at AS price_last_at_6, s0_.is_active AS is_active_7, s0_.extra_data AS extra_data_8, s0_.last_is_active AS last_is_active_9, s0_.supplier_id AS supplier_id_10, s0_.product_id AS product_id_11 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (?, ?) AND s2_.is_active = ? AND s0_.is_active = ? AND s0_.price > 0) AND ((h4_.hotel_id = ? OR h4_.hotel_id IS NULL)) AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s2_.id NOT IN (?, ?) AND ((p1_.name LIKE ? OR p1_.id = ? OR p3_.name = ? OR s0_.supplier_code = ? OR p1_.manufacturer LIKE ?)) AND s2_.id = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p1_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.price AS price_1,
  s0_.supplier_code AS supplier_code_2,
  s0_.image AS image_3,
  s0_.last_price AS last_price_4,
  s0_.price_changed_at AS price_changed_at_5,
  s0_.price_last_at AS price_last_at_6,
  s0_.is_active AS is_active_7,
  s0_.extra_data AS extra_data_8,
  s0_.last_is_active AS last_is_active_9,
  s0_.supplier_id AS supplier_id_10,
  s0_.product_id AS product_id_11
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p1_.name ASC

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.supplier_code AS supplier_code_2, s0_.image AS image_3, s0_.last_price AS last_price_4, s0_.price_changed_at AS price_changed_at_5, s0_.price_last_at AS price_last_at_6, s0_.is_active AS is_active_7, s0_.extra_data AS extra_data_8, s0_.last_is_active AS last_is_active_9, s0_.supplier_id AS supplier_id_10, s0_.product_id AS product_id_11 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 24 OR h4_.hotel_id IS NULL)) AND s2_.id IN (4, 37, 32, 30, 31, 27, 25, 24, 23, 22, 18, 17, 16, 38, 39, 35, 36, 48, 44, 50, 26, 61, 74, 47) AND s2_.id NOT IN (23, 17) AND ((p1_.name LIKE '%RYŻ%' OR p1_.id = 'RYŻ' OR p3_.name = 'RYŻ' OR s0_.supplier_code = 'RYŻ' OR p1_.manufacturer LIKE 'RYŻ')) AND s2_.id = '74' AND s0_.id IN (120787, 120795, 102969, 102971, 81618, 123773, 75214, 75207, 75202, 75195, 75189, 75182, 86343, 75936, 114124, 78980, 121222, 82199, 98758, 98772, 84284, 131160, 122150, 131941, 128510, 108893, 119078, 101242, 101235, 105010, 98730, 105886, 98751, 98765, 101228, 98737, 105017, 95529, 121989, 78082, 120587, 134368, 85436, 97201, 82535, 82542, 150161, 74915, 123793, 106000) ORDER BY p1_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
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 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerFaXN2MD\PaginatorProxy9cc2a8f->paginate (line 172)
16	App\Repository\SupplierHasProductRepository->getForUser (line 316)
17	App\Controller\ProductController->searchForUser (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.14 ms
(0.28%)

SELECT t0.id AS id_1, t0.hotel_has_supplier_id AS hotel_has_supplier_id_2, t0.department_id AS department_id_3 FROM hotel_supplier_exclude_department t0 WHERE t0.department_id = ?

Parameters:

[
  95
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hotel_has_supplier_id AS hotel_has_supplier_id_2,
  t0.department_id AS department_id_3
FROM
  hotel_supplier_exclude_department t0
WHERE
  t0.department_id = ?

SELECT t0.id AS id_1, t0.hotel_has_supplier_id AS hotel_has_supplier_id_2, t0.department_id AS department_id_3 FROM hotel_supplier_exclude_department t0 WHERE t0.department_id = 95;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 58)
8	App\Repository\SupplierHasProductRepository->getForUser (line 316)
9	App\Controller\ProductController->searchForUser (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.11 ms
(0.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?

Parameters:

[
  74
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.crated_at AS crated_at_8,
  t0.postcode AS postcode_9,
  t0.email_txt AS email_txt_10,
  t0.order_confirm_type AS order_confirm_type_11,
  t0.col_name AS col_name_12,
  t0.col_number AS col_number_13,
  t0.col_price AS col_price_14,
  t0.min_price AS min_price_15,
  t0.col_ean AS col_ean_16,
  t0.col_image AS col_image_17,
  t0.col_pieces AS col_pieces_18,
  t0.col_weight AS col_weight_19,
  t0.nip AS nip_20,
  t0.contact_name AS contact_name_21,
  t0.contact_surname AS contact_surname_22,
  t0.shortcut AS shortcut_23,
  t0.payment_term AS payment_term_24,
  t0.col_manufacture AS col_manufacture_25,
  t0.email_type AS email_type_26
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = 74;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Supplier::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Supplier->__get (line 611)
8	App\Entity\Supplier->getShortcut (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 147)
10	__TwigTemplate_fdf0d517e4e84af2d7af1ecb1f365e13->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 307)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 316)
18	App\Controller\ProductController->searchForUser (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.11 ms
(0.21%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  119
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = 119;

#	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 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.10 ms
(0.20%)

SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hotel_id AS hotel_id_2,
  t0.supplier_id AS supplier_id_3
FROM
  hotel_has_supplier t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = 24;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 50)
8	App\Repository\SupplierHasProductRepository->getForUser (line 316)
9	App\Controller\ProductController->searchForUser (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.10 ms
(0.20%)

SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = ?

Parameters:

[
  95
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hotel_department_id AS hotel_department_id_2,
  t0.product_category_id AS product_category_id_3
FROM
  hotel_department_has_exclude_category t0
WHERE
  t0.hotel_department_id = ?

SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = 95;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 65)
8	App\Repository\SupplierHasProductRepository->getForUser (line 316)
9	App\Controller\ProductController->searchForUser (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.10 ms
(0.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.city AS city_4,
  t0.address AS address_5,
  t0.month_limit AS month_limit_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.postcode AS postcode_9,
  t0.email AS email_10,
  t0.shortcut AS shortcut_11,
  t0.logo AS logo_12,
  t0.www AS www_13,
  t0.nip AS nip_14
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = 24;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Hotel::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Hotel->__get (line 542)
8	App\Entity\Hotel->getHotelHasSuppliers (line 50)
9	App\Repository\SupplierHasProductRepository->getForUser (line 316)
10	App\Controller\ProductController->searchForUser (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 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\User	No errors.
App\Entity\Hotel	No errors.
App\Entity\HotelDepartment	No errors.
App\Entity\Order	No errors.
App\Entity\Product	No errors.
App\Entity\Delivery	No errors.
App\Entity\HotelDepartmentCode	No errors.
App\Entity\SupplierHasProduct	No errors.
App\Entity\HotelHasSupplier	No errors.
App\Entity\HotelHasProductLimit	No errors.
App\Entity\HotelExcludeProduct	No errors.
App\Entity\Supplier	No errors.
App\Entity\HotelSupplierExcludeDepartment	No errors.
App\Entity\HotelDepartmentsExcludeSupplier	No errors.
App\Entity\HotelDepartmentHasExcludeCategory	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\OrderProduct	No errors.
App\Entity\OrderHasProduct	No errors.
App\Entity\SystemLog	No errors.
App\Entity\OrderHasNotice	No errors.

Symfony Profiler

GET https://zamowienia.dhapps.co.pl/product/search/for-user?category=&fav=&manufacturer=&name=RY%C5%BB&page=1&price1=&price2=&supplier=74

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping