Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

16.05 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.58 ms
(34.77%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.level AS level_3,
  c0_.pic_ext AS pic_ext_4,
  c0_.features AS features_5,
  c0_.raychat_code AS raychat_code_6,
  c0_.visible AS visible_7,
  c0_.updated_at AS updated_at_8,
  c1_.id AS id_9,
  c1_.name AS name_10,
  c1_.code AS code_11,
  c1_.level AS level_12,
  c1_.pic_ext AS pic_ext_13,
  c1_.features AS features_14,
  c1_.raychat_code AS raychat_code_15,
  c1_.visible AS visible_16,
  c1_.updated_at AS updated_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.code AS code_20,
  c2_.level AS level_21,
  c2_.pic_ext AS pic_ext_22,
  c2_.features AS features_23,
  c2_.raychat_code AS raychat_code_24,
  c2_.visible AS visible_25,
  c2_.updated_at AS updated_at_26,
  c0_.parent_id AS parent_id_27,
  c1_.parent_id AS parent_id_28,
  c2_.parent_id AS parent_id_29
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = 1;

#	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 70)
7	App\Controller\KalaController->menu (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 302)
15	__TwigTemplate_e5ebcb053544d5241e4b72d76f070b27->doDisplay (line 387)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_6dad50862a5c760d59834ad376658d4a->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
26	App\Controller\KalaController->search (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

4.01 ms
(25.00%)

SELECT DISTINCT i0_.id AS id_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = ?) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> ? AND i0_.status <> ?) AND c8_.visible = ? AND (c8_.id = ? OR c7_.id = ? OR c6_.id = ? OR c4_.id = ?) AND (i0_.name_brand_fa LIKE ? OR i0_.producer LIKE ?) LIMIT 20

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.id AS id_0
FROM
  item i0_
  INNER JOIN item_category i2_ ON i0_.id = i2_.item_id
  INNER JOIN category c1_ ON c1_.id = i2_.category_id
  LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id
  AND (i3_.type = ?)
  INNER JOIN item_category i5_ ON i0_.id = i5_.item_id
  INNER JOIN category c4_ ON c4_.id = i5_.category_id
  INNER JOIN category c6_ ON c4_.parent_id = c6_.id
  INNER JOIN category c7_ ON c6_.parent_id = c7_.id
  INNER JOIN category c8_ ON c7_.parent_id = c8_.id
WHERE
  (
    i0_.status <> ?
    AND i0_.status <> ?
  )
  AND c8_.visible = ?
  AND (
    c8_.id = ?
    OR c7_.id = ?
    OR c6_.id = ?
    OR c4_.id = ?
  )
  AND (
    i0_.name_brand_fa LIKE ?
    OR i0_.producer LIKE ?
  )
LIMIT
  20

SELECT DISTINCT i0_.id AS id_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 7708 OR c7_.id = 7708 OR c6_.id = 7708 OR c4_.id = 7708) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%') LIMIT 20;

#	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	ContainerVDkvJCF\PaginatorProxyBa079e5->paginate (line 161)
16	App\Controller\KalaController->search (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

4.00 ms
(24.93%)

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = ?) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> ? AND i0_.status <> ?) AND c8_.visible = ? AND (c8_.id = ? OR c7_.id = ? OR c6_.id = ? OR c4_.id = ?) AND (i0_.name_brand_fa LIKE ? OR i0_.producer LIKE ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  item i0_
  INNER JOIN item_category i2_ ON i0_.id = i2_.item_id
  INNER JOIN category c1_ ON c1_.id = i2_.category_id
  LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id
  AND (i3_.type = ?)
  INNER JOIN item_category i5_ ON i0_.id = i5_.item_id
  INNER JOIN category c4_ ON c4_.id = i5_.category_id
  INNER JOIN category c6_ ON c4_.parent_id = c6_.id
  INNER JOIN category c7_ ON c6_.parent_id = c7_.id
  INNER JOIN category c8_ ON c7_.parent_id = c8_.id
WHERE
  (
    i0_.status <> ?
    AND i0_.status <> ?
  )
  AND c8_.visible = ?
  AND (
    c8_.id = ?
    OR c7_.id = ?
    OR c6_.id = ?
    OR c4_.id = ?
  )
  AND (
    i0_.name_brand_fa LIKE ?
    OR i0_.producer LIKE ?
  )

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 7708 OR c7_.id = 7708 OR c6_.id = 7708 OR c4_.id = 7708) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%');

#	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	ContainerVDkvJCF\PaginatorProxyBa079e5->paginate (line 161)
16	App\Controller\KalaController->search (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.97 ms
(12.29%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 0 ORDER BY t0.order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	App\Controller\KalaController->menu (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 302)
12	__TwigTemplate_e5ebcb053544d5241e4b72d76f070b27->doDisplay (line 387)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_6dad50862a5c760d59834ad376658d4a->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
23	App\Controller\KalaController->search (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.48 ms
(3.00%)

SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.about_us AS about_us_2,
  t0.contact_us AS contact_us_3,
  t0.introduce AS introduce_4,
  t0.privacy_policy_ext AS privacy_policy_ext_5,
  t0.terms_and_conditions_ext AS terms_and_conditions_ext_6,
  t0.website_title AS website_title_7,
  t0.meta_description AS meta_description_8,
  t0.footer_description AS footer_description_9,
  t0.logo_ext AS logo_ext_10,
  t0.fav_icon_ext AS fav_icon_ext_11,
  t0.top_banner_ext AS top_banner_ext_12,
  t0.top_banner_link AS top_banner_link_13,
  t0.updated_at AS updated_at_14,
  t0.footer_column1_title AS footer_column1_title_15,
  t0.footer_column2_title AS footer_column2_title_16,
  t0.footer_column3_title AS footer_column3_title_17,
  t0.footer_column4_title AS footer_column4_title_18,
  t0.buy_without_login AS buy_without_login_19,
  t0.footer_social_instagram AS footer_social_instagram_20,
  t0.footer_social_whatsapp AS footer_social_whatsapp_21,
  t0.footer_social_telegram AS footer_social_telegram_22,
  t0.footer_social_twitter AS footer_social_twitter_23,
  t0.footer_script AS footer_script_24
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 32)
4	App\Services\Setting->getEntity (line 166)
5	App\Controller\KalaController->search (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Item	No errors.
App\Entity\Category	No errors.
App\Entity\ItemMedia	No errors.
App\Entity\Setting	No errors.
FOS\UserBundle\Model\User	No errors.
App\Entity\User	No errors.
App\Entity\Menu	The association App\Entity\Menu#category refers to the inverse side field App\Entity\Category#menus which does not exist.
App\Entity\Page	No errors.
App\Entity\LicenseOwner	No errors.
App\Entity\ShopSpecial	No errors.
App\Entity\ItemBarcode	No errors.
App\Entity\ItemIRC	No errors.
App\Entity\ItemPriceHistory	No errors.
App\Entity\ItemDrugstore	No errors.
App\Entity\ItemUser	No errors.
App\Entity\CartItem	No errors.
App\Entity\SMS	No errors.
App\Entity\Address	No errors.
App\Entity\Cart	The mappings App\Entity\Cart#addressCity and App\Entity\City#addresses are inconsistent with each other.
App\Entity\MobileVerifyCode	No errors.
App\Entity\City	The mappings App\Entity\City#carts and App\Entity\Cart#addressCity are inconsistent with each other.
App\Entity\DrugstoreType	No errors.
App\Entity\PushNotification	No errors.
App\Entity\Ticket	No errors.
App\Entity\Log	No errors.
App\Entity\Payment	No errors.
App\Entity\BankAccount	No errors.
App\Entity\Receipt	No errors.
App\Entity\Transaction	No errors.
App\Entity\SupplyDrugstore	No errors.
App\Entity\ItemDrugstorePriceHistory	No errors.
App\Entity\DeliverType	No errors.
App\Entity\Province	No errors.
App\Entity\DrugstoreData	No errors.
App\Entity\Template	No errors.
App\Entity\TicketType	No errors.
App\Entity\Article	No errors.
App\Entity\SettingApp	No errors.
App\Entity\Brand	No errors.
App\Entity\Advertise	No errors.
App\Entity\Vitrin	No errors.
App\Entity\Contact	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://daroox.com/search?categoryId=7708&url=search

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping