- Home
- Sports medicine
Sports medicine
Info 
Design 
Profile 
Queries 
Logs 
Actions | Base Url | https://www.paxbags-us.com/shop/ |
|---|---|
| Path Info | /catalog/category/view/id/129 |
| Module Name | catalog |
| Controller | category |
| Action | view |
| Full Action | catalog_category_view |
| Route | catalog |
| Area | frontend |
| Params | Array ( [id] => 129 ) |
| Client IP | 3.226.122.122 |
| Magento | 2.3.6 |
| Mage Mode | developer |
| Backend | https://www.paxbags-us.com/shop/admin_oap4vw |
| Website Id | 1 |
|---|---|
| Website Name | Main Website |
| Store Id | 2 |
| Store Name | English |
| Store Code | en |
Please wait.
Content is loading ...
Environment
| Variable | Value |
|---|---|
| TEMP | /home/pax-us-live/tmp |
| TMPDIR | /home/pax-us-live/tmp |
| TMP | /home/pax-us-live/tmp |
| USER | pax-us-live |
| HOME | /home/pax-us-live |
| COMPOSER_HOME | /home/pax-us-live/magento/var/composer_home |
PHP Variables
| Variable | Value |
|---|---|
| $_SERVER['TEMP'] | /home/pax-us-live/tmp |
| $_SERVER['TMPDIR'] | /home/pax-us-live/tmp |
| $_SERVER['TMP'] | /home/pax-us-live/tmp |
| $_SERVER['USER'] | pax-us-live |
| $_SERVER['HOME'] | /home/pax-us-live |
| $_SERVER['HTTP_CONNECTION'] | Keep-Alive |
| $_SERVER['HTTP_HOST'] | www.paxbags-us.com |
| $_SERVER['HTTP_ACCEPT_ENCODING'] | br,gzip |
| $_SERVER['HTTP_ACCEPT_LANGUAGE'] | en-US,en;q=0.5 |
| $_SERVER['HTTP_ACCEPT'] | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| $_SERVER['HTTP_USER_AGENT'] | CCBot/2.0 (https://commoncrawl.org/faq/) |
| $_SERVER['MAGE_RUN_CODE'] | en |
| $_SERVER['MAGE_RUN_TYPE'] | store |
| $_SERVER['HTTPS'] | on |
| $_SERVER['SERVER_NAME'] | www.paxbags-us.com |
| $_SERVER['SERVER_PORT'] | 443 |
| $_SERVER['SERVER_ADDR'] | 88.99.195.163 |
| $_SERVER['REMOTE_PORT'] | 41866 |
| $_SERVER['REMOTE_ADDR'] | 3.226.122.122 |
| $_SERVER['SERVER_PROTOCOL'] | HTTP/1.1 |
| $_SERVER['DOCUMENT_ROOT'] | /home/pax-us-live/cms/web |
| $_SERVER['DOCUMENT_URI'] | /shop/index.php |
| $_SERVER['REQUEST_URI'] | /shop/sports-medicine/ |
| $_SERVER['SCRIPT_NAME'] | /shop/index.php |
| $_SERVER['SCRIPT_FILENAME'] | /home/pax-us-live/cms/web/shop/index.php |
| $_SERVER['CONTENT_LENGTH'] | no value |
| $_SERVER['CONTENT_TYPE'] | no value |
| $_SERVER['REQUEST_METHOD'] | GET |
| $_SERVER['QUERY_STRING'] | no value |
| $_SERVER['SERVER_SOFTWARE'] | nginx |
| $_SERVER['GATEWAY_INTERFACE'] | CGI/1.1 |
| $_SERVER['FCGI_ROLE'] | RESPONDER |
| $_SERVER['PHP_SELF'] | /shop/index.php |
| $_SERVER['REQUEST_TIME_FLOAT'] | 1680391302.0668 |
| $_SERVER['REQUEST_TIME'] | 1680391302 |
Please wait.
Content is loading ...
| Handles | default catalog_category_view catalog_category_view_type_layered catalog_category_view_type_layered_without_children catalog_category_view_id_129 mpseo_remove_schema |
|---|
| Blocks hierarchy |
|
|---|
| Block | Call Number |
|---|---|
| Magento\Directory\Block\Currency | 2 |
| Magento\Framework\View\Element\Template | 16 |
| Magento\Framework\View\Element\Js\Components | 8 |
| Magento\RequireJs\Block\Html\Head\Config | 1 |
| Magento\Framework\View\Element\Js\Cookie | 2 |
| Magento\Theme\Block\Html\Notices | 1 |
| Magento\Theme\Block\Html\Header | 1 |
| Smartwave\Porto\Block\Template | 8 |
| Magento\Store\Block\Switcher | 3 |
| Magento\Customer\Block\Account\Navigation | 1 |
| Magento\Theme\Block\Html\Header\Logo | 1 |
| Magento\Framework\View\Element\Text | 1 |
| Magento\Theme\Block\Html\Breadcrumbs | 1 |
| Magento\Theme\Block\Html\Title\Interceptor | 1 |
| Magento\Framework\View\Element\Messages | 1 |
| Magento\Theme\Block\Html\Footer | 1 |
| Magento\Framework\View\Element\FormKey | 1 |
| Magento\Customer\Block\Account\Link | 1 |
| Magento\Customer\Block\Account\RegisterLink | 1 |
| Magento\Customer\Block\Account\AuthorizationLink | 2 |
| Magento\Customer\Block\Account\AuthenticationPopup\Interceptor | 1 |
| Magento\Customer\Block\SectionConfig | 1 |
| Magento\Customer\Block\CustomerData | 1 |
| Magento\Customer\Block\CustomerScopeData | 1 |
| Magento\Framework\Pricing\Render\RendererPool | 1 |
| Magento\Framework\Pricing\Render\Interceptor | 1 |
| Magento\Catalog\Block\FrontendStorageManager | 1 |
| Magento\Framework\View\Element\Html\Links | 1 |
| Magento\Checkout\Block\Cart\Sidebar\Interceptor | 1 |
| Magento\Checkout\Block\Item\Price\Renderer | 1 |
| Magento\Cookie\Block\Html\Notices | 1 |
| Magento\GoogleAnalytics\Block\Ga | 1 |
| Magento\Ui\Block\Logger | 1 |
| Magento\Ui\Block\Wysiwyg\ActiveEditor | 1 |
| Magento\PageCache\Block\Javascript | 1 |
| Magento\Paypal\Block\Express\InContext\Component | 1 |
| Magento\Translation\Block\Html\Head\Config | 1 |
| Magento\Wishlist\Block\Link | 1 |
| ADM\QuickDevBar\Block\Toolbar | 1 |
| ADM\QuickDevBar\Block\Tab\Wrapper | 5 |
| ADM\QuickDevBar\Block\Tab\Content\Request | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Config | 1 |
| ADM\QuickDevBar\Block\Tab\Content\PhpInfo | 2 |
| ADM\QuickDevBar\Block\Tab\Content\Layout | 2 |
| ADM\QuickDevBar\Block\Tab\Content\Block | 1 |
| ADM\QuickDevBar\Block\Tab\Panel | 3 |
| ADM\QuickDevBar\Block\Tab\Content\Observer | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Event | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Collection | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Model | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Plugin | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Sql | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Log | 1 |
| ADM\QuickDevBar\Block\Tab\Content\Translation | 4 |
| ADM\QuickDevBar\Block\Tab\Content\Help | 1 |
| Amazon\Core\Block\Config | 1 |
| Magento\Customer\Block\Account\Customer | 2 |
| Detco\ExtendedAnalytics\Block\GtmCode | 2 |
| Detco\ExtendedAnalytics\Block\DataLayer | 1 |
| Detco\GeoIP\Block\GeoIP | 1 |
| Detco\Menu\Block\Typo3Menu | 1 |
| Detco\MenuMobile\Block\Typo3Menu | 1 |
| Detco\PaxTheme\Block\Price\Details | 1 |
| Ebizmarts\MailChimp\Block\Mailchimpjs | 1 |
| Ebizmarts\MailChimp\Block\Catcher | 1 |
| Detco\ExtendedAnalytics\Helper\ConfigHelper | 1 |
| Smartwave\Megamenu\Block\Topmenu | 1 |
| Detco\Footer\Block\Typo3Footer | 1 |
| Magento\Newsletter\Block\Subscribe | 2 |
| Magento\Catalog\Block\Category\View | 6 |
| Magento\Catalog\Block\Product\ListProduct\Interceptor | 1 |
| Magento\Framework\View\Element\RendererList | 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 | 1 |
| Magento\Catalog\Block\Category\Rss\Link | 1 |
| Magento\Msrp\Block\Popup | 1 |
| Magento\Catalog\Block\ShortcutButtons | 1 |
| Magento\Paypal\Block\Bml\Banners | 1 |
| Magento\GoogleOptimizer\Block\Code\Category | 1 |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor | 1 |
| Magento\Wishlist\Block\AddToWishlist | 1 |
| Detco\ExtendedAnalytics\Block\Data\Category | 1 |
| FireGento\MageSetup\Block\Product\Delivery | 1 |
| Magento\LayeredNavigation\Block\Navigation | 1 |
| Magento\LayeredNavigation\Block\Navigation\State | 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 |
|---|---|---|---|
| controller_action_predispatch | customer_visitor | 1 | Magento\Customer\Observer\Visitor\InitByRequestObserver |
| controller_action_predispatch | newrelicreporting_observer_report_concurrent_users | 1 | Magento\NewRelicReporting\Model\Observer\ReportConcurrentUsers |
| controller_action_predispatch | newrelicreporting_newrelic_report_concurrent_users | 1 | Magento\NewRelicReporting\Model\Observer\ReportConcurrentUsersToNewRelic |
| controller_action_predispatch | persistent_synchronize | 1 | Magento\Persistent\Observer\SynchronizePersistentInfoObserver |
| controller_action_predispatch | persistent | 1 | Magento\Persistent\Observer\EmulateQuoteObserver |
| controller_action_predispatch | persistent_session | 1 | Magento\Persistent\Observer\RenewCookieObserver |
| controller_action_predispatch | persistent_quote | 1 | Magento\Persistent\Observer\CheckExpirePersistentQuoteObserver |
| controller_action_predispatch | persistent_customer | 1 | Magento\Persistent\Observer\EmulateCustomerObserver |
| controller_action_predispatch | seo_redirect_controller_action_predispatch | 1 | Mageplaza\Redirects\Observer\SeoRedirectControllerPredispatch |
| magento_catalog_api_data_categorytreeinterface_load_after | legacy_categorytree_load_after | 16 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_controller_category_init_after | seo_rule_catalog_category_view | 1 | Mageplaza\SeoRule\Observer\CatalogCategoryViewObserver |
| layout_load_before | mpseo_remove_schema | 1 | Mageplaza\Seo\Observer\RemoveSchemaObserver |
| layout_generate_blocks_after | persistent | 1 | Magento\Persistent\Observer\ApplyPersistentDataObserver |
| layout_generate_blocks_after | personalize-theme-pdp-customize | 1 | Detco\SwatchChange\Observer\ApplyThemeCustomizationObserver |
| layout_generate_blocks_after | mageplaza_seo_rule_generate_blocks_after | 1 | Mageplaza\SeoRule\Observer\GenerateBlocksAfterObserver |
| controller_action_postdispatch | customer_visitor | 1 | Magento\Customer\Observer\Visitor\SaveByRequestObserver |
| layout_render_before | Amasty_Base::add_theme_class_name | 1 | Amasty\Base\Observer\AddBodyClassName |
| core_layout_render_element | pagecache | 110 | Magento\PageCache\Observer\ProcessLayoutRenderElement |
| currency_display_options_forming | magento_currencysymbol_currency_display_options | 1 | Magento\CurrencySymbol\Observer\CurrencyDisplayOptions |
| catalog_block_product_list_collection | review | 1 | Magento\Review\Observer\CatalogProductListCollectionAppendSummaryFieldsObserver |
List only events dispatched when Magento generate this page
| Event | Data | Call Number |
|---|---|---|
| customer_session_init |
| 2 |
| model_load_before |
| 5 |
| core_abstract_load_before |
| 3 |
| model_load_after |
| 24 |
| core_abstract_load_after |
| 3 |
| controller_action_predispatch |
| 1 |
| controller_action_predispatch_catalog |
| 1 |
| controller_action_predispatch_catalog_category_view |
| 1 |
| entity_manager_load_before |
| 16 |
| magento_catalog_api_data_categorytreeinterface_load_before |
| 16 |
| magento_catalog_api_data_categorytreeinterface_load_after |
| 16 |
| catalog_category_load_after |
| 16 |
| entity_manager_load_after |
| 16 |
| catalog_controller_category_init_after |
| 1 |
| core_collection_abstract_load_before |
| 63 |
| mageplaza_seorule_meta_collection_load_before |
| 1 |
| core_collection_abstract_load_after |
| 63 |
| mageplaza_seorule_meta_collection_load_after |
| 1 |
| eav_collection_abstract_load_before |
| 8 |
| catalog_category_collection_load_before |
| 7 |
| catalog_category_collection_load_after |
| 7 |
| layout_load_before |
| 1 |
| layout_generate_blocks_before |
| 1 |
| core_layout_block_create_after |
| 142 |
| layout_generate_blocks_after |
| 1 |
| controller_action_postdispatch_catalog_category_view |
| 1 |
| controller_action_postdispatch_catalog |
| 1 |
| controller_action_postdispatch |
| 1 |
| layout_render_before | 1 | |
| layout_render_before_catalog_category_view | 1 | |
| view_block_abstract_to_html_before |
| 127 |
| view_block_abstract_to_html_after |
| 122 |
| core_layout_render_element |
| 110 |
| magepal_datalayer |
| 1 |
| catalog_category_tree_init_inactive_category_ids |
| 4 |
| store_collection_load_before |
| 1 |
| store_collection_load_after |
| 1 |
| currency_display_options_forming |
| 1 |
| customer_group_load_before |
| 2 |
| customer_group_load_after |
| 2 |
| tax_rate_data_fetch |
| 11 |
| mageplaza_seocrosslinks_term_collection_load_before |
| 1 |
| mageplaza_seocrosslinks_term_collection_load_after |
| 1 |
| catalog_product_collection_apply_limitations_after |
| 4 |
| catalog_block_product_list_collection |
| 1 |
| abstract_search_result_load_before |
| 1 |
| abstract_search_result_load_after |
| 1 |
| catalogsearch_query_add_filter_after |
| 10 |
| catalog_entity_attribute_load_after |
| 3 |
| catalog_product_collection_load_after |
| 1 |
| catalog_product_is_salable_before |
| 9 |
| catalog_product_is_salable_after |
| 9 |
| Collection | Call Number |
|---|---|
| Mageplaza\SeoRule\Model\ResourceModel\Meta\Collection | 1 |
| Magento\Catalog\Model\ResourceModel\Product\Attribute\Collection | 1 |
| Magento\Store\Model\ResourceModel\Store\Collection | 1 |
| Magento\Store\Model\ResourceModel\Group\Collection | 2 |
| Magento\Tax\Model\ResourceModel\TaxClass\Collection | 1 |
| Mageplaza\SeoCrosslinks\Model\ResourceModel\Term\Collection | 1 |
| Magento\Eav\Model\ResourceModel\Entity\Attribute\Option\Collection | 48 |
| Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable\Attribute\Collection | 6 |
| Magento\Swatches\Model\ResourceModel\Swatch\Collection | 2 |
| Event | Call Number |
|---|---|
| Magento\Framework\Flag | 1 |
| Magento\Customer\Model\Group\Interceptor | 2 |
| Magento\Tax\Model\ClassModel | 2 |
| Types | Plugin | Sort Order | Method |
|---|---|---|---|
| Magento\Framework\Session\SessionManagerInterface | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\SessionManager | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\Generic | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\CatalogSearch\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Catalog\Block\Product\AbstractProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\AbstractProduct | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\Catalog\Block\Product\ListProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ListProduct | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\Catalog\Block\Product\ListProduct | Yotpo\Yotpo\Plugin\Catalog\Block\Product\ListProduct | 0 | aroundGetReviewsSummaryHtml |
| Magento\Catalog\Block\Product\ListProduct | FireGento\MageSetup\Plugin\Catalog\Block\Product\ListProduct\AddDeliveryTimePlugin | 1 | afterGetProductDetailsHtml |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | Yotpo\Yotpo\Plugin\Catalog\Block\Product\ListProduct | 0 | aroundGetReviewsSummaryHtml |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | FireGento\MageSetup\Plugin\Catalog\Block\Product\ListProduct\AddDeliveryTimePlugin | 1 | afterGetProductDetailsHtml |
| Magento\Paypal\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Paypal\Model\PayflowSession | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Review\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Wishlist\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| 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 | aroundSave |
| Magento\Store\Model\Store | Magento\Theme\Model\Indexer\Design\Config\Plugin\Store | 0 | afterDelete |
| 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\Plugin\RegisterFormKeyFromCookie | 0 | beforeDispatch |
| Magento\Framework\App\FrontControllerInterface | Magento\Deploy\Model\Plugin\ConfigChangeDetector | 50 | beforeDispatch |
| Magento\Framework\App\FrontControllerInterface | Magento\PageCache\Model\App\FrontController\VarnishPlugin | 0 | afterDispatch |
| Magento\Framework\App\FrontController | Magento\PageCache\Model\App\FrontController\BuiltinPlugin | 0 | aroundDispatch |
| 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\PageCache\Model\App\FrontController\VarnishPlugin | 0 | afterDispatch |
| Magento\Framework\App\FrontController | Magento\Store\App\FrontController\Plugin\RequestPreprocessor | 50 | aroundDispatch |
| Magento\Framework\App\PageCache\Kernel | Mageplaza\LayeredNavigation\Plugin\PageCache\ProcessRequest | 0 | beforeLoad |
| Magento\Framework\App\PageCache\Identifier | Mageplaza\LayeredNavigation\Plugin\PageCache\Identifier | 0 | afterGetValue |
| Magento\Framework\App\PageCache\Identifier | Magento\PageCache\Model\App\CacheIdentifierPlugin | 10 | afterGetValue |
| Magento\Framework\App\Http\Context | Magento\Persistent\Model\Plugin\PersistentCustomerContext | 0 | beforeGetVaryString |
| Magento\Framework\App\Config\Value | Magento\WebapiSecurity\Model\Plugin\CacheInvalidator | 0 | afterAfterSave |
| Magento\Customer\Model\Config\Share | Magento\WebapiSecurity\Model\Plugin\CacheInvalidator | 0 | afterAfterSave |
| 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\Catalog\Model\Indexer\Product\Price\Plugin\Website | 0 | afterSave |
| 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\Customer\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| 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\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\Eav\Model\Entity\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Eav\Model\Entity\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Eav\Model\Entity\VersionControl\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Eav\Model\Entity\VersionControl\AbstractEntity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Customer\Model\ResourceModel\Customer | Magento\Quote\Plugin\RecollectOnGroupChange | 0 | afterSave |
| Magento\Checkout\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Store\Api\StoreCookieManagerInterface | Magento\Quote\Plugin\UpdateQuoteStore | 0 | afterSetStoreCookie |
| Magento\Store\Model\StoreCookieManager | Magento\Quote\Plugin\UpdateQuoteStore | 0 | afterSetStoreCookie |
| Magento\Framework\App\RouterInterface | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Robots\Controller\Router | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| FTS\FixTrailingSlash\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\Storage\AbstractStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| 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 | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\Framework\Api\DataObjectHelper | Amasty\Conditions\Plugin\Framework\Api\DataObjectHelperPlugin | 1 | beforePopulateWithArray |
| Magento\Framework\Url\RouteParamsResolver | Magento\Store\Url\Plugin\RouteParamsResolver | 0 | beforeSetRouteParams |
| Magento\Framework\View\Layout | Magento\PageCache\Model\Layout\LayoutPlugin | 0 | afterGenerateElements |
| 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\PageCache\Model\Layout\LayoutPlugin | 0 | afterGetOutput |
| Magento\Framework\View\Layout | Magento\Customer\Model\Layout\DepersonalizePlugin | 10 | beforeGenerateXml |
| Magento\Framework\View\Layout | Magento\Tax\Model\Layout\DepersonalizePlugin | 20 | beforeGenerateXml |
| Magento\Framework\App\Response\Http | Magento\Framework\App\Response\HeaderManager | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | Magento\Theme\Controller\Result\JsFooterPlugin | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | Magento\Theme\Controller\Result\AsyncCssPlugin | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | Magento\PageCache\Model\App\Response\HttpPlugin | 0 | beforeSendResponse |
| Magento\Framework\App\Action\AbstractAction | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Framework\App\Action\AbstractAction | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Catalog\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Eav\Model\ResourceModel\Entity\Attribute | Magento\Eav\Plugin\Model\ResourceModel\Entity\Attribute | 0 | aroundGetStoreLabelsByAttributeId |
| Magento\Customer\Model\Customer | Magento\Integration\Plugin\Model\CustomerUser | 0 | afterSave |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| 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\Framework\App\Router\Base | Magento\Csp\Plugin\CspAwareControllerPlugin | 0 | afterMatch |
| Magento\Framework\App\Action\Action | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Framework\App\Action\Action | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Catalog\Controller\Category\View | Mageplaza\AjaxLayer\Plugin\Controller\Category\View | 1 | afterExecute |
| Smartwave\Porto\Controller\Category\View | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Smartwave\Porto\Controller\Category\View | Mageplaza\AjaxLayer\Plugin\Controller\Category\View | 1 | afterExecute |
| 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\Customer\Model\ResourceModel\Visitor | Magento\Catalog\Model\Plugin\Log | 0 | afterClean |
| Magento\Customer\Model\ResourceModel\Visitor | Magento\Reports\Model\Plugin\Log | 0 | afterClean |
| Magento\Catalog\Model\ResourceModel\AbstractResource | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\AbstractResource | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Category | 0 | aroundSave |
| 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\Remove | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\UpdateUrlPath | 0 | afterSave |
| 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 | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Attribute | 0 | afterDelete |
| Magento\Eav\Model\Entity\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | beforeBeforeSave |
| Magento\Eav\Model\Entity\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | afterAfterSave |
| Magento\Eav\Model\Entity\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | afterUsesSource |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | beforeBeforeSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | beforeBeforeSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | afterAfterSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | afterAfterSave |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute | 0 | afterUsesSource |
| Magento\Catalog\Model\ResourceModel\Eav\Attribute | Magento\Swatches\Model\Plugin\EavAttribute | 0 | afterUsesSource |
| 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\AbstractBackend | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\AbstractBackend | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Eav\Model\Entity\Attribute\Backend\DefaultBackend | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\DefaultBackend | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Category\Attribute\Backend\Image | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Image | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Eav\Model\Entity\Attribute\Backend\Datetime | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Datetime | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Attribute\Backend\Startdate | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Attribute\Backend\Startdate | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Sortby | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\Sortby | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Attribute\Backend\AbstractLayoutUpdate | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Attribute\Backend\AbstractLayoutUpdate | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Category\Attribute\Backend\LayoutUpdate | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Category\Attribute\Backend\LayoutUpdate | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Catalog\Model\Attribute\Backend\Customlayoutupdate | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Catalog\Model\Attribute\Backend\Customlayoutupdate | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Created | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Created | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Time\Updated | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Time\Updated | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| 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\Eav\Model\Entity\Attribute\Backend\Increment | Dhl\ShippingCore\Plugin\Eav\Attribute\Backend\ValidateHsCodeAttribute | 0 | afterValidate |
| Magento\Eav\Model\Entity\Attribute\Backend\Increment | Mageplaza\CustomerAttributes\Model\Plugin\Eav\Attribute\AbstractBackend | 0 | beforeValidate |
| Magento\Catalog\Helper\Category | Mageplaza\Seo\Plugin\Helper\CanUseCanonicalTagForCategories | 0 | afterCanUseCanonicalTag |
| Magento\Catalog\Helper\Category | Mageplaza\SeoPro\Plugin\CategoryHelper | 0 | afterCanUseCanonicalTag |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\Flat\Plugin\StoreGroup | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Product\Flat\Plugin\StoreGroup | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreGroup | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Group | Magento\CatalogInventory\Model\Indexer\Stock\Plugin\StoreGroup | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Group | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\Group | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Group | Magento\Catalog\Model\Indexer\Category\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\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\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\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\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\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\Backend\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Theme\Block\Html\Title | Mageplaza\SeoRule\Block\Plugin\SeoHeading | 0 | beforeGetPageTitle |
| Magento\Theme\Block\Html\Title | Mageplaza\SeoRule\Block\Plugin\SeoHeading | 0 | aroundGetPageHeading |
| Magento\Customer\Block\Account\AuthenticationPopup | MSP\ReCaptcha\Plugin\Block\Account\AuthenticationPopupPlugin | 1 | afterGetJsLayout |
| Magento\Framework\Pricing\Render | FireGento\MageSetup\Plugin\Pricing\AddPriceDetailsPlugin | 1 | afterRender |
| 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\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 | Magento\Catalog\Plugin\Block\Topmenu | 0 | afterGetCacheKeyInfo |
| Magento\Review\Block\Product\ReviewRenderer | Yotpo\Yotpo\Plugin\Review\Block\Product\ReviewRenderer | 0 | aroundGetReviewsSummaryHtml |
| Magento\Review\Block\Product\ReviewRenderer | Mageplaza\Seo\Plugin\RemoveReview | 0 | afterGetReviewsSummaryHtml |
| Magento\Catalog\Block\Product\ProductList\Item\Block | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\Block | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\Container | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\Container | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\Catalog\Block\Product\ProductList\Toolbar | Mageplaza\SeoUrl\Plugin\Filter\Toolbar | -1 | afterGetPagerUrl |
| Magento\Theme\Block\Html\Pager | Mageplaza\SeoUrl\Plugin\Filter\Pager | -1 | afterGetPagerUrl |
| 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 | Mageplaza\GiftCard\Plugin\Block\Catalog\ProductImage | 0 | afterGetImage |
| Magento\LayeredNavigation\Block\Navigation\FilterRenderer | Magento\Swatches\Model\Plugin\FilterRenderer | 1 | aroundRender |
| Magento\Framework\View\Asset\Minification | MSP\ReCaptcha\Plugin\ExcludeFromMinification | 0 | aroundGetExcludes |
| Magento\Framework\Message\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Eav\Model\Entity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Eav\Model\Entity | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Framework\View\TemplateEngineFactory | Magento\Developer\Model\TemplateEngine\Plugin\DebugHints | 10 | afterCreate |
| Magento\Framework\View\TemplateEngine\Php | Magento\Csp\Plugin\TemplateRenderingPlugin | 0 | beforeRender |
| Magento\Framework\View\TemplateEngine\Php | Amasty\Base\Plugin\Framework\View\TemplateEngine\Php | 10 | beforeRender |
| Magento\Framework\View\Page\Config\Renderer | Amasty\Base\Plugin\Frontend\AddAssets | 0 | beforeRenderAssets |
| Magento\Framework\View\Page\Config\Renderer | Mageplaza\Seo\Plugin\SeoRender | 0 | beforeRenderMetadata |
| Magento\Framework\View\Page\Config\Renderer | Mageplaza\SeoPro\Plugin\SeoProRender | 0 | afterRenderMetadata |
| Magento\Framework\View\Page\Config\Renderer | Mageplaza\Seo\Plugin\SeoRender | 0 | afterRenderHeadContent |
| Magento\Framework\View\Page\Config\Renderer | Mageplaza\SeoUltimate\Plugin\SeoHrefLang | 0 | afterRenderHeadContent |
| Magento\Framework\View\Asset\MergeService | Magento\MediaStorage\Model\Asset\Plugin\CleanMergedJsCss | 0 | afterCleanMergedJsCss |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Flat\Plugin\StoreView | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Product\Flat\Plugin\Store | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Product\Plugin\StoreView | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Product\Eav\Plugin\StoreView | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Store | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Store\View | 0 | beforeSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Flat\Plugin\StoreView | 0 | afterSave |
| Magento\Store\Model\ResourceModel\Store | Magento\Catalog\Model\Indexer\Category\Product\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\Attribute\Config | FireGento\MageSetup\Plugin\Catalog\Model\Attribute\AddVisibleInCheckoutAttributesToAttributeNamesPlugin | 1 | afterGetAttributeNames |
| Magento\Tax\Helper\Data | Dhl\ShippingCore\Plugin\Tax\AddFeeTaxAmounts | 0 | afterGetCalculatedTaxes |
| Magento\Tax\Api\TaxCalculationInterface | Vertex\Tax\Model\Plugin\TaxCalculationPlugin | 1 | aroundCalculateTax |
| Magento\Tax\Model\TaxCalculation | Vertex\Tax\Model\Plugin\TaxCalculationPlugin | 1 | aroundCalculateTax |
| Magento\Customer\Api\GroupRepositoryInterface | Magento\Catalog\Model\Indexer\Product\Price\Plugin\CustomerGroup | 0 | aroundSave |
| Magento\Customer\Api\GroupRepositoryInterface | Magento\Catalog\Model\Indexer\Product\Price\Plugin\CustomerGroup | 0 | afterDeleteById |
| Magento\Customer\Model\ResourceModel\GroupRepository | Magento\Catalog\Model\Indexer\Product\Price\Plugin\CustomerGroup | 0 | aroundSave |
| Magento\Customer\Model\ResourceModel\GroupRepository | Magento\Catalog\Model\Indexer\Product\Price\Plugin\CustomerGroup | 0 | afterDeleteById |
| MSP\ReCaptcha\Model\LayoutSettings | Magento\PaypalReCaptcha\Plugin\LayoutSettings | 0 | afterGetCaptchaSettings |
| Magento\Catalog\Helper\Output | Mageplaza\SeoCrosslinks\Plugin\SeoCrosslinksCatalog | 0 | aroundProcess |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Mageplaza\LayeredNavigation\Model\ResourceModel\Fulltext\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Product | Magento\Quote\Model\Product\Plugin\RemoveQuoteItems | 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\UpdateQuoteItems | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Product | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product | 0 | aroundSave |
| Magento\Catalog\Model\Layer\Category\CollectionFilter | Faonni\SmartCategory\Plugin\Catalog\Model\Layer\Category\CollectionFilter | 0 | aroundFilter |
| 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\CatalogSearch\Model\Adapter\Mysql\Filter\Preprocessor | Mageplaza\LayeredNavigation\Plugin\Model\Adapter\Preprocessor | 1 | aroundProcess |
| Magento\CatalogSearch\Model\Adapter\Mysql\Aggregation\DataProvider | Magento\CatalogSearch\Model\Adapter\Mysql\Plugin\Aggregation\Category\DataProvider | 0 | aroundGetDataSet |
| 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 |
| 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\Frontend\Product | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\CatalogInventory\Model\Plugin\AfterProductLoad | 0 | afterLoad |
| Magento\Catalog\Model\Product | Magento\Swatches\Model\Plugin\Product | 0 | afterGetMediaAttributes |
| Detco\PaxTheme\Model\Product | Magento\ConfigurableProduct\Model\Plugin\ProductIdentitiesExtender | 0 | afterGetIdentities |
| Detco\PaxTheme\Model\Product | Magento\Cms\Model\Plugin\Product | 100 | afterGetIdentities |
| Detco\PaxTheme\Model\Product | Magento\Bundle\Model\Plugin\Frontend\Product | 100 | afterGetIdentities |
| Detco\PaxTheme\Model\Product | Magento\CatalogInventory\Model\Plugin\AfterProductLoad | 0 | afterLoad |
| Detco\PaxTheme\Model\Product | Magento\Swatches\Model\Plugin\Product | 0 | afterGetMediaAttributes |
| 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\AbstractType | Detco\PrintFields\Model\Product\Type\AbstractType | 0 | afterGetSku |
| Magento\Catalog\Model\Product\Type\Simple | Detco\PrintFields\Model\Product\Type\AbstractType | 0 | afterGetSku |
| Magento\ConfigurableProduct\Model\Product\Type\Configurable | Detco\PrintFields\Model\Product\Type\AbstractType | 0 | afterGetSku |
| Magento\ConfigurableProduct\Model\Product\Type\Configurable | Magento\Swatches\Model\Plugin\Configurable | 0 | afterGetUsedProductCollection |
| Magento\ConfigurableProduct\Model\Product\Type\Configurable | Magento\ConfigurableProduct\Model\Plugin\Frontend\UsedProductsCache | 0 | aroundGetUsedProducts |
| Magento\Catalog\Helper\Product | Mageplaza\Seo\Plugin\Helper\CanUseCanonicalTagForProducts | 0 | afterCanUseCanonicalTag |
| Magento\Catalog\Helper\Product | Mageplaza\SeoPro\Plugin\ProductHelper | 0 | afterCanUseCanonicalTag |
| Magento\Framework\Pricing\Render\PriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Catalog\Pricing\Render\FinalPriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable\Product\Collection | Magento\CatalogRuleConfigurable\Plugin\ConfigurableProduct\Model\ResourceModel\AddCatalogRulePrice | 0 | beforeLoad |
| Magento\ConfigurableProduct\Model\ResourceModel\Attribute\OptionSelectBuilderInterface | Interjar\ConfigurableChildVisibility\Plugin\Model\ResourceModel\Attribute\InStockOptionSelectBuilder | 0 | afterGetSelect |
| Magento\ConfigurableProduct\Model\ResourceModel\Attribute\OptionSelectBuilder | Interjar\ConfigurableChildVisibility\Plugin\Model\ResourceModel\Attribute\InStockOptionSelectBuilder | 0 | afterGetSelect |
| Interjar\ConfigurableChildVisibility\Pricing\Render\FinalPriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Detco\SwatchChange\Pricing\Render\FinalPriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Catalog\Model\Layer\Filter\Item | Mageplaza\SeoUrl\Plugin\Filter\Item | -1 | afterGetUrl |
| Magento\Catalog\Model\Layer\Filter\Item | Mageplaza\LayeredNavigation\Plugin\Model\Layer\Filter\Item | 1 | aroundGetUrl |
| Magento\Catalog\Model\Layer\Filter\Item | Mageplaza\SeoUrl\Plugin\Filter\Item | -1 | afterGetRemoveUrl |
| Magento\Catalog\Model\Layer\Filter\Item | Mageplaza\LayeredNavigation\Plugin\Model\Layer\Filter\Item | 1 | aroundGetRemoveUrl |
| Magento\Swatches\Block\LayeredNavigation\RenderLayered | Mageplaza\SeoUrl\Plugin\Filter\Swatch | -1 | afterBuildUrl |
| Magento\Swatches\Block\LayeredNavigation\RenderLayered | Mageplaza\LayeredNavigation\Plugin\Block\Swatches\RenderLayered | 1 | aroundBuildUrl |
| Magento\Swatches\Block\LayeredNavigation\RenderLayered | Mageplaza\LayeredNavigation\Plugin\Block\Swatches\RenderLayered | 1 | beforeSetSwatchFilter |
| Statistics | 254 queries in 85.03ms (average time: 0.33ms) - 2987 queries/second |
|---|---|
| 247 SELECT - 2 INSERT - 0 UPDATE - 0 DELETE - 0 TRANSACTION | |
| Longest | 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '132', '135', '159', '160', '161', '162', '173', '176', '209', '233', '241', '284', '285')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('76', '235', '242', '273')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('78', '121', '237', '238', '239')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('97', '123', '125', '126', '127', '128', '131', '133', '136', '156', '157', '165', '174', '177', '180', '186', '187', '202', '204', '218', '234', '236', '240', '250', '256', '259', '262', '266', '290')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) |
| (5.19ms) |
| # | SQL | Time |
|---|---|---|
| 0 | connect | 0.50ms |
| 1 | SET NAMES utf8 | 0.17ms |
| 2 | SELECT `store_website`.* FROM `store_website` | 0.26ms |
| 3 | SELECT `store_group`.* FROM `store_group` | 0.21ms |
| 4 | SELECT `store`.* FROM `store` | 0.18ms |
| 5 | SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash') | 0.23ms |
| 6 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('sports-medicine', 'sports-medicine/')) AND (`store_id` IN ('2')) | 0.22ms |
| 7 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/129', 'catalog/category/view/id/129/')) AND (`store_id` IN ('2')) | 0.24ms |
| 8 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` 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 ('catalog/category/view/id/129', 'catalog/category/view/id/129/')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.19ms |
| 9 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =129) | 0.22ms |
| 10 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 129) | 0.21ms |
| 11 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '129') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '129') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '129') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '129') 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 = '129') AND (attribute_id IN ('72')) AND (`store_id` IN ('2', 0))) ) AS `u` ORDER BY `store_id` ASC | 0.92ms |
| 12 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '129') LIMIT 1 | 0.20ms |
| 13 | SELECT `main_table`.* FROM `mageplaza_seorule_meta` AS `main_table` WHERE (`category_id` = '129') AND (`entity_type` = 'category') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`)))) ORDER BY sort_order ASC | 0.26ms |
| 14 | 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('129', '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.46ms |
| 15 | 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 (129, 2)) AND (t_d.attribute_id IN ('60', '63', '275')) 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 (129, 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 (129, 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 (129, 2)) AND (t_d.attribute_id IN ('71')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.02ms |
| 16 | SELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC | 0.21ms |
| 17 | SELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC | 0.22ms |
| 18 | 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.29ms |
| 19 | 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('129')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') | 0.40ms |
| 20 | 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 (129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.41ms |
| 21 | 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.58ms |
| 22 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('129')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.27ms |
| 23 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`target_path` IN ('catalog/category/view/id/129')) AND (`store_id` IN ('2')) | 0.37ms |
| 24 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_type` IN ('category')) AND (`entity_id` IN ('129')) AND (`store_id` IN ('2')) AND (`is_autogenerated` IN (1)) | 0.26ms |
| 25 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_type` IN ('category')) AND (`entity_id` IN ('129')) AND (`store_id` IN ('1')) AND (`is_autogenerated` IN (1)) | 0.25ms |
| 26 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` 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 ('category')) AND (url_rewrite.entity_id IN ('129')) AND (url_rewrite.store_id IN ('1')) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.28ms |
| 27 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id) | 0.21ms |
| 28 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.21ms |
| 29 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2) ORDER BY `catalog_category_entity`.`position` ASC | 0.31ms |
| 30 | SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.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 = d.entity_id WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.53ms |
| 31 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `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) 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) 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`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 1.05ms |
| 32 | 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, 4, 8, 14, 15, 48, 61, 62, 63, 64, 107, 128, 129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.58ms |
| 33 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id) | 0.16ms |
| 34 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.12ms |
| 35 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2) ORDER BY `catalog_category_entity`.`position` ASC | 0.28ms |
| 36 | SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` 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) INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.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 = d.entity_id WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.62ms |
| 37 | SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` 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) 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) 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) 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`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') ORDER BY `name` ASC | 0.96ms |
| 38 | 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 (62, 14, 8, 3, 4, 61, 15, 63, 128, 48, 64, 129, 107)) AND (t_d.attribute_id IN ('117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.44ms |
| 39 | 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`.`identifier`='porto_custom_menu_before') AND (is_active = 1) AND (cbs.store_id in (2, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.36ms |
| 40 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='3') | 0.20ms |
| 41 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '3') | 0.20ms |
| 42 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '3') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '3') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '3') 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 = '3') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.82ms |
| 43 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '3') LIMIT 1 | 0.19ms |
| 44 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='4') | 0.17ms |
| 45 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '4') | 0.11ms |
| 46 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '4') 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 = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.69ms |
| 47 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 48 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='62') | 0.11ms |
| 49 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '62') | 0.20ms |
| 50 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '62') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '62') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '62') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '62') 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 = '62') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.68ms |
| 51 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '62') LIMIT 1 | 0.10ms |
| 52 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='63') | 0.11ms |
| 53 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '63') | 0.11ms |
| 54 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '63') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '63') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '63') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '63') 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 = '63') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.70ms |
| 55 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '63') LIMIT 1 | 0.10ms |
| 56 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='8') | 0.09ms |
| 57 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '8') | 0.11ms |
| 58 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '8') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '8') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '8') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '8') 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 = '8') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.67ms |
| 59 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '8') LIMIT 1 | 0.10ms |
| 60 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='61') | 0.10ms |
| 61 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '61') | 0.11ms |
| 62 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '61') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '61') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '61') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '61') 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 = '61') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.71ms |
| 63 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '61') LIMIT 1 | 0.20ms |
| 64 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('61')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.24ms |
| 65 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='14') | 0.20ms |
| 66 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '14') | 0.11ms |
| 67 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '14') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '14') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '14') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '14') 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 = '14') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.65ms |
| 68 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '14') LIMIT 1 | 0.17ms |
| 69 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='15') | 0.18ms |
| 70 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '15') | 0.11ms |
| 71 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '15') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '15') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '15') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '15') 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 = '15') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.65ms |
| 72 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '15') LIMIT 1 | 0.10ms |
| 73 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='48') | 0.11ms |
| 74 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '48') | 0.11ms |
| 75 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '48') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '48') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '48') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '48') 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 = '48') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.66ms |
| 76 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '48') LIMIT 1 | 0.10ms |
| 77 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='107') | 0.11ms |
| 78 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '107') | 0.11ms |
| 79 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '107') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '107') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '107') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '107') 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 = '107') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.67ms |
| 80 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '107') LIMIT 1 | 0.10ms |
| 81 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='128') | 0.11ms |
| 82 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '128') | 0.11ms |
| 83 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '128') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '128') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '128') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '128') 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 = '128') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.60ms |
| 84 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '128') LIMIT 1 | 0.10ms |
| 85 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='64') | 0.11ms |
| 86 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '64') | 0.11ms |
| 87 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '64') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '64') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '64') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '64') 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 = '64') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.63ms |
| 88 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '64') LIMIT 1 | 0.10ms |
| 89 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='129') | 0.11ms |
| 90 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '129') | 0.11ms |
| 91 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '129') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '129') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '129') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '129') 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 = '129') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.62ms |
| 92 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '129') LIMIT 1 | 0.10ms |
| 93 | 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`.`identifier`='porto_custom_menu') AND (is_active = 1) AND (cbs.store_id in (2, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.24ms |
| 94 | SELECT `main_table`.* FROM `tax_class` AS `main_table` WHERE (`main_table`.`class_type` = 'PRODUCT') | 0.26ms |
| 95 | SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0) | 0.20ms |
| 96 | SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='5') | 0.10ms |
| 97 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.51ms |
| 98 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.46ms |
| 99 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('3')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.43ms |
| 100 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('4')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.45ms |
| 101 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('8')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.37ms |
| 102 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('9')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.37ms |
| 103 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('10')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.34ms |
| 104 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('11')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.37ms |
| 105 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('12')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.37ms |
| 106 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('13')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*')) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.40ms |
| 107 | SELECT `main_table`.* FROM `mageplaza_seocrosslinks_term` AS `main_table` WHERE (`status` = '1') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`)))) AND (FIND_IN_SET(1, `apply_for`)) ORDER BY sort_order ASC | 0.30ms |
| 108 | SELECT `main_table`.* FROM `cataloginventory_stock` AS `main_table` | 0.26ms |
| 109 | CREATE TEMPORARY TABLE `search_tmp_6428bc8661a432_87296273` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='search_tmp_6428bc8661a432_87296273' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci | 0.35ms |
| 110 | INSERT INTO `search_tmp_6428bc8661a432_87296273` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM ( SELECT DISTINCT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store2` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '2' WHERE (search_index.store_id = '2') AND (category_ids_index.category_id IN (129))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.62ms |
| 111 | SELECT `search_tmp_6428bc8661a432_87296273`.`entity_id`, `search_tmp_6428bc8661a432_87296273`.`score` FROM `search_tmp_6428bc8661a432_87296273` | 0.18ms |
| 112 | SELECT `e`.`attribute_set_id` FROM `catalog_product_entity` AS `e` WHERE (entity_id IN (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) GROUP BY `attribute_set_id` | 0.56ms |
| 113 | SELECT `main_table`.`attribute_code` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN('10')) GROUP BY `main_table`.`attribute_id` | 0.63ms |
| 114 | SELECT count(main_table.entity_id) AS `count`, MAX(min_price) AS `max`, MIN(min_price) AS `min`, STDDEV_SAMP(min_price) AS `std` FROM `catalog_product_index_price` AS `main_table` WHERE (main_table.entity_id in (select entity_id from search_tmp_6428bc8661a432_87296273)) AND (customer_group_id = 0) AND (main_table.website_id = '1') | 0.27ms |
| 115 | SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `catalog_product_index_price` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC | 0.29ms |
| 116 | SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `catalog_product_index_price` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC | 0.28ms |
| 117 | SELECT `main_table`.*, count(main_table.value) AS `count` FROM ( SELECT `main_table`.`category_id` AS `value` FROM `catalog_category_product_index_store2` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.product_id = entities.entity_id INNER JOIN `catalog_category_entity` AS `category` ON main_table.category_id = category.entity_id WHERE (main_table.store_id = '2') AND (`category`.`path` LIKE '1/2/129%') AND (`category`.`level` > '2')) AS `main_table` GROUP BY `value` | 0.29ms |
| 118 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id) | 0.22ms |
| 119 | SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) | 0.21ms |
| 120 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.20ms |
| 121 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 83) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.26ms |
| 122 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 156) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.20ms |
| 123 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 157) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.21ms |
| 124 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 187) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.21ms |
| 125 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='modulfixierung') AND (entity_type_id = :entity_type_id) | 0.15ms |
| 126 | SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) | 0.21ms |
| 127 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 255) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.27ms |
| 128 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 259) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.26ms |
| 129 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 262) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.28ms |
| 130 | SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM ( SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_6428bc8661a432_87296273` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 266) AND (main_table.store_id = '2' )) AS `main_table` GROUP BY `value` | 0.25ms |
| 131 | SELECT COUNT(*) FROM ( SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM ( SELECT DISTINCT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store2` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '2' WHERE (search_index.store_id = '2') AND (category_ids_index.category_id IN (129))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC) AS `core_select` | 0.42ms |
| 132 | CREATE TEMPORARY TABLE `search_tmp_6428bc86644c25_89953806` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='search_tmp_6428bc86644c25_89953806' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci | 0.28ms |
| 133 | INSERT INTO `search_tmp_6428bc86644c25_89953806` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) | 0.16ms |
| 134 | SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id) | 0.10ms |
| 135 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=129 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 `search_tmp_6428bc86644c25_89953806` AS `search_result` ON e.entity_id = search_result.entity_id | 0.24ms |
| 136 | SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=129 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')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `search_tmp_6428bc86644c25_89953806` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY `cat_index`.`position` asc, `e`.`entity_id` DESC, `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` DESC LIMIT 12 | 0.55ms |
| 137 | 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '132', '135', '159', '160', '161', '162', '173', '176', '209', '233', '241', '284', '285')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('76', '235', '242', '273')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('78', '121', '237', '238', '239')) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) 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 (5754, 5486, 5342, 4303, 4288, 4271, 3724, 3302, 3226)) AND (t_d.attribute_id IN ('97', '123', '125', '126', '127', '128', '131', '133', '136', '156', '157', '165', '174', '177', '180', '186', '187', '202', '204', '218', '234', '236', '240', '250', '256', '259', '262', '266', '290')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 5.19ms |
| 138 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` 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 ('5754', '5486', '5342', '4303', '4288', '4271', '3724', '3302', '3226')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.85ms |
| 139 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 5754) | 0.42ms |
| 140 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='129') | 0.22ms |
| 141 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '129') | 0.21ms |
| 142 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '129') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '129') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '129') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '129') 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 = '129') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.86ms |
| 143 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '129') LIMIT 1 | 0.21ms |
| 144 | SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='1') | 0.20ms |
| 145 | SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='5') | 0.20ms |
| 146 | ( SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '90034', '90034*', '9003*', '900*', '90*', '9*'))) UNION ( SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2' WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NOT NULL) AND ('90034' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.70ms |
| 147 | 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` = '156') AND (`main_table`.`option_id` IN('30')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 148 | 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` = '157') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 149 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 5486) | 0.23ms |
| 150 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.24ms |
| 151 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 152 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 153 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 154 | 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` = '156') AND (`main_table`.`option_id` IN('29')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.33ms |
| 155 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.31ms |
| 156 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 5342) | 0.20ms |
| 157 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.29ms |
| 158 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.31ms |
| 159 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 160 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 161 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 4303) | 0.19ms |
| 162 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 163 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 164 | 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` = '156') AND (`main_table`.`option_id` IN('25')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 165 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 166 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 167 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 168 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 4288) | 0.19ms |
| 169 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 170 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.26ms |
| 171 | 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` = '156') AND (`main_table`.`option_id` IN('25')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 172 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 173 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 174 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 175 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 4271) | 0.19ms |
| 176 | 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` = '156') AND (`main_table`.`option_id` IN('140')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 177 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 178 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 179 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 180 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.25ms |
| 181 | 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` = '157') AND (`main_table`.`option_id` IN('6')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 182 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 3724) | 0.19ms |
| 183 | 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` = '156') AND (`main_table`.`option_id` IN('25')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.21ms |
| 184 | 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` = '157') AND (`main_table`.`option_id` IN('7')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.21ms |
| 185 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 3302) | 0.21ms |
| 186 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.21ms |
| 187 | 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` = '157') AND (`main_table`.`option_id` IN('33')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.21ms |
| 188 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 3226) | 0.21ms |
| 189 | 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` = '156') AND (`main_table`.`option_id` IN('5')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 190 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 191 | 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` = '156') AND (`main_table`.`option_id` IN('4')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.21ms |
| 192 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.29ms |
| 193 | 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` = '156') AND (`main_table`.`option_id` IN('25')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 194 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 195 | 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` = '156') AND (`main_table`.`option_id` IN('24')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 196 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 197 | 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` = '156') AND (`main_table`.`option_id` IN('29')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 198 | 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` = '157') AND (`main_table`.`option_id` IN('31')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.28ms |
| 199 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '5486'))))) ORDER BY position ASC | 0.32ms |
| 200 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5829, 3567)) AND (def.store_id = 0) | 0.22ms |
| 201 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 5486) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.49ms |
| 202 | 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` = '156') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.54ms |
| 203 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 5486) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.36ms |
| 204 | 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` = '157') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.37ms |
| 205 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('5486')) | 0.46ms |
| 206 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '5342'))))) ORDER BY position ASC | 0.23ms |
| 207 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5832, 3300)) AND (def.store_id = 0) | 0.26ms |
| 208 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 5342) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.37ms |
| 209 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 5342) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.35ms |
| 210 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('5342')) | 0.33ms |
| 211 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '4303'))))) ORDER BY position ASC | 0.22ms |
| 212 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5784, 3073)) AND (def.store_id = 0) | 0.25ms |
| 213 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4303) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.38ms |
| 214 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4303) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.37ms |
| 215 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('4303')) | 0.40ms |
| 216 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '4288'))))) ORDER BY position ASC | 0.20ms |
| 217 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5834, 3468)) AND (def.store_id = 0) | 0.22ms |
| 218 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4288) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.38ms |
| 219 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4288) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.37ms |
| 220 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('4288')) | 0.33ms |
| 221 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '4271'))))) ORDER BY position ASC | 0.13ms |
| 222 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5833, 4594)) AND (def.store_id = 0) | 0.26ms |
| 223 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4271) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.38ms |
| 224 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 4271) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.37ms |
| 225 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('4271')) | 0.36ms |
| 226 | SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (((((`product_id` = '3226'))))) ORDER BY position ASC | 0.24ms |
| 227 | SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 2 WHERE (def.product_super_attribute_id IN (5814, 2635)) AND (def.store_id = 0) | 0.26ms |
| 228 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 3226) AND (attribute.attribute_id = '156') ORDER BY `attribute_option`.`sort_order` ASC | 0.42ms |
| 229 | SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label` FROM `catalog_product_super_attribute` AS `super_attribute` INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id INNER JOIN `catalog_product_entity_int` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0 LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = entity_value.value WHERE (super_attribute.product_id = 3226) AND (attribute.attribute_id = '157') ORDER BY `attribute_option`.`sort_order` ASC | 0.43ms |
| 230 | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.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 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 2) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (link_table.parent_id in ('3226')) | 0.36ms |
| 231 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '129') | 0.20ms |
| 232 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/129/%') ORDER BY `catalog_category_entity`.`position` ASC | 0.22ms |
| 233 | SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.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 = d.entity_id WHERE (`e`.`entity_id` = '') AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.23ms |
| 234 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `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) 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) 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`.`entity_id` = '') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 0.31ms |
| 235 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2') | 0.10ms |
| 236 | SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '2') | 0.20ms |
| 237 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '2') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) 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 = '2') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) 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 = '2') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) 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 = '2') 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 = '2') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u` ORDER BY `store_id` ASC | 0.76ms |
| 238 | SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '2') LIMIT 1 | 0.19ms |
| 239 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.17ms |
| 240 | SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC | 0.31ms |
| 241 | SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.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 = d.entity_id WHERE (`e`.`entity_id` IN('3', '117', '65', '120', '127', '66', '67', '68', '108', '4', '69', '126', '71', '70', '72', '73', '74', '75', '7', '62', '76', '77', '78', '79', '63', '81', '80', '82', '83', '8', '88', '89', '90', '91', '61', '13', '14', '15', '98', '97', '96', '103', '102', '101', '100', '99', '48', '87', '86', '84', '85', '105', '107', '111', '112', '113', '128', '64', '94', '92', '93', '95', '129', '123', '106', '121', '52', '49', '55', '56', '57', '58', '59', '60', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.66ms |
| 242 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `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) 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) 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`.`entity_id` IN('3', '117', '65', '120', '127', '66', '67', '68', '108', '4', '69', '126', '71', '70', '72', '73', '74', '75', '7', '62', '76', '77', '78', '79', '63', '81', '80', '82', '83', '8', '88', '89', '90', '91', '61', '13', '14', '15', '98', '97', '96', '103', '102', '101', '100', '99', '48', '87', '86', '84', '85', '105', '107', '111', '112', '113', '128', '64', '94', '92', '93', '95', '129', '123', '106', '121', '52', '49', '55', '56', '57', '58', '59', '60', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('72', '74', '7', '78', '81', '83', '13', '102', '101', '100', '99', '105', '94', '123', '106', '121', '49', '60', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 1.42ms |
| 243 | 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, 4, 8, 14, 15, 48, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 73, 75, 76, 77, 79, 80, 82, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 95, 96, 97, 98, 103, 107, 108, 111, 112, 113, 117, 120, 126, 127, 128, 129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.33ms |
| 244 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('2')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.22ms |
| 245 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` 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 ('2')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (2)) AND (relation.category_id IS NULL) | 0.25ms |
| 246 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('61')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.23ms |
| 247 | 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.28ms |
| 248 | 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('')) ORDER BY `e`.`position` ASC | 0.27ms |
| 249 | 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` = '157') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.40ms |
| 250 | SELECT `main_table`.* FROM `eav_attribute_option_swatch` AS `main_table` WHERE (`main_table`.`option_id` IN(7, 6, 31, 33)) | 0.25ms |
| 251 | 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` = '156') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.55ms |
| 252 | SELECT `main_table`.* FROM `eav_attribute_option_swatch` AS `main_table` WHERE (`main_table`.`option_id` IN(140, 5, 25, 24, 29, 30)) | 0.22ms |
| 253 | 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`.`identifier`='porto_category_side_custom_block') AND (is_active = 1) AND (cbs.store_id in (2, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.32ms |
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.17)
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.
