Language
Belarus
Currency
USD - долар ЗША
- Home
- Other
Info 
Design 
Profile 
Queries 
Logs 
Actions | Base Url | https://m249.1001001010.com/ |
|---|---|
| Path Info | /catalog/category/view/id/53 |
| Module Name | catalog |
| Controller | category |
| Action | view |
| Full Action | catalog_category_view |
| Route | catalog |
| Area | frontend |
| Params | Array ( [color] => 95 [erin_recommends] => 0 [performance_fabric] => 1 [premium] => 0 [id] => 53 ) |
| Client IP | 216.73.216.105 |
| Magento | 2.4.8 |
| Mage Mode | developer |
| Backend | https://m249.1001001010.com/adminin |
| Website Id | 1 |
|---|---|
| Website Name | Main Website |
| Store Id | 2 |
| Store Name | Belarus |
| Store Code | belarus |
Please wait.
Content is loading ...
Environment
| Variable | Value |
|---|---|
| USER | www-data |
| HOME | /var/www |
PHP Variables
| Variable | Value |
|---|---|
| $_COOKIE['PHPSESSID'] | 265d3641337e29745fa45941062355c1 |
| $_SERVER['USER'] | www-data |
| $_SERVER['HOME'] | /var/www |
| $_SERVER['HTTP_COOKIE'] | PHPSESSID=265d3641337e29745fa45941062355c1 |
| $_SERVER['HTTP_ACCEPT_ENCODING'] | gzip, br, zstd, deflate |
| $_SERVER['HTTP_USER_AGENT'] | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| $_SERVER['HTTP_ACCEPT'] | */* |
| $_SERVER['HTTP_HOST'] | m249.1001001010.com |
| $_SERVER['REDIRECT_STATUS'] | 200 |
| $_SERVER['SERVER_NAME'] | m249.1001001010.com |
| $_SERVER['SERVER_PORT'] | 443 |
| $_SERVER['SERVER_ADDR'] | 172.104.246.77 |
| $_SERVER['REMOTE_USER'] | no value |
| $_SERVER['REMOTE_PORT'] | 35884 |
| $_SERVER['REMOTE_ADDR'] | 216.73.216.105 |
| $_SERVER['SERVER_SOFTWARE'] | nginx/1.24.0 |
| $_SERVER['GATEWAY_INTERFACE'] | CGI/1.1 |
| $_SERVER['HTTPS'] | on |
| $_SERVER['REQUEST_SCHEME'] | https |
| $_SERVER['SERVER_PROTOCOL'] | HTTP/2.0 |
| $_SERVER['DOCUMENT_ROOT'] | /var/www/m249/pub |
| $_SERVER['DOCUMENT_URI'] | /index.php |
| $_SERVER['REQUEST_URI'] | /belarus/other/l/color:black/erin-recommends:no/performance-fabric:yes/premium:no.html |
| $_SERVER['SCRIPT_NAME'] | /index.php |
| $_SERVER['CONTENT_LENGTH'] | no value |
| $_SERVER['CONTENT_TYPE'] | no value |
| $_SERVER['REQUEST_METHOD'] | GET |
| $_SERVER['QUERY_STRING'] | no value |
| $_SERVER['SCRIPT_FILENAME'] | /var/www/m249/pub/index.php |
| $_SERVER['PHP_VALUE'] | memory_limit=2056M max_execution_time=60 |
| $_SERVER['PHP_FLAG'] | session.auto_start=off suhosin.session.cryptua=off |
| $_SERVER['FCGI_ROLE'] | RESPONDER |
| $_SERVER['PHP_SELF'] | /index.php |
| $_SERVER['REQUEST_TIME_FLOAT'] | 1772331667.3801 |
| $_SERVER['REQUEST_TIME'] | 1772331667 |
Please wait.
Content is loading ...
| Handles | default catalog_category_view catalog_category_view_type_layered catalog_category_view_displaymode_ catalog_category_view_id_53 |
|---|
| Blocks hierarchy |
|
|---|
| Block | Call Number |
|---|---|
| Magento\Directory\Block\Currency\Interceptor | 2 |
| Magento\Framework\View\Element\Template\Interceptor | 20 |
| Magento\Framework\View\Element\Js\Components\Interceptor | 9 |
| Magento\RequireJs\Block\Html\Head\Config\Interceptor | 1 |
| Magento\Framework\View\Element\Js\Cookie\Interceptor | 2 |
| Magento\Theme\Block\Html\Notices\Interceptor | 1 |
| Magento\Customer\Block\Account\Navigation\Interceptor | 1 |
| Magento\Theme\Block\Html\Header\Interceptor | 1 |
| Magento\Store\Block\Switcher\Interceptor | 3 |
| Magento\Theme\Block\Html\Header\Logo\Interceptor | 1 |
| Magento\Theme\Block\Html\Topmenu\Interceptor | 1 |
| Magento\Framework\View\Element\Text\Interceptor | 1 |
| Magento\Theme\Block\Html\Breadcrumbs\Interceptor | 1 |
| MageWorx\CustomerPrices\Block\Theme\Html\Title\Interceptor | 1 |
| Magento\Framework\View\Element\Messages\Interceptor | 1 |
| Magento\Framework\View\Element\Html\Links\Interceptor | 2 |
| Magento\Theme\Block\Html\Footer\Interceptor | 2 |
| Magento\Framework\View\Element\FormKey\Interceptor | 1 |
| Magento\Customer\Block\Account\Link\Interceptor | 1 |
| Magento\Customer\Block\Account\RegisterLink\Interceptor | 1 |
| Magento\Customer\Block\Account\AuthorizationLink\Interceptor | 3 |
| Magento\Customer\Block\Account\AuthenticationPopup\Interceptor | 1 |
| Magento\Customer\Block\SectionConfig\Interceptor | 1 |
| Magento\Customer\Block\CustomerData\Interceptor | 1 |
| Magento\Customer\Block\CustomerScopeData\Interceptor | 1 |
| Magento\Framework\View\Element\Html\Link\Current\Interceptor | 6 |
| Magento\Framework\Pricing\Render\RendererPool\Interceptor | 1 |
| Magento\Framework\Pricing\Render\Interceptor | 1 |
| Magento\Catalog\Block\FrontendStorageManager\Interceptor | 1 |
| Magento\Sales\Block\Reorder\Sidebar\Interceptor | 1 |
| Magento\Sales\Block\Guest\Link\Interceptor | 1 |
| Magento\Checkout\Block\Cart\Sidebar\Interceptor | 1 |
| Magento\Checkout\Block\Item\Price\Renderer\Interceptor | 1 |
| Magento\Cookie\Block\Html\Notices\Interceptor | 1 |
| Magento\Newsletter\Block\Subscribe\Interceptor | 1 |
| Magento\GoogleAnalytics\Block\Ga\Interceptor | 1 |
| Magento\Ui\Block\Logger\Interceptor | 1 |
| Magento\Ui\Block\Wysiwyg\ActiveEditor\Interceptor | 1 |
| Magento\PageCache\Block\Javascript\Interceptor | 1 |
| Magento\PageBuilder\Block\GoogleMapsApi\Interceptor | 1 |
| Magento\PageBuilder\Block\WidgetInitializer\Interceptor | 1 |
| Magento\Paypal\Block\Express\InContext\Component\Interceptor | 1 |
| Magento\Rss\Block\Feeds\Interceptor | 1 |
| Magento\Translation\Block\Html\Head\Config\Interceptor | 1 |
| Magento\Wishlist\Block\Link\Interceptor | 1 |
| Magento\Wishlist\Block\Customer\Sidebar\Interceptor | 1 |
| ADM\QuickDevBar\Block\Toolbar\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Wrapper\Interceptor | 5 |
| ADM\QuickDevBar\Block\Tab\Content\Request\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Config\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\PhpInfo\Interceptor | 2 |
| ADM\QuickDevBar\Block\Tab\Content\Layout\Interceptor | 2 |
| ADM\QuickDevBar\Block\Tab\Content\Block\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Panel\Interceptor | 3 |
| ADM\QuickDevBar\Block\Tab\Content\Observer\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Event\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Collection\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Model\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Plugin\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Sql\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Log\Interceptor | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Translation\Interceptor | 4 |
| ADM\QuickDevBar\Block\Tab\Content\Help\Interceptor | 1 |
| Ho\Templatehints\Block\Hints\Init\Interceptor | 1 |
| MageWorx\GiftCards\Block\Link\Interceptor | 1 |
| MageWorx\StoreLocator\Block\Header\Link\Interceptor | 2 |
| MageWorx\ShippingRules\Block\Zone\Selector\Interceptor | 1 |
| MageWorx\SocialProofBase\Block\Campaign\Popup\Interceptor | 1 |
| Magento\Customer\Block\Account\Customer\Interceptor | 1 |
| Magento\Cms\Block\Widget\Block\Interceptor | 1 |
| Magento\Catalog\Block\Category\View\Interceptor | 4 |
| Magento\Catalog\Block\Product\ListProduct\Interceptor | 1 |
| Magento\Framework\View\Element\RendererList\Interceptor | 1 |
| Magento\Catalog\Block\Product\ProductList\Item\Container\Interceptor | 1 |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare\Interceptor | 1 |
| Magento\Catalog\Block\Product\ProductList\Toolbar\Interceptor | 1 |
| Magento\Theme\Block\Html\Pager\Interceptor | 1 |
| Magento\Cookie\Block\RequireCookie\Interceptor | 1 |
| Magento\Catalog\Block\Category\Rss\Link\Interceptor | 1 |
| Magento\Msrp\Block\Popup\Interceptor | 1 |
| Magento\Catalog\Block\ShortcutButtons\Interceptor | 1 |
| Magento\Paypal\Block\Logo\Interceptor | 1 |
| Magento\Paypal\Block\Bml\Banners\Interceptor | 2 |
| Magento\Paypal\Block\PayLater\Banner\Interceptor | 2 |
| Magento\Swatches\Block\Product\Renderer\Listing\Configurable\Interceptor | 1 |
| Magento\GoogleOptimizer\Block\Code\Category\Interceptor | 1 |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor | 1 |
| Magento\Wishlist\Block\AddToWishlist\Interceptor | 1 |
| MageWorx\Faq\Block\Faq\Interceptor | 1 |
| MageWorx\ReviewReminderBase\Block\Reminder\Popup\Interceptor | 1 |
| MageWorx\RewardPoints\Block\ProductList\RewardPromise\Interceptor | 1 |
| MageWorx\SeoMarkup\Block\Head\SocialMarkup\Category\Interceptor | 1 |
| MageWorx\SeoMarkup\Block\Head\Json\Website\Interceptor | 1 |
| MageWorx\SeoMarkup\Block\Head\Json\Seller\Interceptor | 1 |
| MageWorx\SeoMarkup\Block\Head\Json\Breadcrumbs\Catalog\Interceptor | 1 |
| Magento\LayeredNavigation\Block\Navigation\Interceptor | 1 |
| Magento\LayeredNavigation\Block\Navigation\State\Interceptor | 1 |
| Magento\LayeredNavigation\Block\Navigation\FilterRenderer\Interceptor | 1 |
Cannot find profiler table or profiler is not enabled.
You have to add a SetEnv MAGE_PROFILER "html" to your .htaccess (do not use "csvfile" nor "firebug" to have profiler displayed in tab).
Be careful with .htacces directives an redirection you can have
You can read the official documentation Enable profiling (MAGE_PROFILER)
You have to add a SetEnv MAGE_PROFILER "html" to your .htaccess (do not use "csvfile" nor "firebug" to have profiler displayed in tab).
Be careful with .htacces directives an redirection you can have
$_SERVER['REDIRECT_MAGE_PROFILER']setted instead of
$_SERVER['MAGE_PROFILER']prefer apache2.conf.
You can read the official documentation Enable profiling (MAGE_PROFILER)
List only observer that intercept dispatched events when Magento generate this page
| Event | Name | Call Number | Instance |
|---|---|---|---|
| core_collection_abstract_load_after | mageworx_xreviewbase_add_media_to_review_collection | 46 | MageWorx\XReviewBase\Observer\AddMediaToReviewCollectionObserver |
| core_collection_abstract_load_after | mageworx_xreviewbase_add_location_text_to_review_collection | 46 | MageWorx\XReviewBase\Observer\AddLocationTextToReviewCollectionObserver |
| core_collection_abstract_load_after | mageworx_xreviewbase_find_statistics_review_collection | 46 | MageWorx\XReviewBase\Observer\FindStatisticsByReviewCollectionObserver |
| controller_action_predispatch | customer_visitor | 2 | Magento\Customer\Observer\Visitor\InitByRequestObserver |
| controller_action_predispatch | newrelicreporting_observer_report_concurrent_users | 2 | Magento\NewRelicReporting\Model\Observer\ReportConcurrentUsers |
| controller_action_predispatch | newrelicreporting_newrelic_report_concurrent_users | 2 | Magento\NewRelicReporting\Model\Observer\ReportConcurrentUsersToNewRelic |
| controller_action_predispatch | persistent_synchronize | 2 | Magento\Persistent\Observer\SynchronizePersistentInfoObserver |
| controller_action_predispatch | persistent_session | 2 | Magento\Persistent\Observer\RenewCookieObserver |
| controller_action_predispatch | persistent_quote | 2 | Magento\Persistent\Observer\CheckExpirePersistentQuoteObserver |
| controller_action_predispatch | persistent_customer | 2 | Magento\Persistent\Observer\EmulateCustomerObserver |
| controller_action_postdispatch | customer_visitor | 2 | Magento\Customer\Observer\Visitor\SaveByRequestObserver |
| magento_catalog_api_data_categoryinterface_load_after | legacy_category_load_after | 2 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_category_load_after | mw_seocrosslinks_crosslinks_category | 2 | MageWorx\SeoCrossLinks\Model\Observer\AddCrosslinksToCategoryObserver |
| catalog_category_load_after | mw_seoxtemplates_seo_category_name | 2 | MageWorx\SeoXTemplates\Model\Observer\CategoryNameToSeoName |
| eav_collection_abstract_load_before | mageworx_xreviewbase_extend_product_review_collection | 12 | MageWorx\XReviewBase\Observer\AddFieldsToProductReviewCollectionObserver |
| layout_load_before | persistent_add_remember_me_init | 1 | Magento\Persistent\Observer\AddPersistentRememberMeInitObserver |
| layout_generate_blocks_after | mageworx_remove_ln_block | 1 | MageWorx\LandingPagesPro\Observer\RemoveLnBlock |
| layout_generate_blocks_after | mageworx_landingpage_add_canonical | 1 | MageWorx\LandingPagesPro\Observer\AddCanonical |
| layout_generate_blocks_after | mageworx_landingpage_add_robots | 1 | MageWorx\LandingPagesPro\Observer\AddRobots |
| layout_generate_blocks_after | mageworx_location_add_canonical | 1 | MageWorx\LocationPages\Observer\AddCanonical |
| layout_generate_blocks_after | mageworx_location_add_robots | 1 | MageWorx\LocationPages\Observer\AddRobots |
| layout_generate_blocks_after | persistent | 1 | Magento\Persistent\Observer\ApplyPersistentDataObserver |
| layout_generate_blocks_after | persistent_add_remember_me_init | 1 | Magento\Persistent\Observer\AddPersistentRememberMeInitObserver |
| layout_generate_blocks_after | mw_seoall_layout_generate_blocks_after_splitter | 1 | MageWorx\SeoAll\Observer\LayoutGenerateBlocksAfterSplitter |
| layout_generate_blocks_after_one | mw_seoextended_replace_meta_by_category_filter | 1 | MageWorx\SeoExtended\Observer\ModifyCategoryByFilterMetaObserver |
| layout_generate_blocks_after_one | mw_seoextended_replace_category_description | 1 | MageWorx\SeoExtended\Observer\ReplaceCategoryDescriptionObserver |
| layout_generate_blocks_after_one | mw_seoextended_replace_category_seo_name | 1 | MageWorx\SeoExtended\Observer\ReplaceTitleForCategoryPageObserver |
| layout_generate_blocks_after_two | mw_seoxtemplates_seo_category_name | 1 | MageWorx\SeoXTemplates\Model\Observer\CategoryNameModifier |
| layout_generate_blocks_after_two | mw_seoxtemplates_category_data_modifier | 1 | MageWorx\SeoXTemplates\Model\Observer\CategoryDataModifier |
| layout_generate_blocks_after_two | mw_seoxtemplates_landingpage_data_modifier | 1 | MageWorx\SeoXTemplates\Model\Observer\LandingPageDataModifier |
| layout_generate_blocks_after_two | mw_seoxtemplates_brand_data_modifier | 1 | MageWorx\SeoXTemplates\Model\Observer\BrandDataModifier |
| layout_generate_blocks_after_three | mw_seoextended_replace_meta_by_settings | 1 | MageWorx\SeoExtended\Observer\ModifyMetaObserver |
| layout_generate_blocks_after | mageworx_xreviewbase_remove_review_list_block | 1 | MageWorx\XReviewBase\Observer\RemoveReviewListBlockFromFWPageObserver |
| layout_generate_blocks_after | mageworx_rewardpoints_customer_account | 1 | MageWorx\RewardPoints\Observer\Display\AddBlockToCustomerAccountObserver |
| layout_generate_blocks_after | mw_seobase_observer_robots | 1 | MageWorx\SeoBase\Model\Observer\Robots |
| layout_generate_blocks_after | mw_seobase_observer_canonical | 1 | MageWorx\SeoBase\Model\Observer\Canonical |
| layout_generate_blocks_after | mw_seobase_observer_hreflangs | 1 | MageWorx\SeoBase\Model\Observer\Hreflangs |
| view_block_abstract_to_html_before | mageworx_seomarkup_remove_open_graph | 138 | MageWorx\SeoMarkup\Observer\RemoveOpenGraphBlockObserver |
| view_block_abstract_to_html_after | mageworx_seomarkup_remove_offer_markup | 134 | MageWorx\SeoMarkup\Observer\RemoveProductOfferMarkupObserver |
| core_layout_render_element | pagecache | 135 | Magento\PageCache\Observer\ProcessLayoutRenderElement |
| catalog_block_product_list_collection | review | 1 | Magento\Review\Observer\CatalogProductListCollectionAppendSummaryFieldsObserver |
| catalog_product_collection_load_after | mageworx_group_prices_to_collection | 6 | MageWorx\CustomerGroupPrices\Observer\ApplyGroupPricesToCollection |
| mageworx_customergroupprices_exclude_product_ids | mageworx_customerprices_exclude_product_ids | 3 | MageWorx\CustomerPrices\Observer\ProductIds |
| catalog_product_collection_load_after | mageworx_add_customer_prices_to_collection | 6 | MageWorx\CustomerPrices\Observer\ApplyCustomerPricesToCollectionObserver |
| currency_display_options_forming | magento_currencysymbol_currency_display_options | 4 | Magento\CurrencySymbol\Observer\CurrencyDisplayOptions |
| shortcut_buttons_container | paypal_shortcuts | 1 | Magento\Paypal\Observer\AddPaypalShortcutsObserver |
| shortcut_buttons_container | magpaypayments_add_smart_buttons | 1 | Magento\PaymentServicesPaypal\Observer\AddCheckoutComponents |
| shortcut_buttons_container | braintree_paypal_shortcuts | 1 | PayPal\Braintree\Observer\AddPaypalShortcuts |
| shortcut_buttons_container | braintree_applepay_shortcuts | 1 | PayPal\Braintree\Observer\AddApplePayShortcuts |
| shortcut_buttons_container | braintree_googlepay_shortcuts | 1 | PayPal\Braintree\Observer\AddGooglePayShortcuts |
| magento_cms_api_data_blockinterface_load_after | legacy_model_cms_block_after_load | 1 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
List only events dispatched when Magento generate this page
| Event | Data | Call Number |
|---|---|---|
| customer_session_init |
| 62 |
| model_load_before |
| 3 |
| core_abstract_load_before |
| 2 |
| model_load_after |
| 48 |
| core_abstract_load_after |
| 3 |
| core_collection_abstract_load_before |
| 46 |
| core_collection_abstract_load_after |
| 46 |
| controller_action_predispatch |
| 2 |
| controller_action_predispatch_ |
| 1 |
| controller_action_predispatch___ |
| 1 |
| controller_action_postdispatch___ |
| 1 |
| controller_action_postdispatch_ |
| 1 |
| controller_action_postdispatch |
| 2 |
| controller_action_predispatch_catalog |
| 1 |
| controller_action_predispatch_catalog_category_view |
| 1 |
| entity_manager_load_before |
| 3 |
| magento_catalog_api_data_categoryinterface_load_before |
| 2 |
| magento_catalog_api_data_categoryinterface_load_after |
| 2 |
| catalog_category_load_after |
| 2 |
| entity_manager_load_after |
| 3 |
| catalog_controller_category_init_after |
| 1 |
| eav_collection_abstract_load_before |
| 12 |
| catalog_category_collection_load_before |
| 6 |
| catalog_category_collection_load_after |
| 6 |
| layout_load_before |
| 1 |
| layout_generate_blocks_before |
| 1 |
| core_layout_block_create_after |
| 155 |
| catalog_entity_attribute_load_after |
| 41 |
| layout_generate_blocks_after |
| 1 |
| layout_generate_blocks_after_one |
| 1 |
| layout_generate_blocks_after_two |
| 1 |
| layout_generate_blocks_after_three |
| 1 |
| controller_action_postdispatch_catalog_category_view |
| 1 |
| controller_action_postdispatch_catalog |
| 1 |
| layout_render_before | 1 | |
| layout_render_before_catalog_category_view | 1 | |
| view_block_abstract_to_html_before |
| 139 |
| view_block_abstract_to_html_after |
| 135 |
| core_layout_render_element |
| 135 |
| store_collection_load_before |
| 2 |
| store_collection_load_after |
| 2 |
| catalog_category_collection_add_is_active_filter |
| 1 |
| page_block_html_topmenu_gethtml_before |
| 1 |
| page_block_html_topmenu_gethtml_after |
| 1 |
| catalog_block_product_list_collection |
| 1 |
| inventory_stock_load_before |
| 1 |
| inventory_stock_load_after |
| 1 |
| catalog_product_collection_load_after |
| 6 |
| mageworx_customergroupprices_exclude_product_ids |
| 3 |
| currency_display_options_forming |
| 4 |
| catalog_product_is_salable_before |
| 4 |
| catalog_product_is_salable_after |
| 4 |
| shortcut_buttons_container |
| 1 |
| magento_cms_api_data_blockinterface_load_before |
| 1 |
| magento_cms_api_data_blockinterface_load_after |
| 1 |
| cms_block_load_after |
| 1 |
| Collection | Call Number |
|---|---|
| Magento\Catalog\Model\ResourceModel\Product\Attribute\Collection\Interceptor | 2 |
| Magento\Eav\Model\ResourceModel\Entity\Attribute\Option\Collection\Interceptor | 36 |
| MageWorx\SeoBase\Model\ResourceModel\CustomCanonical\Collection\Interceptor | 1 |
| Magento\Store\Model\ResourceModel\Store\Collection\Interceptor | 2 |
| Magento\Store\Model\ResourceModel\Group\Collection\Interceptor | 3 |
| Magento\CheckoutAgreements\Model\ResourceModel\Agreement\Collection\Interceptor | 1 |
| Magento\Bundle\Model\ResourceModel\Option\Collection\Interceptor | 1 |
| Event | Call Number |
|---|---|
| Magento\Framework\Flag | 1 |
| Magento\Inventory\Model\Stock | 1 |
| Magento\Eav\Model\Entity\Type | 1 |
| Types | Plugin | Sort Order | Method |
|---|---|---|---|
| Magento\Framework\App\Config | MageWorx\ShippingRules\Model\Plugin\AddMethods | 10 | aroundGetValue |
| Magento\Framework\Url\ScopeInterface | Magento\Theme\Model\Url\Plugin\Signature | 0 | afterGetBaseUrl |
| Magento\Store\Model\Store | Magento\Theme\Model\Url\Plugin\Signature | 0 | afterGetBaseUrl |
| Magento\Store\Model\Store | Magento\Theme\Model\Indexer\Design\Config\Plugin\Store | 0 | afterSave |
| Magento\Store\Model\Store | Magento\Theme\Model\Indexer\Design\Config\Plugin\Store | 0 | afterDelete |
| Magento\Store\Model\Store | Magento\StoreGraphQl\Plugin\Store | 0 | afterGetIdentities |
| Magento\Framework\Session\SessionManagerInterface | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\SessionManagerInterface | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Framework\Session\SessionManager | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\SessionManager | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Framework\Session\Generic | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\Generic | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Framework\Session\SessionStartChecker | Magento\Paypal\Plugin\TransparentSessionChecker | 0 | afterCheck |
| Magento\Framework\App\State | Magento\NewRelicReporting\Plugin\StatePlugin | 0 | afterSetAreaCode |
| Magento\Framework\App\FrontControllerInterface | Magento\PageCache\Model\App\FrontController\BuiltinPlugin | 0 | aroundDispatch |
| Magento\Framework\App\FrontControllerInterface | Magento\PageCache\Model\App\FrontController\VarnishPlugin | 0 | afterDispatch |
| Magento\Framework\App\FrontControllerInterface | Magento\PageCache\Plugin\RegisterFormKeyFromCookie | 0 | beforeDispatch |
| Magento\Framework\App\FrontControllerInterface | Magento\Deploy\Model\Plugin\ConfigChangeDetector | 50 | beforeDispatch |
| Magento\Framework\App\FrontController | Magento\PageCache\Model\App\FrontController\BuiltinPlugin | 0 | aroundDispatch |
| Magento\Framework\App\FrontController | Magento\PageCache\Model\App\FrontController\VarnishPlugin | 0 | afterDispatch |
| Magento\Framework\App\FrontController | Magento\PageCache\Plugin\RegisterFormKeyFromCookie | 0 | beforeDispatch |
| Magento\Framework\App\FrontController | Magento\Store\Model\Plugin\StoreCookie | 10 | beforeDispatch |
| Magento\Framework\App\FrontController | Magento\Framework\Module\Plugin\DbStatusValidator | 40 | beforeDispatch |
| Magento\Framework\App\FrontController | Magento\Deploy\Model\Plugin\ConfigChangeDetector | 50 | beforeDispatch |
| Magento\Framework\App\FrontController | Magento\Store\App\FrontController\Plugin\RequestPreprocessor | 50 | aroundDispatch |
| Magento\PageCache\Model\Config | Magento\LoginAsCustomerPageCache\Plugin\PageCache\Model\Config\DisablePageCacheIfNeededPlugin | 0 | afterIsEnabled |
| Magento\Eav\Model\Entity\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Eav\Model\Entity\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Eav\Model\Entity\VersionControl\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Eav\Model\Entity\VersionControl\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Checkout\Model\Plugin\RecollectQuoteOnCustomerGroupChange | 0 | aroundSave |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Quote\Plugin\RecollectOnGroupChange | 0 | afterSave |
| Magento\Framework\App\Config\Value | Magento\MediaGalleryRenditions\Plugin\UpdateRenditionsOnConfigChange | 0 | afterSave |
| Magento\Framework\App\Config\Value | Magento\MediaGallerySynchronization\Plugin\MediaGallerySyncTrigger | 0 | afterSave |
| Magento\Framework\App\Config\Value | Magento\ServicesId\Plugin\ProjectIdOnConfigImport | 0 | aroundSave |
| Magento\Framework\App\Config\Value | Magento\ServicesId\Plugin\SetCloudIdOnConfigImport | 0 | afterAfterSave |
| Magento\Framework\App\Config\Value | Magento\WebapiSecurity\Model\Plugin\CacheInvalidator | 0 | afterAfterSave |
| Magento\Framework\App\Config\Value | Magento\ServicesId\Plugin\EnvironmentIdOnConfigImport | 0 | aroundSave |
| Magento\Customer\Model\Config\Share | Magento\MediaGalleryRenditions\Plugin\UpdateRenditionsOnConfigChange | 0 | afterSave |
| Magento\Customer\Model\Config\Share | Magento\MediaGallerySynchronization\Plugin\MediaGallerySyncTrigger | 0 | afterSave |
| Magento\Customer\Model\Config\Share | Magento\ServicesId\Plugin\ProjectIdOnConfigImport | 0 | aroundSave |
| Magento\Customer\Model\Config\Share | Magento\ServicesId\Plugin\SetCloudIdOnConfigImport | 0 | afterAfterSave |
| Magento\Customer\Model\Config\Share | Magento\WebapiSecurity\Model\Plugin\CacheInvalidator | 0 | afterAfterSave |
| Magento\Customer\Model\Config\Share | Magento\ServicesId\Plugin\EnvironmentIdOnConfigImport | 0 | aroundSave |
| Magento\Store\Model\ResourceModel\Website | Magento\Catalog\Model\Indexer\Product\Price\Plugin\Website | 0 | afterDelete |
| Magento\Store\Model\ResourceModel\Website | Magento\Catalog\Model\Indexer\Category\Product\Plugin\Website | 0 | afterDelete |
| Magento\Store\Model\ResourceModel\Website | Magento\InventorySales\Plugin\Store\Model\ResourceModel\Website\DeleteWebsiteToStockLinkPlugin | 0 | afterDelete |
| Magento\Store\Model\ResourceModel\Website | Magento\Catalog\Model\Indexer\Product\Price\Plugin\Website | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Website | Magento\InventorySales\Plugin\Store\Model\ResourceModel\Website\AssignWebsiteToDefaultStockPlugin | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Website | Magento\InventorySales\Plugin\Store\Model\ResourceModel\Website\UpdateSalesChannelWebsiteCodePlugin | 0 | aroundSave |
| Magento\Store\Model\Website | Magento\Theme\Model\Indexer\Design\Config\Plugin\Website | 0 | aroundSave |
| Magento\Store\Model\Website | Magento\Theme\Model\Indexer\Design\Config\Plugin\Website | 0 | afterDelete |
| Magento\Store\Model\Website | Magento\StoreGraphQl\Plugin\Website | 0 | afterGetIdentities |
| Magento\Customer\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Customer\Model\Session | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Customer\Model\Session | Magento\Customer\Model\Plugin\ClearSessionsAfterLogoutPlugin | 0 | afterLogout |
| Magento\Framework\Event\ManagerInterface | ADM\QuickDevBar\Model\Plugin\Event\Manager | 1 | beforeDispatch |
| Magento\Framework\Event\Manager | ADM\QuickDevBar\Model\Plugin\Event\Manager | 1 | beforeDispatch |
| Magento\Store\Api\StoreCookieManagerInterface | Magento\Quote\Plugin\UpdateQuoteStore | 0 | afterSetStoreCookie |
| Magento\Store\Model\StoreCookieManager | Magento\Quote\Plugin\UpdateQuoteStore | 0 | afterSetStoreCookie |
| Magento\Framework\App\ResourceConnection | Magento\Catalog\Model\Indexer\Category\Product\Plugin\TableResolver | 0 | afterGetTableName |
| Magento\Framework\App\ResourceConnection | Magento\Catalog\Model\Indexer\Product\Price\Plugin\TableResolver | 0 | afterGetTableName |
| Magento\Framework\DB\Adapter\AdapterInterface | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterCommit |
| Magento\Framework\DB\Adapter\AdapterInterface | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterRollBack |
| Magento\Framework\DB\Adapter\Pdo\Mysql | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterCommit |
| Magento\Framework\DB\Adapter\Pdo\Mysql | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterRollBack |
| Magento\Framework\App\MutableScopeConfig | MageWorx\ShippingRules\Model\Plugin\AddMethods | 10 | aroundGetValue |
| Magento\Framework\App\ReinitableConfig | MageWorx\ShippingRules\Model\Plugin\AddMethods | 10 | aroundGetValue |
| Magento\Framework\App\RouterInterface | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Robots\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Securitytxt\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\PaymentServicesPaypal\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\UrlRewrite\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| MageWorx\SeoRedirects\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\UrlRewrite\Model\StorageInterface | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\UrlRewrite\Model\StorageInterface | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\UrlRewrite\Model\UrlPersistInterface | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsGeneratePlugin | 1 | aroundReplace |
| Magento\UrlRewrite\Model\Storage\AbstractStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\UrlRewrite\Model\Storage\AbstractStorage | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsGeneratePlugin | 1 | aroundReplace |
| Magento\UrlRewrite\Model\Storage\AbstractStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\UrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\UrlRewrite\Model\Storage\DbStorage | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsGeneratePlugin | 1 | aroundReplace |
| Magento\UrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsGeneratePlugin | 1 | aroundReplace |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Plugin\DynamicCategoryRewrites | 0 | aroundFindOneByData |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Plugin\DynamicCategoryRewrites | 0 | aroundFindAllByData |
| Magento\CatalogUrlRewrite\Model\Storage\DynamicStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\CatalogUrlRewrite\Model\Storage\DynamicStorage | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsGeneratePlugin | 1 | aroundReplace |
| Magento\CatalogUrlRewrite\Model\Storage\DynamicStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| MageWorx\SeoUrls\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Framework\Url\RouteParamsResolver | Magento\Store\Url\Plugin\RouteParamsResolver | 0 | beforeSetRouteParams |
| Magento\Framework\Api\DataObjectHelper | Magento\LoginAsCustomerGraphQl\Plugin\DataObjectHelperPlugin | 0 | afterPopulateWithArray |
| Magento\Framework\Api\DataObjectHelper | MageWorx\DeliveryDate\Plugin\CoreBugFixWithExtensionAttributes | 10 | beforePopulateWithArray |
| Magento\Framework\Data\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Framework\Data\Collection\AbstractDb | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Catalog\Model\ResourceModel\Product\Attribute\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Eav\Model\ResourceModel\Entity\Attribute | Magento\Eav\Plugin\Model\ResourceModel\Entity\Attribute | 0 | aroundGetStoreLabelsByAttributeId |
| Magento\Eav\Model\Entity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Eav\Model\Entity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\Eav\Plugin\Model\ResourceModel\Entity\Attribute | 0 | aroundGetStoreLabelsByAttributeId |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Attribute | 0 | beforeSave |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Attribute | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\CatalogSearch\Model\Attribute\SearchWeight | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Attribute | 0 | beforeDelete |
| Magento\Catalog\Model\ResourceModel\Attribute | MageWorx\LandingPagesPro\Plugin\DeleteLpByAttributes | 1 | beforeDelete |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Attribute | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\Elasticsearch\Model\Indexer\Fulltext\Plugin\Category\Product\Attribute | 0 | beforeSave |
| Magento\Catalog\Model\ResourceModel\Attribute | Magento\Elasticsearch\Model\Indexer\Fulltext\Plugin\Category\Product\Attribute | 0 | afterSave |
| Magento\Eav\Model\Entity\Attribute | Magento\EavGraphQl\Plugin\Eav\AttributePlugin | 0 | afterGetIdentities |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\EavGraphQl\Plugin\Eav\AttributePlugin | 0 | afterGetIdentities |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | beforeBeforeSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | afterAfterSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | afterUsesSource |
| Magento\Framework\Event\InvokerInterface | ADM\QuickDevBar\Model\Plugin\Event\Invoker | 1 | beforeDispatch |
| Magento\Framework\Event\Invoker\InvokerDefault | ADM\QuickDevBar\Model\Plugin\Event\Invoker | 1 | beforeDispatch |
| Magento\Eav\Model\ResourceModel\Entity\Attribute\Option\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Framework\View\Page\Config | Magento\ThemeSampleData\Plugin\View\Page\Config | 0 | afterGetIncludes |
| Magento\Framework\View\Page\Config | MageWorx\SeoMarkup\Plugin\Product\RemoveMarkupAttrFromBodyPlugin | 0 | aroundGetElementAttributes |
| Magento\Framework\View\Layout | Magento\PageCache\Model\Layout\LayoutPlugin | 0 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Persistent\Plugin\AddPersistentRememberMeInitPlugin | 0 | aroundGenerateElements |
| Magento\Framework\View\Layout | Magento\PageCache\Model\Layout\LayoutPlugin | 0 | afterGetOutput |
| Magento\Framework\View\Layout | Hyva\MageWorxAIProductCompare\Plugin\Framework\View\ResolveCompareBlockClass | 0 | beforeCreateBlock |
| Magento\Framework\View\Layout | Ho\Templatehints\Plugin\View\LayoutPlugin | 1 | aroundRenderElement |
| Magento\Framework\View\Layout | Magento\PageCache\Model\Layout\DepersonalizePlugin | 1 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Customer\Model\Layout\DepersonalizePlugin | 10 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Catalog\Model\Layout\DepersonalizePlugin | 10 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Persistent\Model\Layout\DepersonalizePlugin | 10 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Checkout\Model\Layout\DepersonalizePlugin | 20 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Tax\Model\Layout\DepersonalizePlugin | 20 | afterGenerateElements |
| Magento\Framework\View\Layout | Magento\Customer\Model\Layout\DepersonalizePlugin | 10 | beforeGenerateXml |
| Magento\Framework\View\Layout | Magento\Checkout\Model\Layout\DepersonalizePlugin | 20 | beforeGenerateXml |
| Magento\Framework\View\Layout | Magento\Tax\Model\Layout\DepersonalizePlugin | 20 | beforeGenerateXml |
| Magento\Theme\Model\ResourceModel\Theme\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Framework\App\Response\Http | Magento\Framework\App\Response\HeaderManager | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | Magento\PageCache\Model\App\Response\HttpPlugin | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | MageWorx\SeoBase\Plugin\NextPrev\ResponseHttpBefore | 1 | beforeAppendBody |
| Magento\Framework\App\Response\Http | MageWorx\SeoMarkup\Plugin\ProductList\ResponseHttpBefore | 1 | beforeAppendBody |
| Magento\Framework\App\ActionInterface | Magento\Store\App\Action\Plugin\StoreCheck | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\Theme\Plugin\LoadDesignPlugin | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\LoginAsCustomerFrontendUi\Plugin\InvalidateExpiredSessionPlugin | 0 | beforeExecute |
| Magento\Framework\App\ActionInterface | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Store\App\Action\Plugin\StoreCheck | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Theme\Plugin\LoadDesignPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\LoginAsCustomerFrontendUi\Plugin\InvalidateExpiredSessionPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\StoreCheck | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Theme\Plugin\LoadDesignPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\LoginAsCustomerFrontendUi\Plugin\InvalidateExpiredSessionPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Customer\Model\ResourceModel\Visitor | Magento\Catalog\Model\Plugin\Log | 0 | afterClean |
| Magento\Customer\Model\ResourceModel\Visitor | Magento\Reports\Model\Plugin\Log | 0 | afterClean |
| Magento\Directory\Model\ResourceModel\Country\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Checkout\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Checkout\Model\Session | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Catalog\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Catalog\Model\Session | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Framework\App\Http\Context | Magento\Persistent\Model\Plugin\PersistentCustomerContext | 0 | beforeGetVaryString |
| Magento\Framework\App\Http\Context | MageWorx\CustomerPrices\Plugin\Cache\ChangeCacheIdentifierPlugin | 10 | afterGetData |
| Magento\Customer\Model\Customer | Magento\Integration\Plugin\Model\CustomerUser | 0 | afterSave |
| Magento\Customer\Model\Customer | Magento\Integration\Plugin\Model\CustomerUser | 0 | afterDelete |
| Magento\Framework\App\Router\Base | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Framework\App\Action\Action | Magento\Store\App\Action\Plugin\StoreCheck | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Theme\Plugin\LoadDesignPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\LoginAsCustomerFrontendUi\Plugin\InvalidateExpiredSessionPlugin | 0 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeExecute |
| Magento\Framework\App\Action\Action | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Store\App\Action\Plugin\StoreCheck | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Theme\Plugin\LoadDesignPlugin | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\LoginAsCustomerFrontendUi\Plugin\InvalidateExpiredSessionPlugin | 0 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeExecute |
| Magento\Catalog\Controller\Category\View | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Catalog\Model\ResourceModel\AbstractResource | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\AbstractResource | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Category | MageWorx\ShortUrls\Plugin\CategoryDuplicatedUrlsSavePlugin | -1 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Category | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Category | MageWorx\SeoRedirects\Plugin\CategoryPlugin | 1 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\Move | 0 | afterChangeParent |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\UpdateUrlPath | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Category\Attribute\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Eav\Model\Entity\Attribute\Set | Magento\Catalog\Model\Indexer\Product\Eav\Plugin\AttributeSet | 0 | beforeSave |
| Magento\Eav\Model\Entity\Attribute\Set | Magento\Catalog\Model\Indexer\Product\Eav\Plugin\AttributeSet | 0 | afterSave |
| Magento\Framework\EntityManager\TypeResolver | MageWorx\RewardPoints\Model\Plugin\TypeResolverPlugin | 0 | afterResolve |
| Magento\Eav\Model\Entity\Attribute\Backend\AbstractBackend | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\AbstractBackend | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\DefaultBackend | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\DefaultBackend | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\DefaultBackend | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\DefaultBackend | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Image | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Image | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Boolean | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Boolean | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Datetime | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Datetime | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\Startdate | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\Startdate | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Sortby | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Sortby | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\DefaultSortby | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\DefaultSortby | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\AbstractLayoutUpdate | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\AbstractLayoutUpdate | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\LayoutUpdate | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\LayoutUpdate | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\Customlayoutupdate | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Attribute\Backend\Customlayoutupdate | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Created | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Created | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Updated | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Updated | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Increment | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Increment | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Framework\Filter\Template | Magento\PageBuilder\Plugin\Filter\TemplatePlugin | 0 | afterFilter |
| Magento\Email\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\TemplatePlugin | 0 | afterFilter |
| Magento\Email\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\CustomVarTemplate | 0 | afterCustomvarDirective |
| Magento\Cms\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\TemplatePlugin | 0 | afterFilter |
| Magento\Cms\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\CustomVarTemplate | 0 | afterCustomvarDirective |
| MageWorx\SeoCrossLinks\Model\Filter | Magento\PageBuilder\Plugin\Filter\TemplatePlugin | 0 | afterFilter |
| MageWorx\SeoCrossLinks\Model\Filter | Magento\PageBuilder\Plugin\Filter\CustomVarTemplate | 0 | afterCustomvarDirective |
| MageWorx\SeoCrossLinks\Model\ResourceModel\Crosslink\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\Flat\Plugin\StoreGroup | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Product\Flat\Plugin\StoreGroup | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreGroup | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Group | Magento\CatalogInventory\Model\Indexer\Stock\Plugin\StoreGroup | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Group | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\Group | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreGroup | 0 | afterDelete |
| Magento\Store\Model\ResourceModel\Group | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\Group | 0 | afterDelete |
| Magento\Store\Model\Group | Magento\Theme\Model\Indexer\Design\Config\Plugin\StoreGroup | 0 | afterDelete |
| Magento\Store\Model\Group | Magento\StoreGraphQl\Plugin\Group | 0 | afterGetIdentities |
| Magento\Catalog\Model\Layer\Resolver | MageWorx\LandingPagesPro\Plugin\AddLandingPageLayerPlugin | 1 | aroundCreate |
| Magento\Catalog\Model\Layer\Resolver | MageWorx\LandingPagesPro\Plugin\AddLandingPageLayerPlugin | 1 | aroundGet |
| Magento\Catalog\Model\Layer\Resolver | MageWorx\LocationPages\Plugin\AddLocationLayerPlugin | 1 | aroundCreate |
| Magento\Catalog\Model\Layer\Resolver | MageWorx\LocationPages\Plugin\AddLocationLayerPlugin | 1 | aroundGet |
| Magento\Eav\Model\Entity\Collection\AbstractCollection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Catalog\Model\ResourceModel\Collection\AbstractCollection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Catalog\Model\ResourceModel\Category\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Framework\Controller\ResultInterface | Magento\Theme\Controller\Result\MessagePlugin | 0 | afterRenderResult |
| Magento\Framework\Controller\ResultInterface | Magento\PageCache\Model\Controller\Result\BuiltinPlugin | 0 | afterRenderResult |
| Magento\Framework\Controller\ResultInterface | Magento\PageCache\Model\Controller\Result\VarnishPlugin | 0 | afterRenderResult |
| Magento\Framework\Controller\AbstractResult | Magento\Theme\Controller\Result\MessagePlugin | 0 | afterRenderResult |
| Magento\Framework\Controller\AbstractResult | Magento\PageCache\Model\Controller\Result\BuiltinPlugin | 0 | afterRenderResult |
| Magento\Framework\Controller\AbstractResult | Magento\PageCache\Model\Controller\Result\VarnishPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Layout | Magento\Theme\Controller\Result\AsyncCssPlugin | -20 | afterRenderResult |
| Magento\Framework\View\Result\Layout | Magento\Theme\Controller\Result\JsFooterPlugin | -10 | afterRenderResult |
| Magento\Framework\View\Result\Layout | Magento\Theme\Controller\Result\MessagePlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Layout | Magento\PageCache\Model\Controller\Result\BuiltinPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Layout | Magento\PageCache\Model\Controller\Result\VarnishPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\Theme\Controller\Result\AsyncCssPlugin | -20 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\Theme\Controller\Result\JsFooterPlugin | -10 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\Theme\Controller\Result\MessagePlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\PageCache\Model\Controller\Result\BuiltinPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\PageCache\Model\Controller\Result\VarnishPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\PageBuilder\Plugin\Result\Page | 0 | beforeRenderResult |
| Magento\Framework\View\Model\Layout\Merge | Magento\PageCache\Model\Layout\MergePlugin | 0 | beforeValidateUpdate |
| Magento\Framework\View\Model\Layout\Merge | Magento\Widget\Model\ResourceModel\Layout\Plugin | 10 | aroundGetDbUpdateString |
| Magento\Framework\View\Asset\GroupedCollection | Magento\Csp\Plugin\AddDefaultPropertiesToGroupPlugin | 0 | beforeGetFilteredProperties |
| Magento\Framework\View\Element\AbstractBlock | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Template | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Directory\Block\Currency | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Js\Components | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\RequireJs\Block\Html\Head\Config | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Js\Cookie | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Notices | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Html\Links | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\Navigation | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Header | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Store\Block\Switcher | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Header\Logo | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Topmenu | Magento\Catalog\Plugin\Block\Topmenu | 0 | beforeGetHtml |
| Magento\Theme\Block\Html\Topmenu | Magento\Catalog\Plugin\Block\Topmenu | 0 | beforeGetIdentities |
| Magento\Theme\Block\Html\Topmenu | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Text | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Breadcrumbs | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\CustomerPrices\Block\Theme\Html\Title | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Message\Renderer\BlockRenderer\Template | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Messages | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Footer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\FormKey | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Html\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\RegisterLink | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\AuthorizationLink | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\AuthenticationPopup | Magento\ReCaptchaCustomer\Plugin\Block\Account\InjectRecaptchaInAuthenticationPopup | 1 | afterGetJsLayout |
| Magento\Customer\Block\Account\AuthenticationPopup | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\SectionConfig | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\CustomerData | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\CustomerScopeData | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\Html\Link\Current | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\Pricing\Render | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\FrontendStorageManager | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Sales\Block\Reorder\Sidebar | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Sales\Block\Guest\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Checkout\Block\Cart\AbstractCart | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Checkout\Block\Cart\Sidebar | PayPal\Braintree\Plugin\AddAgreementsToMiniCartConfig | 0 | afterGetConfig |
| Magento\Checkout\Block\Cart\Sidebar | PayPal\Braintree\Plugin\PayLaterMessageConfig | 0 | afterGetConfig |
| Magento\Checkout\Block\Cart\Sidebar | Magento\Customer\Model\Cart\ConfigPlugin | 0 | afterGetConfig |
| Magento\Checkout\Block\Cart\Sidebar | Magento\Captcha\Model\Cart\ConfigPlugin | 50 | afterGetConfig |
| Magento\Checkout\Block\Cart\Sidebar | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Checkout\Block\Item\Price\Renderer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Cookie\Block\Html\Notices | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Newsletter\Block\Subscribe | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\GoogleAnalytics\Block\Ga | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Ui\Block\Logger | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Ui\Block\Wysiwyg\ActiveEditor | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\PageCache\Block\Javascript | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\PageBuilder\Block\GoogleMapsApi | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\PageBuilder\Block\WidgetInitializer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Paypal\Block\Express\InContext\Component | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Rss\Block\Feeds | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Translation\Block\Html\Head\Config | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Review\Block\Product\ReviewRenderer | MageWorx\SeoMarkup\Plugin\DisableDefaultReviewMarkupPlugin | 1 | afterToHtml |
| Magento\Review\Block\Product\ReviewRenderer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\AbstractProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\AbstractProduct | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\AbstractProduct | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\AbstractBlock | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Wishlist\Block\AbstractBlock | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Wishlist\Block\AbstractBlock | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\Customer\Sidebar | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Wishlist\Block\Customer\Sidebar | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Wishlist\Block\Customer\Sidebar | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Toolbar | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Panel | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Wrapper | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Request | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Config | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\PhpInfo | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Layout | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Block | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Observer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Event | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Collection | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Model | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Plugin | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Sql | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Log | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Translation | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| ADM\QuickDevBar\Block\Tab\Content\Help | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Ho\Templatehints\Block\Hints\Init | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\GiftCards\Block\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Backend\Model\Session\Quote | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Backend\Model\Session\Quote | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Flat\Plugin\StoreView | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Product\Flat\Plugin\Store | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreView | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Product\Eav\Plugin\StoreView | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\View | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreView | 0 | afterDelete |
| Magento\Store\Model\ResourceModel\Store | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\View | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeSetOrder |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeAddOrder |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Catalog\Model\ResourceModel\Product\Collection | MageWorx\OptionBase\Plugin\ExtendProductCollection | 10 | beforeLoad |
| Magento\Catalog\Model\ResourceModel\Product\Collection | MageWorx\OptionBase\Plugin\CollectProductConditions | 10 | aroundAddOptionsToResult |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Framework\App\Cache\FlushCacheByTags | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Quote\Model\Product\Plugin\RemoveQuoteItems | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\DeleteSourceItemsPlugin | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\InventorySales\Plugin\Catalog\Model\ResourceModel\Product\DeleteReservationsPlugin | 0 | afterDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Quote\Model\Product\Plugin\UpdateQuoteItems | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\ProcessSourceItemsPlugin | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\InventorySales\Plugin\Catalog\Model\ResourceModel\Product\UpdateReservationsPlugin | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Product\Link | Magento\GroupedProduct\Model\ResourceModel\Product\Link\RelationPersister | 0 | afterSaveProductLinks |
| Magento\Catalog\Model\ResourceModel\Product\Link | Magento\GroupedProduct\Model\ResourceModel\Product\Link\RelationPersister | 0 | aroundDeleteProductLink |
| MageWorx\StoreLocator\Block\Header\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\ShippingRules\Block\Zone\Selector | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SocialProofBase\Block\Campaign | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SocialProofBase\Block\Campaign\Popup | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Customer\Block\Account\Customer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Cms\Block\Widget\Block | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Category\View | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\ListProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ListProduct | PayPal\Braintree\Plugin\ProductDetailsBlockPlugin | 0 | aroundGetProductDetailsHtml |
| Magento\Catalog\Block\Product\ListProduct | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\ListProduct | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Element\RendererList | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\ProductList\Item\Block | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\Block | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\ProductList\Item\Block | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\ProductList\Item\Container | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\Container | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\ProductList\Item\Container | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Product\ProductList\Toolbar | MageWorx\SeoUrls\Plugin\Pager\AroundGetPagerUrl | 1 | aroundGetPagerUrl |
| Magento\Catalog\Block\Product\ProductList\Toolbar | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Theme\Block\Html\Pager | MageWorx\SeoUrls\Plugin\Pager\AroundGetPagerUrl | 1 | aroundGetPagerUrl |
| Magento\Theme\Block\Html\Pager | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Cookie\Block\RequireCookie | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Category\Rss\Link | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Msrp\Block\Popup | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\ShortcutButtons | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Paypal\Block\Logo | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Paypal\Block\Bml\Banners | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Paypal\Block\PayLater\Banner | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Model\Config\Source\Product\Options\Price | MageWorx\OptionAdvancedPricing\Plugin\AddPriceTypePlugin | 10 | afterToOptionArray |
| Magento\Catalog\Model\Config\Source\Product\Options\Price | MageWorx\OptionAdvancedPricing\Plugin\AddPriceTypePlugin | 10 | afterPrefixesToOptionArray |
| Magento\Catalog\Block\Product\View\AbstractView | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\View\AbstractView | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Catalog\Block\Product\View\AbstractView | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\ConfigurableProduct\Block\Product\View\Type\Configurable | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\ConfigurableProduct\Block\Product\View\Type\Configurable | Magento\InventoryConfigurableProductFrontendUi\Plugin\ConfigurableProduct\Block\Product\View\Type\AddAdditionalInfo | 0 | afterGetJsonConfig |
| Magento\ConfigurableProduct\Block\Product\View\Type\Configurable | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\ConfigurableProduct\Block\Product\View\Type\Configurable | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Swatches\Block\Product\Renderer\Configurable | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Swatches\Block\Product\Renderer\Configurable | Magento\InventoryConfigurableProductFrontendUi\Plugin\ConfigurableProduct\Block\Product\View\Type\AddAdditionalInfo | 0 | afterGetJsonConfig |
| Magento\Swatches\Block\Product\Renderer\Configurable | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Swatches\Block\Product\Renderer\Configurable | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Swatches\Block\Product\Renderer\Listing\Configurable | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Swatches\Block\Product\Renderer\Listing\Configurable | Magento\InventoryConfigurableProductFrontendUi\Plugin\ConfigurableProduct\Block\Product\View\Type\AddAdditionalInfo | 0 | afterGetJsonConfig |
| Magento\Swatches\Block\Product\Renderer\Listing\Configurable | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Swatches\Block\Product\Renderer\Listing\Configurable | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\GoogleOptimizer\Block\AbstractCode | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\GoogleOptimizer\Block\Code\Category | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\AddToWishlist | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Cms\Model\ResourceModel\Page | Magento\CmsUrlRewrite\Plugin\Cms\Model\ResourceModel\Page | 0 | beforeSave |
| Magento\Cms\Model\ResourceModel\Page | Magento\CmsUrlRewrite\Plugin\Cms\Model\ResourceModel\Page | 0 | afterDelete |
| MageWorx\Faq\Block\Faq | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\ReviewReminderBase\Block\Reminder\Popup | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\RewardPoints\Block\ProductList\RewardPromise | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\SocialMarkup | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\SocialMarkup\Category | MageWorx\SeoBase\Plugin\UseCanonicalUrlInCategorySocialMarkupPlugin | 0 | aroundGetPreparedUrl |
| MageWorx\SeoMarkup\Block\Head\SocialMarkup\Category | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\Json | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\Json\Website | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\Json\Seller | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\Json\Breadcrumbs | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\SeoMarkup\Block\Head\Json\Breadcrumbs\Catalog | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\LayeredNavigation\Block\Navigation | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\LayeredNavigation\Block\Navigation\State | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\LayeredNavigation\Block\Navigation\FilterRenderer | Magento\Swatches\Model\Plugin\FilterRenderer | 1 | aroundRender |
| Magento\LayeredNavigation\Block\Navigation\FilterRenderer | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\View\Asset\Minification | PayPal\Braintree\Plugin\ExcludeFromMinification | 0 | afterGetExcludes |
| Magento\Framework\View\Asset\Minification | Magento\ReCaptchaFrontendUi\Plugin\ExcludeFromMinification | 0 | aroundGetExcludes |
| Magento\RequireJs\Model\FileManager | Magento\Csp\Plugin\GenerateAssetIntegrity | 0 | afterCreateRequireJsConfigAsset |
| Magento\Framework\Pricing\Render\RendererPool | MageWorx\SeoMarkup\Plugin\Product\RegisterPriceBlockPlugin | 0 | afterCreateAmountRender |
| Magento\Framework\Pricing\Render\RendererPool | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\Message\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Message\Session | Magento\LoginAsCustomerFrontendUi\Plugin\KeepLoginAsCustomerSessionDataPlugin | 0 | aroundClearStorage |
| Magento\Framework\App\MaintenanceMode | Magento\MessageQueue\Model\Plugin\ResourceModel\Lock | 0 | afterSet |
| Magento\Catalog\Block\Rss\Product\NewProducts | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Rss\Product\Special | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Rss\Category | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\SalesRule\Block\Rss\Discounts | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Wishlist\Block\Customer\Wishlist | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Wishlist\Block\Customer\Wishlist | MageWorx\LocationPages\Plugin\ShowStockOnLocationPagePlugin | 1 | afterGetProductPrice |
| Magento\Wishlist\Block\Customer\Wishlist | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| MageWorx\RewardPoints\Block\Rss\RewardPoints | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Block\Breadcrumbs | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Helper\Data | MageWorx\SeoBreadcrumbs\Plugin\ModifyBreadcrumbs | 1 | aroundGetBreadcrumbPath |
| Magento\Framework\View\Page\Title | MageWorx\SeoExtended\Plugin\Title\CropPrefixSuffix | 1 | afterGet |
| Magento\Catalog\Model\Layer | MageWorx\SeoMarkup\Plugin\ProductList\AddAttributesToProductListPlugin | 1 | afterPrepareProductCollection |
| Magento\Catalog\Model\Layer\Category | MageWorx\SeoMarkup\Plugin\ProductList\AddAttributesToProductListPlugin | 1 | afterPrepareProductCollection |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeSetOrder |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeAddOrder |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | MageWorx\OptionBase\Plugin\ExtendProductCollection | 10 | beforeLoad |
| Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection | MageWorx\OptionBase\Plugin\CollectProductConditions | 10 | aroundAddOptionsToResult |
| Magento\Framework\Search\Request\Config | Magento\CatalogGraphQl\Plugin\Search\RequestBuilderPlugin | 0 | aroundGet |
| Magento\Catalog\Model\ResourceModel\Config | Magento\Catalog\Plugin\Model\ResourceModel\Config | 0 | aroundGetAttributesUsedInListing |
| Magento\Catalog\Model\ResourceModel\Config | Magento\Catalog\Plugin\Model\ResourceModel\Config | 0 | aroundGetAttributesUsedForSortBy |
| Magento\Catalog\Model\Layer\Filter\Item | MageWorx\SeoUrls\Plugin\LayerFilterItem\AfterGetUrl | 1 | afterGetUrl |
| Magento\Catalog\Model\Layer\Filter\Item | MageWorx\SeoUrls\Plugin\LayerFilterItem\AfterGetRemoveUrl | 1 | afterGetRemoveUrl |
| MageWorx\SeoBase\Model\ResourceModel\CustomCanonical\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\CatalogUrlRewrite\Model\CategoryUrlPathGenerator | MageWorx\ShortUrls\Plugin\CategoryShortUrlPathGeneratorPlugin | 1 | aroundGetUrlPath |
| Magento\Framework\View\TemplateEngineFactory | Magento\Developer\Model\TemplateEngine\Plugin\DebugHints | 10 | afterCreate |
| Magento\Framework\View\Asset\MergeService | Magento\MediaStorage\Model\Asset\Plugin\CleanMergedJsCss | 0 | afterCleanMergedJsCss |
| Magento\Directory\Model\Currency | Magento\DirectoryGraphQl\Plugin\Currency | 0 | afterSaveRates |
| Magento\Store\Model\ResourceModel\Store\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Store\Model\ResourceModel\Group\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\CheckoutAgreements\Model\ResourceModel\Agreement\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Customer\CustomerData\SectionPoolInterface | MageWorx\RewardPoints\Model\Plugin\UpdateCustomerRewardSectionPlugin | 0 | beforeGetSectionsData |
| Magento\Customer\CustomerData\SectionPool | MageWorx\RewardPoints\Model\Plugin\UpdateCustomerRewardSectionPlugin | 0 | beforeGetSectionsData |
| Magento\CatalogInventory\Helper\Stock | Magento\InventoryCatalog\Plugin\CatalogInventory\Helper\Stock\AdaptAddInStockFilterToCollectionPlugin | 0 | aroundAddInStockFilterToCollection |
| Magento\CatalogInventory\Helper\Stock | Magento\InventoryCatalog\Plugin\CatalogInventory\Helper\Stock\AdaptAddStockStatusToProductsPlugin | 0 | aroundAddStockStatusToProducts |
| Magento\CatalogInventory\Helper\Stock | Magento\InventoryCatalog\Plugin\CatalogInventory\Helper\Stock\AdaptAssignStatusToProductPlugin | 0 | beforeAssignStatusToProduct |
| Magento\CatalogInventory\Helper\Stock | Magento\InventoryConfigurableProduct\Plugin\CatalogInventory\Helper\Stock\AdaptAssignStatusToProductPlugin | 0 | beforeAssignStatusToProduct |
| Magento\CatalogInventory\Model\ResourceModel\Stock\Status | Magento\InventoryCatalog\Plugin\CatalogInventory\Model\ResourceModel\Stock\Status\AdaptAddStockDataToCollectionPlugin | 0 | aroundAddStockDataToCollection |
| Magento\CatalogInventory\Model\ResourceModel\Stock\Status | Magento\InventoryCatalog\Plugin\CatalogInventory\Model\ResourceModel\Stock\Status\AdaptAddStockStatusToSelectPlugin | 0 | aroundAddStockStatusToSelect |
| Magento\CatalogInventory\Model\ResourceModel\Stock\Status | Magento\InventoryCatalog\Plugin\CatalogInventory\Model\ResourceModel\Stock\Status\AdaptAddIsInStockFilterToCollectionPlugin | 0 | aroundAddIsInStockFilterToCollection |
| Magento\InventorySalesApi\Api\GetStockBySalesChannelInterface | Magento\InventoryCatalog\Plugin\InventorySalesApi\StockResolver\AdaptStockResolverToAdminWebsitePlugin | 0 | aroundExecute |
| Magento\InventorySales\Model\GetStockBySalesChannelCache | Magento\InventoryCatalog\Plugin\InventorySalesApi\StockResolver\AdaptStockResolverToAdminWebsitePlugin | 0 | aroundExecute |
| Magento\InventorySales\Model\GetStockBySalesChannel | Magento\InventoryCatalog\Plugin\InventorySalesApi\StockResolver\AdaptStockResolverToAdminWebsitePlugin | 0 | aroundExecute |
| Magento\InventoryApi\Api\StockRepositoryInterface | Magento\InventoryCatalog\Plugin\InventoryApi\StockRepository\PreventDeleting\DefaultStockPlugin | 0 | beforeDeleteById |
| Magento\InventoryApi\Api\StockRepositoryInterface | Magento\InventorySales\Plugin\InventoryApi\StockRepository\PreventDeletingAssignedToSalesChannelsStockPlugin | 0 | beforeDeleteById |
| Magento\InventoryApi\Api\StockRepositoryInterface | Magento\InventorySales\Plugin\InventoryApi\StockRepository\LoadSalesChannelsOnGetListPlugin | 0 | afterGetList |
| Magento\InventoryApi\Api\StockRepositoryInterface | Magento\InventorySales\Plugin\InventoryApi\StockRepository\LoadSalesChannelsOnGetPlugin | 0 | afterGet |
| Magento\InventoryApi\Api\StockRepositoryInterface | Magento\InventorySales\Plugin\InventoryApi\StockRepository\SaveSalesChannelsLinksPlugin | 20 | afterSave |
| Magento\Inventory\Model\StockRepository | Magento\InventoryCatalog\Plugin\InventoryApi\StockRepository\PreventDeleting\DefaultStockPlugin | 0 | beforeDeleteById |
| Magento\Inventory\Model\StockRepository | Magento\InventorySales\Plugin\InventoryApi\StockRepository\PreventDeletingAssignedToSalesChannelsStockPlugin | 0 | beforeDeleteById |
| Magento\Inventory\Model\StockRepository | Magento\InventorySales\Plugin\InventoryApi\StockRepository\LoadSalesChannelsOnGetListPlugin | 0 | afterGetList |
| Magento\Inventory\Model\StockRepository | Magento\InventorySales\Plugin\InventoryApi\StockRepository\LoadSalesChannelsOnGetPlugin | 0 | afterGet |
| Magento\Inventory\Model\StockRepository | Magento\InventorySales\Plugin\InventoryApi\StockRepository\SaveSalesChannelsLinksPlugin | 20 | afterSave |
| MageWorx\OptionBase\Helper\Data | MageWorx\OptionInventory\Plugin\TransferSetting | 10 | afterIsHiddenOutOfStockOptions |
| MageWorx\OptionBase\Helper\Data | MageWorx\OptionInventory\Plugin\TransferSetting | 10 | afterIsDisabledOutOfStockOptions |
| Magento\Search\Model\SearchEngine | MageWorx\LandingPagesPro\Plugin\UseMysqlForLandingPagesPlugin | 1 | aroundSearch |
| Magento\Search\Model\SearchEngine | MageWorx\LocationPages\Plugin\UseMysqlForLocationPagePlugin | 1 | aroundSearch |
| Magento\Elasticsearch\ElasticAdapter\Model\Adapter\FieldMapper\ProductFieldMapper | Magento\InventoryElasticsearch\Plugin\Model\Adapter\FieldMapper\AdditionalFieldMapperPlugin | 0 | afterGetAllAttributesTypes |
| Magento\Elasticsearch\Elasticsearch5\Model\Adapter\FieldMapper\ProductFieldMapper | Magento\InventoryElasticsearch\Plugin\Model\Adapter\FieldMapper\AdditionalFieldMapperPlugin | 0 | afterGetAllAttributesTypes |
| Magento\Catalog\Model\Product | Magento\CatalogInventory\Model\Plugin\AfterProductLoad | 0 | afterLoad |
| Magento\Catalog\Model\Product | Magento\ConfigurableProduct\Model\Plugin\ProductIdentitiesExtender | 0 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Cms\Model\Plugin\Product | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Bundle\Model\Plugin\ProductIdentitiesExtender | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Bundle\Model\Plugin\Frontend\ProductIdentitiesExtender | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Swatches\Model\Plugin\Product | 0 | afterGetMediaAttributes |
| Magento\Catalog\Model\Product | MageWorx\Locations\Plugin\SaveNewProductSkuPlugin | 1 | beforeBeforeSave |
| Magento\Catalog\Model\Product | MageWorx\Locations\Plugin\SaveNewProductSkuPlugin | 1 | afterAfterSave |
| Magento\Catalog\Model\Product | MageWorx\OptionBase\Plugin\IsRequireChecker | 10 | afterAfterSave |
| Magento\Catalog\Model\Product | MageWorx\SeoBreadcrumbs\Plugin\ExtendCategoryCollection | 1 | afterGetCategoryCollection |
| Magento\Customer\Model\ResourceModel\Group\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Catalog\Model\Product\Type | Magento\ConfigurableProduct\Model\Product\Type\Plugin | 0 | afterGetOptionArray |
| Magento\Catalog\Model\Product\Type | Magento\GroupedProduct\Model\Product\Type\Plugin | 0 | afterGetOptionArray |
| Magento\Catalog\Model\Product\Type\Price | MageWorx\CustomerPrices\Plugin\AddCustomerPricesToBasePricePlugin | 0 | aroundGetBasePrice |
| Magento\Catalog\Model\Product\Type\Price | MageWorx\CustomerGroupPrices\Plugin\AddGroupPricesToBasePricePlugin | 10 | aroundGetBasePrice |
| Magento\Catalog\Model\Product\Type\Price | MageWorx\OptionFeatures\Plugin\AroundGetBasePrice | 10 | aroundGetFinalPrice |
| Magento\Bundle\Model\Product\Price | MageWorx\CustomerPrices\Plugin\AddCustomerPricesToBasePricePlugin | 0 | aroundGetBasePrice |
| Magento\Bundle\Model\Product\Price | MageWorx\CustomerGroupPrices\Plugin\AddGroupPricesToBasePricePlugin | 10 | aroundGetBasePrice |
| Magento\Bundle\Model\Product\Price | MageWorx\OptionFeatures\Plugin\AroundGetBasePrice | 10 | aroundGetFinalPrice |
| Magento\Catalog\Block\Product\Image | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\Pricing\Render\PriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Framework\Pricing\Render\PriceBox | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Pricing\Render\FinalPriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Catalog\Pricing\Render\FinalPriceBox | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Model\Product\Pricing\Renderer\SalableResolver | Magento\ConfigurableProduct\Plugin\Catalog\Model\Product\Pricing\Renderer\SalableResolver | 0 | afterIsSalable |
| Magento\Catalog\Pricing\Price\RegularPrice | MageWorx\CustomerGroupPrices\Plugin\Pricing\AddGroupPricesToRegularPricePricingPlugin | 10 | afterGetValue |
| Magento\Catalog\Pricing\Price\RegularPrice | MageWorx\CustomerPrices\Plugin\Pricing\AddCustomerPricesToRegularPricePricingPlugin | 20 | afterGetValue |
| Magento\Catalog\Model\Product\Attribute\Backend\Price | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Price | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Price | Magento\Bundle\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Price | Magento\ConfigurableProduct\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\GroupPrice\AbstractGroupPrice | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\GroupPrice\AbstractGroupPrice | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\GroupPrice\AbstractGroupPrice | Magento\Bundle\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\GroupPrice\AbstractGroupPrice | Magento\ConfigurableProduct\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Tierprice | Magento\Catalog\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Tierprice | Magento\ConfigurableProduct\Plugin\Model\Attribute\Backend\AttributeValidation | 0 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Tierprice | Magento\Bundle\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Model\Product\Attribute\Backend\Tierprice | Magento\ConfigurableProduct\Model\Plugin\PriceBackend | 100 | aroundValidate |
| Magento\Catalog\Pricing\Price\SpecialPrice | MageWorx\CustomerGroupPrices\Plugin\Pricing\AddGroupPricesToSpecialPricePricingPlugin | 10 | afterGetValue |
| Magento\Catalog\Pricing\Price\SpecialPrice | MageWorx\CustomerPrices\Plugin\Pricing\AddCustomerPricesToSpecialPricePricingPlugin | 20 | afterGetValue |
| Magento\Catalog\Pricing\Price\ConfiguredRegularPrice | MageWorx\CustomerGroupPrices\Plugin\Pricing\AddGroupPricesToRegularPricePricingPlugin | 10 | afterGetValue |
| Magento\Catalog\Pricing\Price\ConfiguredRegularPrice | MageWorx\CustomerPrices\Plugin\Pricing\AddCustomerPricesToRegularPricePricingPlugin | 20 | afterGetValue |
| Magento\CatalogRule\Model\ResourceModel\Rule | MageWorx\CustomerPrices\Plugin\CatalogRulePlugin | 0 | aroundGetRulePrices |
| Magento\Tax\Helper\Data | MageWorx\MultiFees\Plugin\AddTaxFee | 0 | beforeGetCalculatedTaxes |
| Magento\Tax\Helper\Data | MageWorx\MultiFees\Plugin\AddTaxFee | 0 | afterGetCalculatedTaxes |
| Magento\Framework\Pricing\Render\Amount | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Framework\Pricing\Render\AbstractAdjustment | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Tax\Pricing\Render\Adjustment | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Tax\Pricing\Render\Adjustment | MageWorx\OptionBase\Plugin\AroundGetDataPriceType | 10 | aroundGetDataPriceType |
| Magento\Weee\Pricing\Render\TaxAdjustment | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Weee\Pricing\Render\TaxAdjustment | MageWorx\OptionBase\Plugin\AroundGetDataPriceType | 10 | aroundGetDataPriceType |
| Magento\Weee\Pricing\Render\Adjustment | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\Model\Product\Type\AbstractType | Magento\Bundle\Plugin\Catalog\Model\Product\Type\AbstractType | 0 | afterIsPossibleBuyFromList |
| Magento\Catalog\Model\Product\Type\AbstractType | MageWorx\OptionBase\Plugin\ValidateCartCheckout | 10 | aroundCheckProductBuyState |
| Magento\Catalog\Model\Product\Type\AbstractType | MageWorx\OptionFeatures\Plugin\AroundHasRequiredOptions | 10 | aroundHasRequiredOptions |
| Magento\Catalog\Model\Product\Type\Simple | Magento\Bundle\Plugin\Catalog\Model\Product\Type\AbstractType | 0 | afterIsPossibleBuyFromList |
| Magento\Catalog\Model\Product\Type\Simple | MageWorx\OptionBase\Plugin\ValidateCartCheckout | 10 | aroundCheckProductBuyState |
| Magento\Catalog\Model\Product\Type\Simple | MageWorx\OptionFeatures\Plugin\AroundHasRequiredOptions | 10 | aroundHasRequiredOptions |
| PayPal\Braintree\Block\Credit\Calculator\Listing\Product | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Catalog\ViewModel\Product\OptionsData | Magento\Bundle\Plugin\Catalog\ViewModel\Product\AddBundleOptionsData | 0 | afterGetOptionsData |
| Magento\Bundle\Pricing\Render\FinalPriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Bundle\Pricing\Render\FinalPriceBox | MageWorx\CustomerPrices\Plugin\Cache\ChangeWidgetCacheIdentifierPlugin | 10 | afterGetCacheKeyInfo |
| Magento\Bundle\Pricing\Price\BundleRegularPrice | MageWorx\CustomerGroupPrices\Plugin\Pricing\AddGroupPricesToRegularPricePricingPlugin | 10 | afterGetValue |
| Magento\Bundle\Pricing\Price\BundleRegularPrice | MageWorx\CustomerPrices\Plugin\Pricing\AddCustomerPricesToRegularPricePricingPlugin | 20 | afterGetValue |
| Magento\Bundle\Pricing\Price\SpecialPrice | MageWorx\CustomerGroupPrices\Plugin\Pricing\AddGroupPricesToSpecialPricePricingPlugin | 10 | afterGetValue |
| Magento\Bundle\Pricing\Price\SpecialPrice | MageWorx\CustomerPrices\Plugin\Pricing\AddCustomerPricesToSpecialPricePricingPlugin | 20 | afterGetValue |
| Magento\Bundle\Model\Product\Type | Magento\Bundle\Plugin\Catalog\Model\Product\Type\AbstractType | 0 | afterIsPossibleBuyFromList |
| Magento\Bundle\Model\Product\Type | MageWorx\OptionBase\Plugin\ValidateCartCheckout | 10 | aroundCheckProductBuyState |
| Magento\Bundle\Model\Product\Type | MageWorx\OptionFeatures\Plugin\AroundHasRequiredOptions | 10 | aroundHasRequiredOptions |
| Magento\Bundle\Model\ResourceModel\Option\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | Magento\Theme\Plugin\Data\Collection | 0 | afterGetCurPage |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeSetOrder |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | Magento\InventoryCatalog\Plugin\Catalog\Model\ResourceModel\Product\CollectionPlugin | 0 | beforeAddOrder |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | MageWorx\OptionBase\Plugin\ExtendProductCollection | 10 | beforeLoad |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | Magento\InventoryBundleProduct\Plugin\Bundle\Model\ResourceModel\Selection\Collection\AdaptAddQuantityFilterPlugin | 0 | aroundAddQuantityFilter |
| Magento\Bundle\Model\ResourceModel\Selection\Collection | MageWorx\OptionBase\Plugin\CollectProductConditions | 10 | aroundAddOptionsToResult |
| Magento\Catalog\Model\Product\Attribute\Repository | Magento\CatalogInventory\Model\Plugin\FilterCustomAttribute | 0 | afterGetCustomAttributesMetadata |
| Magento\Catalog\Model\Product\Attribute\Repository | Magento\PageBuilder\Plugin\Catalog\Model\Product\Attribute\RepositoryPlugin | 0 | beforeSave |
| Magento\Catalog\Model\Product\Attribute\Repository | Magento\PageBuilder\Plugin\Catalog\Model\Product\Attribute\RepositoryPlugin | 0 | afterGet |
| Magento\CatalogInventory\Model\ResourceModel\Stock\Item | Magento\InventoryCatalog\Plugin\CatalogInventory\UpdateSourceItemAtLegacyStockItemSavePlugin | 0 | aroundSave |
| Magento\CatalogInventory\Model\ResourceModel\Stock\Item | Magento\InventoryConfigurableProduct\Plugin\CatalogInventory\UpdateLegacyStockStatusForConfigurableProduct | 100 | beforeSave |
| Magento\Widget\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\TemplatePlugin | 0 | afterFilter |
| Magento\Widget\Model\Template\Filter | Magento\PageBuilder\Plugin\Filter\CustomVarTemplate | 0 | afterCustomvarDirective |
| Statistics | 283 queries in 83.10ms (average time: 0.29ms) - 3405 queries/second |
|---|---|
| 281 SELECT - 0 INSERT - 0 UPDATE - 0 DELETE - 0 TRANSACTION | |
| Longest | SELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2) INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category') WHERE (`e`.`path` LIKE '1/2/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC |
| (1.96ms) |
| # | SQL | Time |
|---|---|---|
| 0 | connect | 0.32ms |
| 1 | SET NAMES utf8 | 0.08ms |
| 2 | SELECT `store_website`.* FROM `store_website` | 0.22ms |
| 3 | SELECT `store_group`.* FROM `store_group` | 0.15ms |
| 4 | SELECT `store`.* FROM `store` | 0.13ms |
| 5 | SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash') | 0.28ms |
| 6 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('other/l/color:black/erin-recommends:no/performance-fabric:yes/premium:no.html', 'other/l/color:black/erin-recommends:no/performance-fabric:yes/premium:no.html/')) AND (`store_id` IN ('2')) | 0.22ms |
| 7 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('premium:no.html')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.18ms |
| 8 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('other.html', 'other.html/')) AND (`store_id` IN ('2')) | 0.20ms |
| 9 | SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 2 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY `position` ASC | 0.71ms |
| 10 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '257') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.39ms |
| 11 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '258') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.31ms |
| 12 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '259') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.35ms |
| 13 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '260') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 14 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '261') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.30ms |
| 15 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '262') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.28ms |
| 16 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '263') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 17 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '77') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.21ms |
| 18 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '83') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 19 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '93') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.48ms |
| 20 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '215') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 21 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '223') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 22 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '224') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.24ms |
| 23 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '225') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 24 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '226') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 25 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '227') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 26 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '228') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 27 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '229') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.24ms |
| 28 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '230') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 29 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '231') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 30 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '232') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 31 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '233') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 32 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '234') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.24ms |
| 33 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '235') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 34 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '242') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 35 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '243') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.22ms |
| 36 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '244') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.34ms |
| 37 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '245') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 38 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '246') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.38ms |
| 39 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '247') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 40 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '248') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 41 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '249') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 42 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '250') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 43 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '251') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.31ms |
| 44 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/53', 'catalog/category/view/id/53/')) AND (`store_id` IN ('2')) | 0.37ms |
| 45 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('53')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.20ms |
| 46 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/53', 'catalog/category/view/id/53/')) AND (`store_id` IN ('2')) | 0.18ms |
| 47 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('53')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.15ms |
| 48 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =53) | 0.16ms |
| 49 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 53) | 0.19ms |
| 50 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (45, 119, 48, 49, 149, 140, 52, 60, 120, 63, 68, 118)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (46, 70, 71, 145, 138, 69, 151, 53, 54)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (47, 50, 51, 143, 147, 57, 58, 59, 67, 64)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (61, 62)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (72)) AND (`store_id` IN ('2', 0))) ) AS `u` ORDER BY `store_id` ASC | 0.89ms |
| 51 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '53') LIMIT 1 | 0.17ms |
| 52 | SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '70') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '70') AND (`at_custom_use_parent_settings`.`store_id` = 2) WHERE (`e`.`entity_id` IN('53', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC | 0.38ms |
| 53 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (53, 2)) AND (t_d.attribute_id IN (60, 63, 118)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (53, 2)) AND (t_d.attribute_id IN (61, 62)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (53, 2)) AND (t_d.attribute_id IN (64)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (53, 2)) AND (t_d.attribute_id IN (71)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.89ms |
| 54 | SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag) | 0.26ms |
| 55 | SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag) | 0.24ms |
| 56 | SELECT `layout_update`.`xml`, `layout_update`.`handle` FROM `layout_update` INNER JOIN `layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.theme_id = :theme_id) AND (link.is_temporary = 0) ORDER BY `layout_update`.`sort_order` ASC | 0.75ms |
| 57 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.30ms |
| 58 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC | 0.27ms |
| 59 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) LEFT JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 2) WHERE (`e`.`entity_id` IN('3', '50', '32', '4', '23', '5', '9', '19', '21', '41', '49', '53', '58')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `name` ASC | 1.30ms |
| 60 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (5, 4, 23, 58, 9, 53, 49, 21, 50, 32, 3)) AND (t_d.attribute_id IN (119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (5, 4, 23, 58, 9, 53, 49, 21, 50, 32, 3)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.76ms |
| 61 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) WHERE (`e`.`entity_id` IN('53')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') | 0.43ms |
| 62 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (53)) AND (t_d.attribute_id IN (45, 119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.26ms |
| 63 | SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 2 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY `position` ASC | 0.62ms |
| 64 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='53') | 0.15ms |
| 65 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '53') | 0.12ms |
| 66 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (45, 119, 48, 49, 149, 140, 52, 60, 120, 63, 68, 118)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (46, 70, 71, 145, 138, 69, 151, 53, 54)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (47, 50, 51, 143, 147, 57, 58, 59, 67, 64)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (61, 62)) AND (`store_id` IN ('2', 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '53') AND (attribute_id IN (72)) AND (`store_id` IN ('2', 0))) ) AS `u` ORDER BY `store_id` ASC | 0.89ms |
| 67 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '53') LIMIT 1 | 0.14ms |
| 68 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id) | 0.18ms |
| 69 | SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) | 0.12ms |
| 70 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 71 | SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level) | 0.52ms |
| 72 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('54', '55')) ORDER BY `e`.`position` ASC | 0.56ms |
| 73 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (119, 45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (57)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.52ms |
| 74 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '93') AND (`main_table`.`option_id` IN('95')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 75 | SELECT `main_table`.* FROM `mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '53') AND (`source_store_id` IN(0, '2')) ORDER BY source_store_id DESC | 0.48ms |
| 76 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('53')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.19ms |
| 77 | SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to IN('BYN', 'EUR', 'USD')) | 0.56ms |
| 78 | SELECT `main_table`.* FROM `checkout_agreement` AS `main_table` INNER JOIN `checkout_agreement_store` AS `store_table_2` ON main_table.agreement_id = store_table_2.agreement_id WHERE (store_table_2.store_id IN ('2', 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id` | 0.76ms |
| 79 | SELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '216.73.216.105') | 0.35ms |
| 80 | SELECT `captcha_log`.`count` FROM `captcha_log` WHERE (type = 1) AND (value = '216.73.216.105') | 0.18ms |
| 81 | SELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2) INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category') WHERE (`e`.`path` LIKE '1/2/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC | 1.96ms |
| 82 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (3, 50, 4, 32, 5, 23, 9, 21, 49, 53, 58, 8, 6, 10, 22, 24, 33, 54, 17, 11, 25, 34, 55, 18, 12, 56, 7, 13, 26, 30, 35, 39, 14, 27, 31, 36, 40, 15, 28, 37, 16, 29, 38)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.69ms |
| 83 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('50')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.20ms |
| 84 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('50')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.24ms |
| 85 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('32')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.19ms |
| 86 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('32')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.21ms |
| 87 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.19ms |
| 88 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('23')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 89 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.21ms |
| 90 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('21')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.19ms |
| 91 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('49')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.16ms |
| 92 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('49')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 93 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('22')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 94 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('22')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 95 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('24')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 96 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('24')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 97 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('33')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 98 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('33')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.43ms |
| 99 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('17')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.20ms |
| 100 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('17')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.19ms |
| 101 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.19ms |
| 102 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('25')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.19ms |
| 103 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('34')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.19ms |
| 104 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('34')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 105 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.16ms |
| 106 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('18')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.19ms |
| 107 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.16ms |
| 108 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('26')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.21ms |
| 109 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('30')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.18ms |
| 110 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('30')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 111 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('35')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 112 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('35')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 113 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('39')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.16ms |
| 114 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('39')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 115 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('27')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 116 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('27')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.37ms |
| 117 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('31')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.18ms |
| 118 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('31')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.40ms |
| 119 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('36')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 120 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('36')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 121 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('40')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.16ms |
| 122 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('40')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.24ms |
| 123 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('28')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.20ms |
| 124 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('28')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.19ms |
| 125 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('37')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.41ms |
| 126 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('37')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 127 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('29')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.17ms |
| 128 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('29')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 129 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('38')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) AND (`redirect_type` IN (0)) | 0.18ms |
| 130 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('38')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 131 | SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to IN('BYN', 'EUR', 'USD')) | 0.41ms |
| 132 | SELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base') | 0.38ms |
| 133 | SELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1) | 0.14ms |
| 134 | SELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1) | 0.13ms |
| 135 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id) | 0.20ms |
| 136 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 137 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='performance_fabric') AND (entity_type_id = :entity_type_id) | 0.17ms |
| 138 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 139 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='erin_recommends') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 140 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 141 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='market_release_year') AND (entity_type_id = :entity_type_id) | 0.16ms |
| 142 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 143 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='country_of_origin') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 144 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 145 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='capacity_sets') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 146 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.35ms |
| 147 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='drying_type') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 148 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 149 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='installation_type') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 150 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 151 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='energy_class_old') AND (entity_type_id = :entity_type_id) | 0.13ms |
| 152 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 153 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='energy_class_new') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 154 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.35ms |
| 155 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='drying_class') AND (entity_type_id = :entity_type_id) | 0.35ms |
| 156 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 157 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='washing_class') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 158 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 159 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='floor_indicator_type') AND (entity_type_id = :entity_type_id) | 0.18ms |
| 160 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 161 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='program_count') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 162 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 163 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='auto_program_info') AND (entity_type_id = :entity_type_id) | 0.16ms |
| 164 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 165 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='noise_level') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 166 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 167 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='leak_protection') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 168 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 169 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='push_to_open') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 170 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 171 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='door_soft_close') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 172 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 173 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='daily_program') AND (entity_type_id = :entity_type_id) | 0.18ms |
| 174 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 175 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='eco_program') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 176 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 177 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='activity') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 178 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.36ms |
| 179 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='style_bags') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 180 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 181 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='material') AND (entity_type_id = :entity_type_id) | 0.18ms |
| 182 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 183 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='strap_bags') AND (entity_type_id = :entity_type_id) | 0.36ms |
| 184 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.16ms |
| 185 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='features_bags') AND (entity_type_id = :entity_type_id) | 0.21ms |
| 186 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 187 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='gender') AND (entity_type_id = :entity_type_id) | 0.34ms |
| 188 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 189 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='category_gear') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 190 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 191 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='eco_collection') AND (entity_type_id = :entity_type_id) | 0.16ms |
| 192 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 193 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='new') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 194 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 195 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='sale') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 196 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.36ms |
| 197 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='format') AND (entity_type_id = :entity_type_id) | 0.33ms |
| 198 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 199 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='style_bottom') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 200 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 201 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='style_general') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 202 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 203 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='sleeve') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 204 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 205 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='collar') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 206 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.14ms |
| 207 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='pattern') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 208 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 209 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='climate') AND (entity_type_id = :entity_type_id) | 0.14ms |
| 210 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.13ms |
| 211 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = ( SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (2107, 2108)) ORDER BY FIELD(e.entity_id,2107,2108) | 0.82ms |
| 212 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2108)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2108)) AND (t_d.attribute_id IN (76, 75)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2108)) AND (t_d.attribute_id IN (78, 123)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2108)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2108)) AND (t_d.attribute_id IN (93, 97, 125, 128, 129, 131, 132, 133, 136, 215, 241, 251, 83)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.45ms |
| 213 | SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('2107', '2108')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.27ms |
| 214 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2107', '2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.30ms |
| 215 | SELECT `customerprices`.*, `product`.`entity_id` FROM `mageworx_customerprices` AS `customerprices` LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id WHERE (customerprices.customer_id = 0) | 0.21ms |
| 216 | SELECT `customerprices`.*, `product`.`entity_id` FROM `mageworx_customerprices` AS `customerprices` LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id WHERE (customerprices.customer_id = 0) | 0.18ms |
| 217 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 218 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.26ms |
| 219 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.22ms |
| 220 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = ( SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (2107, 2108)) ORDER BY FIELD(e.entity_id,2107,2108) LIMIT 12 | 0.48ms |
| 221 | SELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (2107, 2108)) | 0.29ms |
| 222 | SELECT `e`.*, `link`.*, `product_website`.*, `price`.*, `link`.`product_id`, (price.final_price < price.price) AS `hasSpecialPrice`, `e`.`entity_id` AS `identifier`, `e`.`entity_id` FROM `catalog_product_entity` AS `e` LEFT JOIN `catalog_product_super_link` AS `link` ON link.parent_id = e.entity_id LEFT JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = link.product_id LEFT JOIN `catalog_product_index_price` AS `price` ON price.entity_id = COALESCE(link.product_id, e.entity_id) AND price.website_id = 2 AND price.customer_group_id = 0 WHERE (e.entity_id IN (2107,2108)) | 0.32ms |
| 223 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2107') ORDER BY `qty` ASC | 0.22ms |
| 224 | SELECT `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to) | 0.16ms |
| 225 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2107')) | 0.15ms |
| 226 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2107) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2107')) | 0.23ms |
| 227 | SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') | 0.23ms |
| 228 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='msrp') AND (entity_type_id = :entity_type_id) | 0.18ms |
| 229 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.15ms |
| 230 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.35ms |
| 231 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.24ms |
| 232 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.44ms |
| 233 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2108') ORDER BY `qty` ASC | 0.21ms |
| 234 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 235 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2108')) | 0.15ms |
| 236 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2108) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2108')) | 0.30ms |
| 237 | SELECT COUNT(*) FROM `catalog_product_bundle_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 2 WHERE (cpe.entity_id = '2108') AND (required=1) | 0.25ms |
| 238 | SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title` FROM `catalog_product_bundle_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 2 WHERE (cpe.entity_id = '2108') ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc | 0.48ms |
| 239 | SELECT (MAX(is_salable) = 1 AND MAX(is_required_and_unsalable) = 0) FROM ( SELECT `bundle_options`.`required`, MAX(IFNULL(child_status_store.value, child_status_global.value) != 2) AS `is_salable`, IF(required = 1 AND MAX(IFNULL(child_status_store.value, child_status_global.value) != 2) = 0, 1, 0) AS `is_required_and_unsalable` FROM `catalog_product_entity` AS `parent_products` INNER JOIN `catalog_product_bundle_option` AS `bundle_options` ON bundle_options.parent_id = parent_products.entity_id INNER JOIN `catalog_product_bundle_selection` AS `bundle_selections` ON bundle_selections.option_id = bundle_options.option_id INNER JOIN `catalog_product_entity` AS `child_products` ON child_products.entity_id = bundle_selections.product_id INNER JOIN `catalog_product_entity_int` AS `child_status_global` ON child_status_global.entity_id = child_products.entity_id AND child_status_global.attribute_id = 97 AND child_status_global.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `child_status_store` ON child_status_store.entity_id = child_products.entity_id AND child_status_store.attribute_id = 97 AND child_status_store.store_id = 2 WHERE (parent_products.entity_id = 2108) GROUP BY `bundle_options`.`parent_id`, `bundle_options`.`option_id`) AS `t` | 0.51ms |
| 240 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-03-01' INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty))) ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.43ms |
| 241 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.64ms |
| 242 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-03-01' INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty))) ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.01ms |
| 243 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2107') ORDER BY `qty` ASC | 0.21ms |
| 244 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 1.07ms |
| 245 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.80ms |
| 246 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2107', '2106')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.29ms |
| 247 | SELECT `customerprices`.*, `product`.`entity_id` FROM `mageworx_customerprices` AS `customerprices` LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id WHERE (customerprices.customer_id = 0) | 0.19ms |
| 248 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 1.01ms |
| 249 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2107') ORDER BY `qty` ASC | 0.20ms |
| 250 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2107')) | 0.14ms |
| 251 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2107) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2107')) | 0.22ms |
| 252 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2106') ORDER BY `qty` ASC | 0.20ms |
| 253 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2106')) | 0.34ms |
| 254 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2106) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2106')) | 0.21ms |
| 255 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.44ms |
| 256 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 0.86ms |
| 257 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2107', '2106')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.27ms |
| 258 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 0.84ms |
| 259 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2108')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 260 | SELECT COUNT(*) FROM `catalog_product_bundle_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 2 WHERE (cpe.entity_id = '2108') AND (required=1) | 0.24ms |
| 261 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty))) ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 1.12ms |
| 262 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty))) ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 1.07ms |
| 263 | SELECT `main_table`.`option_id` FROM `catalog_product_bundle_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0 LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 2 WHERE (cpe.entity_id = '2108') | 0.43ms |
| 264 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (stock_status_index.stock_status = 1) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 0.91ms |
| 265 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (76)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (77, 78, 123)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (2107, 2106)) AND (t_d.attribute_id IN (93, 97, 125, 128, 129, 131, 132, 133, 136, 215, 241, 251)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.18ms |
| 266 | SELECT `mageworx_catalog_product_entity_decimal_temp`.* FROM `mageworx_catalog_product_entity_decimal_temp` WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('2107', '2106')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0) ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.29ms |
| 267 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (5)) AND (selection.parent_product_id = '2108') AND (stock_status_index.stock_status = 1) ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 0.75ms |
| 268 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2107') ORDER BY `qty` ASC | 0.21ms |
| 269 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2107')) | 0.14ms |
| 270 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2107) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2107')) | 0.23ms |
| 271 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2106') ORDER BY `qty` ASC | 0.34ms |
| 272 | SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id IN('2106')) | 0.37ms |
| 273 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price` FROM `catalogrule_product_price` LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (2106) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-03-01' WHERE (catalogrule_product_price.rule_date = '2026-03-01') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('2106')) | 0.22ms |
| 274 | SELECT `mageworx_faq_entity_link`.* FROM `mageworx_faq_entity_link` WHERE (entity_type = 'category') AND (entity_id = 53) AND (entity_identifier = '') AND (store_id = 2) ORDER BY `sort_order` ASC, `link_id` ASC | 0.24ms |
| 275 | SELECT `mageworx_faq_entity_link`.* FROM `mageworx_faq_entity_link` WHERE (entity_type = 'category') AND (entity_id = 53) AND (entity_identifier = '') AND (store_id = 0) ORDER BY `sort_order` ASC, `link_id` ASC | 0.18ms |
| 276 | SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level) | 0.30ms |
| 277 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2) LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('54', '55')) ORDER BY `e`.`position` ASC | 0.40ms |
| 278 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (119, 45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (57)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (54, 55)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.58ms |
| 279 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`main_table`.`attribute_id` = '93') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 280 | SELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`='1') AND (is_active = 1) AND (cbs.store_id in (2, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.29ms |
| 281 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '1') | 0.17ms |
| 282 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.17ms |
exception.log
Tail the 20 last linessystem.log
Tail the 20 last linesdebug.log
Tail the 20 last lines
| Template Path Hints for Storefront | ||
|---|---|---|
| Template Path Hints for Admin | ||
| Add Block Names to Hints | ||
| Translate inline | ||
| Flush Cache Storage |
ADM_QuickDevBar (version 0.1.18)
In order to use this toolbar on a remote server you should either specify allowed IP or set a part of your http header in the config.
Any feedback and idea to improve this toolbar will be appreciate so get in touch via the issue tracker on GitHub.
