Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

25.45 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.62 ms
(37.81%)

SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = ? AND p5_.uuid = ? AND o0_.vintage = ? AND e3_.status = ? AND o0_.status = 1 AND o0_.qty > 0 ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e3_.id = e6_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC LIMIT 50

Parameters:

[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.last_update AS last_update_1
FROM
  offer o0_
  LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id
  LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id
  LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id
  LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id)
  LEFT JOIN product p5_ ON o0_.product_id = p5_.id
  LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id
  LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id
  AND (
    p7_.product_id = p5_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e3_.id <> e6_.id
        OR (
          e3_.id = e6_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e3_.ignore_import = ?
  AND p5_.uuid = ?
  AND o0_.vintage = ?
  AND e3_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0
ORDER BY
  CASE WHEN (
    o0_.format_id = 3
    AND o0_.format_filled = 1
  ) THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN e3_.id = e6_.id THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN (
    CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
      o0_.price
    ELSE
      COALESCE(o0_.unoficial_price, o0_.price)
    END = 0
  ) THEN
    1
  ELSE
    0
  END ASC,
  CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
    o0_.price
  ELSE
    COALESCE(o0_.unoficial_price, o0_.price)
  END ASC,
  o0_.last_update DESC
LIMIT
  50

SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = 0 AND p5_.uuid = 'cd64e941-2745-492a-96bd-c1830bd99cab' AND o0_.vintage = 2020 AND e3_.status = 1 AND o0_.status = 1 AND o0_.qty > 0 ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e3_.id = e6_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerR5Vl0KB\PaginatorProxyBa079e5->paginate (line 80)
16	App\Service\Utils\PaginationService->paginate (line 242)
17	App\Components\Tables\Tables->getResults (line 349)
18	App\Components\Tables\Offer\OfferTable->getResults (line 1909)
19	Twig\Extension\CoreExtension::getAttribute (line 72)
20	__TwigTemplate_9921e6fc17f4dc05314a595bf9f5183a->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 331)
25	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 258)
26	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

9.35 ms
(36.75%)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = ? AND p5_.uuid = ? AND o0_.vintage = ? AND e3_.status = ? AND o0_.status = 1 AND o0_.qty > 0

Parameters:

[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offer o0_
  LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id
  LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id
  LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id
  LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id)
  LEFT JOIN product p5_ ON o0_.product_id = p5_.id
  LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id
  LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id
  AND (
    p7_.product_id = p5_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e3_.id <> e6_.id
        OR (
          e3_.id = e6_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e3_.ignore_import = ?
  AND p5_.uuid = ?
  AND o0_.vintage = ?
  AND e3_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = 0 AND p5_.uuid = 'cd64e941-2745-492a-96bd-c1830bd99cab' AND o0_.vintage = 2020 AND e3_.status = 1 AND o0_.status = 1 AND o0_.qty > 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerR5Vl0KB\PaginatorProxyBa079e5->paginate (line 80)
16	App\Service\Utils\PaginationService->paginate (line 242)
17	App\Components\Tables\Tables->getResults (line 349)
18	App\Components\Tables\Offer\OfferTable->getResults (line 1909)
19	Twig\Extension\CoreExtension::getAttribute (line 72)
20	__TwigTemplate_9921e6fc17f4dc05314a595bf9f5183a->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 331)
25	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 258)
26	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

2.78 ms
(10.93%)

SELECT o0_.id AS id_0, e1_.id AS id_1, CASE WHEN e1_.display_name IS NOT NULL AND e1_.display_name <> '' THEN e1_.display_name ELSE e1_.name END AS sclr_2, CASE WHEN o0_.import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3, CASE WHEN o2_.id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4, e1_.code AS code_5, o0_.id AS id_6, o0_.uuid AS uuid_7, o0_.type AS type_8, o0_.vintage AS vintage_9, o0_.packaging_flat AS packaging_flat_10, o0_.packaging_value AS packaging_value_11, o0_.is_flat AS is_flat_12, o0_.format_filled AS format_filled_13, o0_.type AS type_14, p3_.uuid AS uuid_15, p3_.name AS name_16, p3_.display_name AS display_name_17, p3_.code AS code_18, e4_.id AS id_19, o0_.category AS category_20, p5_.name AS name_21, p5_.code AS code_22, p6_.name AS name_23, o0_.qty AS qty_24, o0_.price AS price_25, o0_.last_update AS last_update_26, o0_.unoficial_qty AS unoficial_qty_27, o0_.unoficial_price AS unoficial_price_28, o0_.unoficial_update AS unoficial_update_29, o0_.status AS status_30, o0_.created_by_name AS created_by_name_31, o0_.comment AS comment_32, o0_.status AS status_33, e1_.provisioning AS provisioning_34, p7_.price AS price_35, p7_.recommended_price AS recommended_price_36, e1_.offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id) LEFT JOIN product p3_ ON o0_.product_id = p3_.id LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id AND (p7_.product_id = p3_.id AND p7_.year = o0_.vintage) WHERE (((e1_.id <> e4_.id OR (e1_.id = e4_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e1_.ignore_import = ? AND p3_.uuid = ? AND o0_.vintage = ? AND e1_.status = ? AND o0_.status = 1 AND o0_.qty > 0 AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e1_.id = e4_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC

Parameters:

[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
  208594
  26335
  224193
  246593
  176917
  14426
  30986
  140025
  9219
  9220
  76948
  244477
  3708
  169786
  102284
  94580
  51510
  129338
  20288
  20289
  194002
  19196
  75212
  75887
  154868
  15074
  129339
  103129
  3710
  154867
  162588
  224192
  76949
  224191
  224190
  15075
  15076
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  e1_.id AS id_1,
  CASE WHEN e1_.display_name IS NOT NULL
  AND e1_.display_name <> '' THEN
    e1_.display_name
  ELSE
    e1_.name
  END AS sclr_2,
  CASE WHEN o0_.import_process_id = 1 THEN
    'manual'
  ELSE
    'import'
  END AS sclr_3,
  CASE WHEN o2_.id IS NOT NULL THEN
    1
  ELSE
    0
  END AS sclr_4,
  e1_.code AS code_5,
  o0_.id AS id_6,
  o0_.uuid AS uuid_7,
  o0_.type AS type_8,
  o0_.vintage AS vintage_9,
  o0_.packaging_flat AS packaging_flat_10,
  o0_.packaging_value AS packaging_value_11,
  o0_.is_flat AS is_flat_12,
  o0_.format_filled AS format_filled_13,
  o0_.type AS type_14,
  p3_.uuid AS uuid_15,
  p3_.name AS name_16,
  p3_.display_name AS display_name_17,
  p3_.code AS code_18,
  e4_.id AS id_19,
  o0_.category AS category_20,
  p5_.name AS name_21,
  p5_.code AS code_22,
  p6_.name AS name_23,
  o0_.qty AS qty_24,
  o0_.price AS price_25,
  o0_.last_update AS last_update_26,
  o0_.unoficial_qty AS unoficial_qty_27,
  o0_.unoficial_price AS unoficial_price_28,
  o0_.unoficial_update AS unoficial_update_29,
  o0_.status AS status_30,
  o0_.created_by_name AS created_by_name_31,
  o0_.comment AS comment_32,
  o0_.status AS status_33,
  e1_.provisioning AS provisioning_34,
  p7_.price AS price_35,
  p7_.recommended_price AS recommended_price_36,
  e1_.offer_type AS offer_type_37
FROM
  offer o0_
  LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id
  LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id
  LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id
  LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id)
  LEFT JOIN product p3_ ON o0_.product_id = p3_.id
  LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id
  LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id
  AND (
    p7_.product_id = p3_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e1_.id <> e4_.id
        OR (
          e1_.id = e4_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e1_.ignore_import = ?
  AND p3_.uuid = ?
  AND o0_.vintage = ?
  AND e1_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )
ORDER BY
  CASE WHEN (
    o0_.format_id = 3
    AND o0_.format_filled = 1
  ) THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN e1_.id = e4_.id THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN (
    CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
      o0_.price
    ELSE
      COALESCE(o0_.unoficial_price, o0_.price)
    END = 0
  ) THEN
    1
  ELSE
    0
  END ASC,
  CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
    o0_.price
  ELSE
    COALESCE(o0_.unoficial_price, o0_.price)
  END ASC,
  o0_.last_update DESC

SELECT o0_.id AS id_0, e1_.id AS id_1, CASE WHEN e1_.display_name IS NOT NULL AND e1_.display_name <> '' THEN e1_.display_name ELSE e1_.name END AS sclr_2, CASE WHEN o0_.import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3, CASE WHEN o2_.id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4, e1_.code AS code_5, o0_.id AS id_6, o0_.uuid AS uuid_7, o0_.type AS type_8, o0_.vintage AS vintage_9, o0_.packaging_flat AS packaging_flat_10, o0_.packaging_value AS packaging_value_11, o0_.is_flat AS is_flat_12, o0_.format_filled AS format_filled_13, o0_.type AS type_14, p3_.uuid AS uuid_15, p3_.name AS name_16, p3_.display_name AS display_name_17, p3_.code AS code_18, e4_.id AS id_19, o0_.category AS category_20, p5_.name AS name_21, p5_.code AS code_22, p6_.name AS name_23, o0_.qty AS qty_24, o0_.price AS price_25, o0_.last_update AS last_update_26, o0_.unoficial_qty AS unoficial_qty_27, o0_.unoficial_price AS unoficial_price_28, o0_.unoficial_update AS unoficial_update_29, o0_.status AS status_30, o0_.created_by_name AS created_by_name_31, o0_.comment AS comment_32, o0_.status AS status_33, e1_.provisioning AS provisioning_34, p7_.price AS price_35, p7_.recommended_price AS recommended_price_36, e1_.offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id) LEFT JOIN product p3_ ON o0_.product_id = p3_.id LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id AND (p7_.product_id = p3_.id AND p7_.year = o0_.vintage) WHERE (((e1_.id <> e4_.id OR (e1_.id = e4_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e1_.ignore_import = 0 AND p3_.uuid = 'cd64e941-2745-492a-96bd-c1830bd99cab' AND o0_.vintage = 2020 AND e1_.status = 1 AND o0_.status = 1 AND o0_.qty > 0 AND o0_.id IN (208594, 26335, 224193, 246593, 176917, 14426, 30986, 140025, 9219, 9220, 76948, 244477, 3708, 169786, 102284, 94580, 51510, 129338, 20288, 20289, 194002, 19196, 75212, 75887, 154868, 15074, 129339, 103129, 3710, 154867, 162588, 224192, 76949, 224191, 224190, 15075, 15076) ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e1_.id = e4_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerR5Vl0KB\PaginatorProxyBa079e5->paginate (line 80)
16	App\Service\Utils\PaginationService->paginate (line 242)
17	App\Components\Tables\Tables->getResults (line 349)
18	App\Components\Tables\Offer\OfferTable->getResults (line 1909)
19	Twig\Extension\CoreExtension::getAttribute (line 72)
20	__TwigTemplate_9921e6fc17f4dc05314a595bf9f5183a->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 331)
25	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 258)
26	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.16 ms
(4.57%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 431)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 49)
5	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.68 ms
(2.69%)

SELECT * 
            FROM offer_history oh
            WHERE oh.offer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  offer_history oh
WHERE
  oh.offer_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT * 
            FROM offer_history oh
            WHERE oh.offer_id IN (208594, 26335, 224193, 246593, 176917, 14426, 30986, 9219, 140025, 9220, 76948, 244477, 3708, 169786, 102284, 94580, 51510, 129338, 20288, 20289, 194002, 19196, 75212, 75887, 154868, 15074, 129339, 103129, 3710, 154867, 162588, 224192, 76949, 224191, 224190, 15075, 15076);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 423)
2	App\Components\Tables\Offer\OfferTable->_getHistoriesForOffers (line 354)
3	App\Components\Tables\Offer\OfferTable->getResults (line 1909)
4	Twig\Extension\CoreExtension::getAttribute (line 72)
5	__TwigTemplate_9921e6fc17f4dc05314a595bf9f5183a->doDisplay (line 402)
6	Twig\Template->yield (line 358)
7	Twig\Template->display (line 373)
8	Twig\Template->render (line 77)
9	Symfony\UX\TwigComponent\ComponentRenderer->render (line 331)
10	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 258)
11	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.60 ms
(2.36%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.59 ms
(2.32%)

SELECT t0.code AS code_1, t0.display_name AS display_name_2, t0.lwin AS lwin_3, t0.site AS site_4, t0.seller_price_qty AS seller_price_qty_5, t0.price AS price_6, t0.merged_uuids AS merged_uuids_7, t0.has_lwin_suggests AS has_lwin_suggests_8, t0.from_import AS from_import_9, t0.bundle AS bundle_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.name AS name_13, t0.status AS status_14, t0.country_id AS country_id_15, t0.region_id AS region_id_16, t0.sub_region_id AS sub_region_id_17, t0.color_id AS color_id_18, t0.type_id AS type_id_19, t0.sub_type_id AS sub_type_id_20, t0.entity_id AS entity_id_21, t0.classification_id AS classification_id_22, t0.line_id AS line_id_23, t0.producer_id AS producer_id_24 FROM product t0 WHERE t0.id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.display_name AS display_name_2,
  t0.lwin AS lwin_3,
  t0.site AS site_4,
  t0.seller_price_qty AS seller_price_qty_5,
  t0.price AS price_6,
  t0.merged_uuids AS merged_uuids_7,
  t0.has_lwin_suggests AS has_lwin_suggests_8,
  t0.from_import AS from_import_9,
  t0.bundle AS bundle_10,
  t0.id AS id_11,
  t0.uuid AS uuid_12,
  t0.name AS name_13,
  t0.status AS status_14,
  t0.country_id AS country_id_15,
  t0.region_id AS region_id_16,
  t0.sub_region_id AS sub_region_id_17,
  t0.color_id AS color_id_18,
  t0.type_id AS type_id_19,
  t0.sub_type_id AS sub_type_id_20,
  t0.entity_id AS entity_id_21,
  t0.classification_id AS classification_id_22,
  t0.line_id AS line_id_23,
  t0.producer_id AS producer_id_24
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.display_name AS display_name_2, t0.lwin AS lwin_3, t0.site AS site_4, t0.seller_price_qty AS seller_price_qty_5, t0.price AS price_6, t0.merged_uuids AS merged_uuids_7, t0.has_lwin_suggests AS has_lwin_suggests_8, t0.from_import AS from_import_9, t0.bundle AS bundle_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.name AS name_13, t0.status AS status_14, t0.country_id AS country_id_15, t0.region_id AS region_id_16, t0.sub_region_id AS sub_region_id_17, t0.color_id AS color_id_18, t0.type_id AS type_id_19, t0.sub_type_id AS sub_type_id_20, t0.entity_id AS entity_id_21, t0.classification_id AS classification_id_22, t0.line_id AS line_id_23, t0.producer_id AS producer_id_24 FROM product t0 WHERE t0.id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 53)
5	Symfony\UX\LiveComponent\Hydration\DoctrineEntityHydrationExtension->hydrate (line 578)
6	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrateObjectValue (line 320)
7	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrateValue (line 168)
8	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrate (line 358)
9	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->hydrateComponent (line 175)
10	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelController (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.46 ms
(1.81%)

UPDATE user SET last_activity = ? WHERE id = ?

Parameters:

[
  "2025-07-07 09:34:16"
  16
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 09:34:16' WHERE id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 49)
7	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.20 ms
(0.77%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 49)
4	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Company	1
App\Entity\Product\Product	1
App\Entity\Country	1
App\Entity\Region	1
App\Entity\Product\Color	1
App\Entity\Product\Type	1
App\Entity\Property\Property	1
App\Entity\Product\Classification	1
App\Entity\Product\Line	1
App\Entity\Property\Producer	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Product\Offer	No errors.
App\Entity\Product\FavouriteOffer	No errors.
App\Entity\Offer\OfferProposal	No errors.
App\Entity\Offer\OfferUserConsult	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Country	No errors.
App\Entity\Region	No errors.
App\Entity\SubRegion	No errors.
App\Entity\Product\Color	No errors.
App\Entity\Product\Type	No errors.
App\Entity\Product\SubType	No errors.
App\Entity\Property\Property	No errors.
App\Entity\Product\Classification	No errors.
App\Entity\Product\Line	No errors.
App\Entity\Property\Producer	No errors.
App\Entity\Product\VintageSettings	No errors.
App\Entity\Product\Vintage	No errors.
App\Entity\Product\Appellation	No errors.
App\Entity\Product\Dictionary	No errors.
App\Entity\Product\Acronym	No errors.
App\Entity\Product\Format	No errors.
App\Entity\Product\Packaging	No errors.
App\Entity\Product\OfferHistory	No errors.

Symfony Profiler

POST https://app103.fr/_components/offer_table/columnSort

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping