Català
English
Te recomendamos
Toggle Nav
Buscar
Ir al contenido
-
¿Ya está registrado? Identifíquese
Productos exclusivos
Precios especiales
Condiciones especiales
Mejor experiencia
-
-
¿No está registrado? Pulsa aquí
- Todas las ventajas por ser cliente
Todas las categorias
Secciones
Info 
Design 
Profile 
Queries 
Logs 
Actions | Base Url | https://semicstore-pre.semic.es/ |
|---|---|
| Path Info | |
| Module Name | cms |
| Controller | index |
| Action | index |
| Full Action | cms_index_index |
| Route | cms |
| Area | frontend |
| Client IP | 216.73.216.159 |
| Magento | 2.3.6-p1 |
| Mage Mode | developer |
| Backend | https://semicstore-pre.semic.es/admin_e9yr2c |
| Website Id | 1 |
|---|---|
| Website Name | Semic Store |
| Store Id | 1 |
| Tienda Nombre | Español |
| Store Code | es |
Please wait.
Content is loading ...
Environment
| Variable | Value |
|---|---|
| USER | www-data |
| HOME | /var/www |
| COMPOSER_HOME | /opt/magento/semicstore-pre.semic.es/var/composer_home |
PHP Variables
| Variable | Value |
|---|---|
| $_SERVER['USER'] | www-data |
| $_SERVER['HOME'] | /var/www |
| $_SERVER['SCRIPT_NAME'] | /index.php |
| $_SERVER['REQUEST_URI'] | / |
| $_SERVER['QUERY_STRING'] | no value |
| $_SERVER['REQUEST_METHOD'] | GET |
| $_SERVER['SERVER_PROTOCOL'] | HTTP/2.0 |
| $_SERVER['GATEWAY_INTERFACE'] | CGI/1.1 |
| $_SERVER['REMOTE_PORT'] | 16699 |
| $_SERVER['SCRIPT_FILENAME'] | //opt/magento/semicstore-pre.semic.es/index.php |
| $_SERVER['SERVER_ADMIN'] | [no address given] |
| $_SERVER['CONTEXT_DOCUMENT_ROOT'] | /opt/magento/semicstore-pre.semic.es |
| $_SERVER['CONTEXT_PREFIX'] | no value |
| $_SERVER['REQUEST_SCHEME'] | https |
| $_SERVER['DOCUMENT_ROOT'] | /opt/magento/semicstore-pre.semic.es |
| $_SERVER['REMOTE_ADDR'] | 216.73.216.159 |
| $_SERVER['SERVER_PORT'] | 443 |
| $_SERVER['SERVER_ADDR'] | 10.0.0.10 |
| $_SERVER['SERVER_NAME'] | semicstore-pre.semic.es |
| $_SERVER['SERVER_SOFTWARE'] | Apache/2.4.65 (Ubuntu) |
| $_SERVER['SERVER_SIGNATURE'] | <address>Apache/2.4.65 (Ubuntu) Server at semicstore-pre.semic.es Port 443</address> |
| $_SERVER['PATH'] | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin |
| $_SERVER['HTTP_X_FORWARDED_PROTO'] | https |
| $_SERVER['HTTP_HOST'] | semicstore-pre.semic.es |
| $_SERVER['HTTP_ACCEPT_ENCODING'] | gzip, br, zstd, deflate |
| $_SERVER['HTTP_USER_AGENT'] | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| $_SERVER['HTTP_ACCEPT'] | */* |
| $_SERVER['proxy-nokeepalive'] | 1 |
| $_SERVER['SSL_SESSION_RESUMED'] | Initial |
| $_SERVER['SSL_SESSION_ID'] | de06291dc164aab70a5afbac96306b315b0a5afdf5ccd3431527a71fba2de919 |
| $_SERVER['SSL_SERVER_A_SIG'] | sha256WithRSAEncryption |
| $_SERVER['SSL_SERVER_A_KEY'] | rsaEncryption |
| $_SERVER['SSL_SERVER_I_DN'] | CN=Sectigo RSA Organization Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB |
| $_SERVER['SSL_SERVER_S_DN'] | CN=*.semic.es,O=SERVICIOS MICROINFORMATICA\, S.A.,ST=Cataluña,C=ES |
| $_SERVER['SSL_SERVER_V_END'] | Apr 4 23:59:59 2026 GMT |
| $_SERVER['SSL_SERVER_V_START'] | Mar 4 00:00:00 2025 GMT |
| $_SERVER['SSL_SERVER_M_SERIAL'] | F711FD6095AE9D7DF3C145E8E67333F6 |
| $_SERVER['SSL_SERVER_M_VERSION'] | 3 |
| $_SERVER['SSL_CLIENT_VERIFY'] | NONE |
| $_SERVER['SSL_CIPHER_ALGKEYSIZE'] | 256 |
| $_SERVER['SSL_CIPHER_USEKEYSIZE'] | 256 |
| $_SERVER['SSL_CIPHER_EXPORT'] | false |
| $_SERVER['SSL_CIPHER'] | TLS_AES_256_GCM_SHA384 |
| $_SERVER['SSL_COMPRESS_METHOD'] | NULL |
| $_SERVER['SSL_SECURE_RENEG'] | true |
| $_SERVER['SSL_PROTOCOL'] | TLSv1.3 |
| $_SERVER['SSL_VERSION_LIBRARY'] | OpenSSL/3.0.2 |
| $_SERVER['SSL_VERSION_INTERFACE'] | mod_ssl/2.4.65 |
| $_SERVER['SSL_SERVER_SAN_DNS_1'] | semic.es |
| $_SERVER['SSL_SERVER_SAN_DNS_0'] | *.semic.es |
| $_SERVER['SSL_SERVER_I_DN_CN'] | Sectigo RSA Organization Validation Secure Server CA |
| $_SERVER['SSL_SERVER_I_DN_O'] | Sectigo Limited |
| $_SERVER['SSL_SERVER_I_DN_L'] | Salford |
| $_SERVER['SSL_SERVER_I_DN_ST'] | Greater Manchester |
| $_SERVER['SSL_SERVER_I_DN_C'] | GB |
| $_SERVER['SSL_SERVER_S_DN_CN'] | *.semic.es |
| $_SERVER['SSL_SERVER_S_DN_O'] | SERVICIOS MICROINFORMATICA, S.A. |
| $_SERVER['SSL_SERVER_S_DN_ST'] | Cataluña |
| $_SERVER['SSL_SERVER_S_DN_C'] | ES |
| $_SERVER['SSL_TLS_SNI'] | semicstore-pre.semic.es |
| $_SERVER['HTTPS'] | on |
| $_SERVER['H2_STREAM_TAG'] | 703003-133-1 |
| $_SERVER['H2_STREAM_ID'] | 1 |
| $_SERVER['H2_PUSHED_ON'] | no value |
| $_SERVER['H2_PUSHED'] | no value |
| $_SERVER['H2_PUSH'] | off |
| $_SERVER['H2PUSH'] | off |
| $_SERVER['HTTP2'] | on |
| $_SERVER['MAGE_PROFILER'] | html |
| $_SERVER['MAGE_DEBUG_SHOW_ARGS'] | 1 |
| $_SERVER['HTTP_AUTHORIZATION'] | no value |
| $_SERVER['FCGI_ROLE'] | RESPONDER |
| $_SERVER['PHP_SELF'] | /index.php |
| $_SERVER['REQUEST_TIME_FLOAT'] | 1766277895.8162 |
| $_SERVER['REQUEST_TIME'] | 1766277895 |
Please wait.
Content is loading ...
| Handles | default cms_index_index cms_page_view cms_index_index_id_home-collectives-dual |
|---|
| Blocks hierarchy |
|
|---|
| Block | Call Number |
|---|---|
| Magento\Directory\Block\Currency | 2 |
| Magento\Framework\View\Element\Template | 15 |
| Magento\Framework\View\Element\Js\Components | 10 |
| Magento\RequireJs\Block\Html\Head\Config | 1 |
| Magento\Framework\View\Element\Js\Cookie | 2 |
| Magento\Theme\Block\Html\Notices | 1 |
| Magento\Customer\Block\Account\Navigation | 1 |
| Magento\Theme\Block\Html\Header\Logo | 1 |
| Magento\Theme\Block\Html\Topmenu\Interceptor | 1 |
| Magento\Framework\View\Element\Text | 1 |
| Magento\Store\Block\Switcher | 3 |
| Magento\Theme\Block\Html\Breadcrumbs | 1 |
| Semic\Colectivos\Block\Html\CustomTitle | 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\AuthorizationLink | 1 |
| Magento\Customer\Block\Account\AuthenticationPopup\Interceptor | 2 |
| Magento\Customer\Block\SectionConfig | 1 |
| Magento\Customer\Block\CustomerData | 1 |
| Magento\Customer\Block\CustomerScopeData | 1 |
| Magento\Framework\Pricing\Render\RendererPool | 2 |
| Magento\Framework\Pricing\Render | 1 |
| Magento\Catalog\Block\FrontendStorageManager | 1 |
| Smartwave\Porto\Block\Template | 6 |
| 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 |
| ADM\QuickDevBar\Block\Toolbar | 1 |
| ADM\QuickDevBar\Block\Tab\Wrapper | 5 |
| ADM\QuickDevBar\Block\Tab\Panel | 3 |
| 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\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 |
| Amasty\Fpc\Block\Status | 1 |
| Amasty\Fpc\Block\Tracking | 1 |
| Ebizmarts\MailChimp\Block\Mailchimpjs | 1 |
| Ebizmarts\MailChimp\Block\Catcher | 1 |
| MagePal\GoogleTagManager\Block\GtmCode | 1 |
| MagePal\GoogleTagManager\Block\DataLayer | 1 |
| Mageplaza\Smtp\Block\Script | 1 |
| Mageplaza\SocialLogin\Block\Css | 1 |
| Mageplaza\SocialLogin\Block\Popup | 2 |
| Mageplaza\SocialLogin\Block\Form\Login | 1 |
| Mageplaza\SocialLogin\Block\Popup\Social | 1 |
| Magento\Captcha\Block\Captcha | 3 |
| Mageplaza\SocialLogin\Block\Form\Register | 1 |
| Semic\IQuote\Block\Data | 1 |
| Semic\MultiNIF\Block\Multinif | 1 |
| Semic\PreventPromoDelete\Block\Config | 1 |
| Semic\Sorteos\Block\HeaderLink | 1 |
| Smartwave\Megamenu\Block\Topmenu | 1 |
| Webkul\MultiWishlist\Block\Link | 1 |
| Webkul\MultiWishlist\Block\Cms | 2 |
| Magento\Newsletter\Block\Subscribe | 2 |
| Magento\Msrp\Block\Popup | 1 |
| Magento\Catalog\Block\ShortcutButtons | 1 |
| Magento\Paypal\Block\Bml\Banners | 1 |
| Develodesign\Punchout\Block\CustomerRefresh | 1 |
| Semic\Colectivos\Block\Colectivo | 1 |
| Magento\Cms\Block\Page | 1 |
| Magento\GoogleOptimizer\Block\Code\Page | 1 |
| Semic\CmsCanonical\Helper\Canonical | 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 | 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 | mpbettermaintenance_redirect | 1 | Mageplaza\BetterMaintenance\Observer\Redirect |
| controller_action_predispatch | punchout_prepare_permissions | 1 | Punchout\Gateway\Observer\Permission |
| controller_action_predispatch | punchout_prepare_common | 1 | Punchout\Gateway\Observer\Common |
| magento_cms_api_data_pageinterface_load_after | legacy_model_cms_page_after_load | 1 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| layout_load_before | punchoutout_order_customer_navigation_link | 1 | Develodesign\Punchout\Observer\RemoveOrderLink |
| layout_load_before | set_utm_cookie | 1 | Magedelight\UTMTracker\Observer\FrontController |
| layout_load_before | punchout_prepare_layout | 1 | Punchout\Gateway\Observer\Layout |
| layout_load_before | add_layout_handles | 1 | Semic\Colectivos\Observer\AddHandles |
| layout_generate_blocks_after | remove_block | 1 | Smartwave\Megamenu\Plugin\RemoveBlock |
| layout_generate_blocks_after | persistent | 1 | Magento\Persistent\Observer\ApplyPersistentDataObserver |
| layout_generate_blocks_after | semic_add_body_class | 1 | Semic\Colectivos\Observer\AddBodyClassObserver |
| 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 | 94 | Magento\PageCache\Observer\ProcessLayoutRenderElement |
| core_layout_render_element | amasty_gdprcookie_layout_render | 94 | Amasty\GdprCookie\Observer\ProcessLayoutRenderElement |
| magento_cms_api_data_blockinterface_load_after | legacy_model_cms_block_after_load | 14 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| magento_salesrule_api_data_ruleinterface_load_after | legacy_model_load | 3 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| magento_catalog_api_data_productinterface_load_after | legacy_model_load | 19 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_product_load_after | inventory | 19 | Magento\CatalogInventory\Observer\AddInventoryDataObserver |
List only events dispatched when Magento generate this page
| Event | Data | Call Number |
|---|---|---|
| model_load_before |
| 28 |
| core_abstract_load_before |
| 27 |
| model_load_after |
| 64 |
| core_abstract_load_after |
| 27 |
| customer_session_init |
| 12 |
| core_collection_abstract_load_before |
| 49 |
| store_collection_load_before |
| 2 |
| core_collection_abstract_load_after |
| 49 |
| store_collection_load_after |
| 2 |
| customer_load_before |
| 1 |
| controller_action_predispatch |
| 1 |
| controller_action_predispatch_cms |
| 1 |
| controller_action_predispatch_cms_index_index |
| 1 |
| entity_manager_load_before |
| 37 |
| magento_cms_api_data_pageinterface_load_before |
| 1 |
| magento_cms_api_data_pageinterface_load_after |
| 1 |
| cms_page_load_after |
| 1 |
| entity_manager_load_after |
| 37 |
| cms_page_render |
| 1 |
| layout_load_before |
| 1 |
| layout_generate_blocks_before |
| 1 |
| core_layout_block_create_after |
| 132 |
| layout_generate_blocks_after |
| 1 |
| controller_action_postdispatch_cms_index_index |
| 1 |
| controller_action_postdispatch_cms |
| 1 |
| controller_action_postdispatch |
| 1 |
| layout_render_before | 1 | |
| layout_render_before_cms_index_index | 1 | |
| view_block_abstract_to_html_before |
| 185 |
| view_block_abstract_to_html_after |
| 181 |
| core_layout_render_element |
| 94 |
| magento_cms_api_data_blockinterface_load_before |
| 14 |
| magento_cms_api_data_blockinterface_load_after |
| 14 |
| cms_block_load_after |
| 14 |
| eav_collection_abstract_load_before |
| 3 |
| catalog_product_collection_load_after |
| 3 |
| magento_salesrule_api_data_ruleinterface_load_before |
| 3 |
| magento_salesrule_api_data_ruleinterface_load_after |
| 3 |
| salesrule_rule_load_after |
| 3 |
| catalog_product_is_salable_before |
| 38 |
| catalog_product_is_salable_after |
| 38 |
| abstract_search_result_load_before |
| 38 |
| abstract_search_result_load_after |
| 38 |
| magento_catalog_api_data_productinterface_load_before |
| 19 |
| magento_catalog_api_data_productinterface_load_after |
| 19 |
| catalog_product_load_after |
| 19 |
| Collection | Call Number |
|---|---|
| Magento\Store\Model\ResourceModel\Store\Collection | 2 |
| Magento\Store\Model\ResourceModel\Group\Collection | 1 |
| Semic\Sliders\Model\ResourceModel\Slider\Collection | 24 |
| Amasty\BannersLite\Model\ResourceModel\Banner\Collection | 3 |
| Magento\Catalog\Model\ResourceModel\Product\Option\Collection | 19 |
| Event | Call Number |
|---|---|
| Magento\Framework\Flag | 1 |
| Magento\Customer\Model\Customer\Interceptor | 1 |
| Amasty\BannersLite\Model\Banner | 3 |
| Amasty\BannersLite\Model\BannerRule | 1 |
| Amasty\Promo\Model\Rule | 3 |
| Magento\Review\Model\Review\Summary | 19 |
| 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\Framework\Session\Generic | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Framework\Session\Generic | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\Framework\Session\Generic\Interceptor | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Session\Generic\Interceptor | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Framework\Session\Generic\Interceptor | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\Paypal\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Paypal\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Paypal\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\Paypal\Model\PayflowSession | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Paypal\Model\PayflowSession | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Paypal\Model\PayflowSession | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\Review\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Review\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Review\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\CatalogSearch\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\CatalogSearch\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\CatalogSearch\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| Magento\Catalog\Block\Product\AbstractProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ListProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ListProduct | Semic\SingleProduct\Block\Catalog\Product\ListProduct | 1 | afterGetLoadedProductCollection |
| Magento\Catalog\Block\Product\ListProduct\Interceptor | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ListProduct\Interceptor | Semic\SingleProduct\Block\Catalog\Product\ListProduct | 1 | afterGetLoadedProductCollection |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\CatalogSearch\Block\SearchResult\ListProduct | Semic\SingleProduct\Block\Catalog\Product\ListProduct | 1 | afterGetLoadedProductCollection |
| Magento\Wishlist\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Wishlist\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterStart |
| Magento\Wishlist\Model\Session | Develodesign\Punchout\Model\Cookie2\Framework\Session\GenericPlugin | 10 | afterRegenerateId |
| 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\Config | Develodesign\Punchout\Model\Cookie2\Framework\Session\ConfigPlugin | 10 | beforeSetCookieSecure |
| Magento\Framework\Session\Config | Develodesign\Punchout\Model\Cookie2\Framework\Session\ConfigPlugin | 10 | beforeSetCookieSameSite |
| Magento\Framework\Session\Config | Develodesign\Punchout\Model\Cookie2\Framework\Session\ConfigPlugin | 10 | afterGetCookieSecure |
| Magento\Framework\Session\Config | Develodesign\Punchout\Model\Cookie2\Framework\Session\ConfigPlugin | 10 | afterGetCookieSameSite |
| Magento\Framework\Session\Config | Develodesign\Punchout\Model\Cookie2\Framework\Session\ConfigPlugin | 10 | afterGetOptions |
| Magento\Framework\Session\SessionStartChecker | Magento\Paypal\Plugin\TransparentSessionChecker | 0 | afterCheck |
| Magento\Framework\DB\Adapter\AdapterInterface | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterCommit |
| Magento\Framework\DB\Adapter\AdapterInterface | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterRollBack |
| Magento\Framework\DB\Adapter\Pdo\Mysql | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterCommit |
| Magento\Framework\DB\Adapter\Pdo\Mysql | Magento\Framework\Model\ExecuteCommitCallbacks | 0 | afterRollBack |
| Magento\Framework\App\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\PageCache\Model\App\FrontController\BuiltinPlugin | Amasty\Fpc\Plugin\Holepunch\BlockGenerator | 0 | afterAroundDispatch |
| Magento\Framework\Event\ManagerInterface | ADM\QuickDevBar\Model\Plugin\Event\Manager | 1 | beforeDispatch |
| Magento\Framework\Event\Manager | ADM\QuickDevBar\Model\Plugin\Event\Manager | 1 | beforeDispatch |
| Magento\Store\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\Customer\Model\Session | Amasty\Fpc\Plugin\SessionManager | 0 | afterStart |
| Magento\UrlRewrite\Model\StorageInterface | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\UrlRewrite\Model\StorageInterface | Amasty\Fpc\Plugin\UrlRewrite\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 | Amasty\Fpc\Plugin\UrlRewrite\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 | Amasty\Fpc\Plugin\UrlRewrite\Storage | 0 | afterReplace |
| Magento\UrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | beforeDeleteByData |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Magento\CatalogUrlRewrite\Model\Category\Plugin\Storage | 0 | afterReplace |
| Magento\CatalogUrlRewrite\Model\Storage\DbStorage | Amasty\Fpc\Plugin\UrlRewrite\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\Url\SecurityInfo | Magento\Store\Url\Plugin\SecurityInfo | 0 | aroundIsSecure |
| Magento\Framework\Url\RouteParamsResolver | Magento\Store\Url\Plugin\RouteParamsResolver | 0 | beforeSetRouteParams |
| 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\Response\Http | Amasty\GdprCookie\Plugin\Response\Http | 0 | beforeSendResponse |
| Magento\Framework\App\Response\Http | Punchout\Gateway\Plugin\App\Response\HeaderPlugin | 100 | beforeSendHeaders |
| Magento\Framework\App\Response\Http | Develodesign\Punchout\Model\Response\HttpPlugin | 1000 | beforeSendHeaders |
| Magento\Framework\App\Request\CsrfValidator | Mageplaza\BetterMaintenance\Plugin\CsrfValidatorSkip | 0 | aroundValidate |
| Magento\Framework\App\Request\CsrfValidator | Punchout\Gateway\Plugin\App\Request\CsrfValidatorPlugin | 0 | aroundValidate |
| Magento\Framework\App\ActionInterface | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| Magento\Framework\App\Action\AbstractAction | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| 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\AbstractAction | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Magento\Framework\App\Action\Action | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| 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\Framework\App\Action\Action | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Semic\Colectivos\Preference\Controller\Index\Index | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Magento\Catalog\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| 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\Checkout\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| 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\View\Layout\Generator\Block | Amasty\Fpc\Plugin\Holepunch\BlockArguments | 0 | aroundCreateBlock |
| Magento\Backend\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\Message\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| Magento\Framework\View\Page\Config | Semic\Colectivos\Plugin\SetCollectiveMetaTags | 0 | afterSetMetaTitle |
| Magento\Framework\View\Page\Config | Semic\Colectivos\Plugin\SetCollectiveMetaTags | 0 | afterSetDescription |
| Magento\Framework\View\Page\Config | Semic\Colectivos\Plugin\SetCollectiveMetaTags | 0 | afterSetKeywords |
| 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\ResultInterface | Amasty\GdprCookie\Plugin\ProcessPageResult | 25 | aroundRenderResult |
| 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\Controller\AbstractResult | Amasty\GdprCookie\Plugin\ProcessPageResult | 25 | aroundRenderResult |
| 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\Layout | Amasty\GdprCookie\Plugin\ProcessPageResult | 25 | aroundRenderResult |
| Magento\Framework\View\Result\Page | Magento\Theme\Controller\Result\MessagePlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\PageCache\Model\Controller\Result\BuiltinPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Magento\PageCache\Model\Controller\Result\VarnishPlugin | 0 | afterRenderResult |
| Magento\Framework\View\Result\Page | Smartwave\Porto\Plugin\UpdateBodyClass | 0 | beforeRenderResult |
| Magento\Framework\View\Result\Page | Amasty\GdprCookie\Plugin\ProcessPageResult | 25 | aroundRenderResult |
| Magento\Framework\View\TemplateEngineFactory | Magento\Developer\Model\TemplateEngine\Plugin\DebugHints | 10 | afterCreate |
| Magento\Framework\View\TemplateEngine\Php | Amasty\Fpc\Plugin\Holepunch\TemplateRenderer | 0 | aroundRender |
| Magento\Framework\View\TemplateEngine\Php | Amasty\Base\Plugin\Framework\View\TemplateEngine\Php | 10 | beforeRender |
| Magento\Framework\View\TemplateEngine\Php | Amasty\GdprCookie\Plugin\Framework\View\TemplateEngine\PhpPlugin | 20 | beforeRender |
| Magento\Framework\View\Page\Config\Renderer | GDW\OpenGraph\Plugin\SeoRender | 0 | beforeRenderMetadata |
| Magento\Framework\View\Page\Config\Renderer | Amasty\AdvancedReview\Plugin\View\Page\Config\Renderer | 0 | beforeRenderAssets |
| Magento\Framework\View\Page\Config\Renderer | Amasty\Base\Plugin\Frontend\AddAssets | 0 | beforeRenderAssets |
| Magento\Framework\View\Page\Config\Renderer | Amasty\GdprCookie\Plugin\View\Page\Config\Renderer | 0 | beforeRenderAssets |
| 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\Customer\Block\Account\AuthenticationPopup | MSP\ReCaptcha\Plugin\Block\Account\AuthenticationPopupPlugin | 1 | afterGetJsLayout |
| 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\AbstractEntity | Mageplaza\Smtp\Plugin\DefaultAttributes | 0 | afterGetDefaultAttributes |
| 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\AbstractResource | Mageplaza\Smtp\Plugin\DefaultAttributes | 0 | afterGetDefaultAttributes |
| 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 | Mageplaza\Smtp\Plugin\DefaultAttributes | 0 | afterGetDefaultAttributes |
| 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\ResourceModel\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Framework\Api\DataObjectHelper | Amasty\Conditions\Plugin\Framework\Api\DataObjectHelperPlugin | 1 | beforePopulateWithArray |
| 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\Catalog\Pricing\Render\FinalPriceBox | Smartwave\Dailydeals\Plugin\FinalPricePlugin | 0 | beforeSetTemplate |
| Magento\Catalog\Model\Product | Magento\CatalogInventory\Model\Plugin\AfterProductLoad | 0 | afterLoad |
| Magento\Catalog\Model\Product | Magento\ConfigurableProduct\Model\Plugin\ProductIdentitiesExtender | 0 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Cms\Model\Plugin\Product | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Bundle\Model\Plugin\Frontend\Product | 100 | afterGetIdentities |
| Magento\Catalog\Model\Product | Magento\Swatches\Model\Plugin\Product | 0 | afterGetMediaAttributes |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGet |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGetList |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGetProductOptions |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterSave |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | aroundDelete |
| Magento\Catalog\Api\ProductCustomOptionRepositoryInterface | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | aroundDuplicate |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGet |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGetList |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterGetProductOptions |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | afterSave |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | aroundDelete |
| Magento\Catalog\Model\Product\Option\Repository | Vertex\Tax\Model\Plugin\CustomOptionFlexFieldExtensionAttributeHandler | 0 | aroundDuplicate |
| Magento\Catalog\Model\Product\Gallery\ReadHandler | Magento\ProductVideo\Model\Plugin\Catalog\Product\Gallery\ReadHandler | 0 | afterExecute |
| Magento\Catalog\Model\ResourceModel\Product\Gallery | Magento\ProductVideo\Model\Plugin\ExternalVideoResourceBackend | 0 | afterDuplicate |
| Magento\Catalog\Model\ResourceModel\Product\Gallery | Magento\ProductVideo\Model\Plugin\ExternalVideoResourceBackend | 0 | afterCreateBatchBaseSelect |
| Estadísticas | 414 queries in 975.32ms (average time: 2.36ms) - 424 queries/second |
|---|---|
| 411 SELECT - 0 INSERT - 0 UPDATE - 0 DELETE - 0 TRANSACTION | |
| Longest | SELECT DISTINCT e.entity_id, e.sku, spci.buy_without_stock, ( SELECT title FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS title, ( SELECT short_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS short_description, ( SELECT long_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS long_description, ( SELECT buy_without_stock_text FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS buy_without_stock_text, spcii.image_url, spcii.image_title, spidi.image_url AS image_url_default, spidi.image_title AS image_title_default, stock_status_index.stock_status AS is_salable FROM catalog_product_entity AS e INNER JOIN ( SELECT t1.* FROM semic_pim_collective_items t1 INNER JOIN ( SELECT magento_product_id, MIN( CASE WHEN is_published = 1 AND in_trash = 0 AND highlighted = 1 AND collective_id IN (1) THEN FIELD(collective_id, 1) ELSE 99999 END ) AS min_order FROM semic_pim_collective_items GROUP BY magento_product_id ) t2 ON t1.magento_product_id = t2.magento_product_id WHERE is_published = 1 AND in_trash = 0 AND highlighted = 1 AND collective_id IN (1) AND FIELD(t1.collective_id, 1) = t2.min_order ) spci ON e.entity_id = spci.magento_product_id LEFT JOIN semic_pim_collective_items_images AS spcii ON spcii.pim_collective_item_id = spci.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN semic_pim_items_default_images AS spidi ON spidi.pim_item_id = spci.pim_item_id AND spidi.entity_id = ( SELECT entity_id FROM semic_pim_items_default_images WHERE pim_item_id = spci.pim_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) 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 LIMIT 12 |
| (288.32ms) |
| # | SQL | Time |
|---|---|---|
| 0 | connect | 0.55ms |
| 1 | SET NAMES utf8 | 0.08ms |
| 2 | SELECT `store_website`.* FROM `store_website` | 0.16ms |
| 3 | SELECT `store_group`.* FROM `store_group` | 0.13ms |
| 4 | SELECT `store`.* FROM `store` | 0.13ms |
| 5 | SHOW TABLE STATUS LIKE 'session' | 3.25ms |
| 6 | SELECT `session`.`session_data` FROM `session` WHERE (session_id = :session_id) | 0.17ms |
| 7 | SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash') | 0.22ms |
| 8 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('', '/')) AND (`store_id` IN ('1')) | 0.27ms |
| 9 | 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 ('', '/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) | 0.27ms |
| 10 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.19ms |
| 11 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.18ms |
| 12 | SELECT related_collectives FROM semic_colectivos WHERE id_colectivo = 1 | 0.15ms |
| 13 | SELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC | 0.22ms |
| 14 | SELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC | 0.23ms |
| 15 | SELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='') | 0.21ms |
| 16 | SELECT codigo_colectivo_4G FROM semic_colectivos WHERE id_colectivo = '' | 0.18ms |
| 17 | SELECT `cms_page`.`page_id` FROM `cms_page` INNER JOIN `cms_page_store` ON cms_page.page_id = cms_page_store.page_id WHERE (`cms_page`.`identifier`='home-collectives-dual') AND (is_active = 1) AND (cms_page_store.store_id IN (0, 1)) ORDER BY `cms_page_store`.`store_id` DESC LIMIT 1 | 0.35ms |
| 18 | SELECT `t`.* FROM `cms_page` AS `t` WHERE (page_id = '244') | 0.21ms |
| 19 | SELECT `cps`.`store_id` FROM `cms_page_store` AS `cps` INNER JOIN `cms_page` AS `cp` ON cps.page_id = cp.page_id WHERE (cp.page_id = :page_id) | 0.23ms |
| 20 | SELECT `amasty_ampromo_rule`.`sku` FROM `amasty_ampromo_rule` WHERE (salesrule_id IN (142, 143)) | 0.42ms |
| 21 | 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`='top_promotional_block') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.39ms |
| 22 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.34ms |
| 23 | SELECT related_collectives, share_menu FROM semic_colectivos WHERE id_colectivo = :id_colectivo | 0.15ms |
| 24 | SELECT menu_json FROM semic_pim_collective_menu WHERE collective = :collective AND language_code = :lang | 0.18ms |
| 25 | 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_block_type_8') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.55ms |
| 26 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '136') | 0.20ms |
| 27 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 28 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.15ms |
| 29 | SELECT related_collectives, share_menu FROM semic_colectivos WHERE id_colectivo = :id_colectivo | 0.13ms |
| 30 | SELECT menu_json FROM semic_pim_collective_menu WHERE collective = :collective AND language_code = :lang | 0.14ms |
| 31 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.36ms |
| 32 | SELECT related_collectives, share_menu FROM semic_colectivos WHERE id_colectivo = :id_colectivo | 0.20ms |
| 33 | SELECT menu_json FROM semic_pim_collective_menu WHERE collective = :collective AND language_code = :lang | 0.38ms |
| 34 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.24ms |
| 35 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.16ms |
| 36 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.17ms |
| 37 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'MainSlider') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.28ms |
| 38 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'MainSlider') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.33ms |
| 39 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.20ms |
| 40 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.14ms |
| 41 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.15ms |
| 42 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'MainSlider') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.26ms |
| 43 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'MainSlider') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.31ms |
| 44 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.19ms |
| 45 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.15ms |
| 46 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.14ms |
| 47 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner1') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.28ms |
| 48 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 49 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.19ms |
| 50 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.14ms |
| 51 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.14ms |
| 52 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner2') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 53 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner2') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 54 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.18ms |
| 55 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.15ms |
| 56 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.15ms |
| 57 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner3') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.26ms |
| 58 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'TopBanner3') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.26ms |
| 59 | SELECT DISTINCT e.entity_id, e.sku, spci.buy_without_stock, ( SELECT title FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS title, ( SELECT short_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS short_description, ( SELECT long_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS long_description, ( SELECT buy_without_stock_text FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS buy_without_stock_text, spcii.image_url, spcii.image_title, spidi.image_url AS image_url_default, spidi.image_title AS image_title_default, stock_status_index.stock_status AS is_salable FROM catalog_product_entity AS e INNER JOIN ( SELECT t1.* FROM semic_pim_collective_items t1 INNER JOIN ( SELECT magento_product_id, MIN( CASE WHEN is_published = 1 AND in_trash = 0 AND recommended = 1 AND collective_id IN (1) THEN FIELD(collective_id, 1) ELSE 99999 END ) AS min_order FROM semic_pim_collective_items GROUP BY magento_product_id ) t2 ON t1.magento_product_id = t2.magento_product_id WHERE is_published = 1 AND in_trash = 0 AND recommended = 1 AND collective_id IN (1) AND FIELD(t1.collective_id, 1) = t2.min_order ) spci ON e.entity_id = spci.magento_product_id LEFT JOIN semic_pim_collective_items_images AS spcii ON spcii.pim_collective_item_id = spci.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN semic_pim_items_default_images AS spidi ON spidi.pim_item_id = spci.pim_item_id AND spidi.entity_id = ( SELECT entity_id FROM semic_pim_items_default_images WHERE pim_item_id = spci.pim_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) 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 LIMIT 10 | 250.22ms |
| 60 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` 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 WHERE (`e`.`entity_id` IN('1325579', '1330315', '1331899', '1331962', '1332450', '1339117', '1350877')) ORDER BY FIELD(e.entity_id, 1325579,1330315,1331899,1331962,1332450,1339117,1350877) | 0.60ms |
| 61 | 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 = 1 WHERE (e.entity_id IN (1325579, 1330315, 1331899, 1331962, 1332450, 1339117, 1350877)) AND (t_d.attribute_id IN ('5109', '93', '4838', '5093', '131', '128', '83', '5050', '5108', '91', '117', '120', '115', '175', '121', '4824', '4489', '118', '97', '5051', '5054', '140', '134', '5213', '99', '119')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_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 = 1 WHERE (e.entity_id IN (1325579, 1330315, 1331899, 1331962, 1332450, 1339117, 1350877)) AND (t_d.attribute_id IN ('171', '114', '100', '116', '5045', '173', '172', '96', '132', '87', '109', '2333', '130', '5211', '86', '84', '170', '123', '73', '106', '104', '161', '160', '129', '88', '110', '5052', '5053', '5212', '133', '89', '111', '5214', '126', '127', '174')) 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 = 1 WHERE (e.entity_id IN (1325579, 1330315, 1331899, 1331962, 1332450, 1339117, 1350877)) AND (t_d.attribute_id IN ('5225', '162', '163', '103', '75', '85', '5106', '76')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1325579, 1330315, 1331899, 1331962, 1332450, 1339117, 1350877)) AND (t_d.attribute_id IN ('81', '98', '122', '77', '78', '5055', '92', '82')) 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 = 1 WHERE (e.entity_id IN (1325579, 1330315, 1331899, 1331962, 1332450, 1339117, 1350877)) AND (t_d.attribute_id IN ('101', '102', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 5.65ms |
| 62 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.25ms |
| 63 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.19ms |
| 64 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.14ms |
| 65 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.18ms |
| 66 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.15ms |
| 67 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='193') | 0.14ms |
| 68 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='194') | 0.12ms |
| 69 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='195') | 0.14ms |
| 70 | SELECT `amasty_banners_lite_rule`.* FROM `amasty_banners_lite_rule` WHERE (`amasty_banners_lite_rule`.`salesrule_id`='79') | 0.19ms |
| 71 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.18ms |
| 72 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.16ms |
| 73 | 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 ('1325579')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.35ms |
| 74 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1325579') AND (store_id = 0) | 0.22ms |
| 75 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1325579')) | 0.30ms |
| 76 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1325579) | 0.18ms |
| 77 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1325579) | 0.19ms |
| 78 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1325579') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1325579') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1325579') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1325579') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1325579') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.14ms |
| 79 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1325579') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.47ms |
| 80 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1325579') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.51ms |
| 81 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1325579) | 0.20ms |
| 82 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1325579) | 0.17ms |
| 83 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1325579') ORDER BY `qty` ASC | 0.20ms |
| 84 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1325579) | 0.16ms |
| 85 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1325579')) AND (`main_table`.`website_id` = '0') | 0.29ms |
| 86 | 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 ('1330315')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.32ms |
| 87 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1330315') AND (store_id = 0) | 0.25ms |
| 88 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1330315')) | 0.28ms |
| 89 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1330315) | 0.19ms |
| 90 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1330315) | 0.18ms |
| 91 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1330315') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1330315') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1330315') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1330315') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1330315') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.27ms |
| 92 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1330315') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.41ms |
| 93 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1330315') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.46ms |
| 94 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1330315) | 0.19ms |
| 95 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1330315) | 0.18ms |
| 96 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1330315') ORDER BY `qty` ASC | 0.22ms |
| 97 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1330315) | 0.20ms |
| 98 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1330315')) AND (`main_table`.`website_id` = '0') | 0.27ms |
| 99 | 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 ('1331899')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.32ms |
| 100 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1331899') AND (store_id = 0) | 0.22ms |
| 101 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331899')) | 0.26ms |
| 102 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1331899) | 0.15ms |
| 103 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1331899) | 0.15ms |
| 104 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1331899') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1331899') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1331899') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1331899') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1331899') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.19ms |
| 105 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1331899') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 106 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1331899') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.42ms |
| 107 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331899) | 0.13ms |
| 108 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1331899) | 0.15ms |
| 109 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1331899') ORDER BY `qty` ASC | 0.20ms |
| 110 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331899) | 0.17ms |
| 111 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331899')) AND (`main_table`.`website_id` = '0') | 0.25ms |
| 112 | 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 ('1331962')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.31ms |
| 113 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1331962') AND (store_id = 0) | 0.18ms |
| 114 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331962')) | 0.29ms |
| 115 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1331962) | 0.17ms |
| 116 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1331962) | 0.18ms |
| 117 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1331962') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1331962') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1331962') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1331962') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1331962') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.11ms |
| 118 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1331962') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 119 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1331962') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.46ms |
| 120 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331962) | 0.19ms |
| 121 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1331962) | 0.19ms |
| 122 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1331962') ORDER BY `qty` ASC | 0.22ms |
| 123 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331962) | 0.18ms |
| 124 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331962')) AND (`main_table`.`website_id` = '0') | 0.27ms |
| 125 | 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 ('1332450')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.36ms |
| 126 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1332450') AND (store_id = 0) | 0.22ms |
| 127 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332450')) | 0.28ms |
| 128 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1332450) | 0.17ms |
| 129 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1332450) | 0.16ms |
| 130 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1332450') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1332450') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1332450') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1332450') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1332450') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.07ms |
| 131 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1332450') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 132 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1332450') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 133 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332450) | 0.18ms |
| 134 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1332450) | 0.16ms |
| 135 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1332450') ORDER BY `qty` ASC | 0.20ms |
| 136 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332450) | 0.16ms |
| 137 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332450')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 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_id IN ('1339117')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.30ms |
| 139 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1339117') AND (store_id = 0) | 0.20ms |
| 140 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1339117')) | 0.25ms |
| 141 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1339117) | 0.17ms |
| 142 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1339117) | 0.15ms |
| 143 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1339117') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1339117') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1339117') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1339117') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1339117') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 1.97ms |
| 144 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1339117') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 145 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1339117') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 146 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1339117) | 0.18ms |
| 147 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1339117) | 0.16ms |
| 148 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1339117') ORDER BY `qty` ASC | 0.19ms |
| 149 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1339117) | 0.16ms |
| 150 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1339117')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 151 | 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 ('1350877')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.32ms |
| 152 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1350877') AND (store_id = 0) | 0.19ms |
| 153 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1350877')) | 0.25ms |
| 154 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1350877) | 0.16ms |
| 155 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1350877) | 0.15ms |
| 156 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1350877') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1350877') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1350877') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1350877') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1350877') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.02ms |
| 157 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1350877') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 158 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1350877') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.44ms |
| 159 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1350877) | 0.18ms |
| 160 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1350877) | 0.17ms |
| 161 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1350877') ORDER BY `qty` ASC | 0.20ms |
| 162 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1350877) | 0.16ms |
| 163 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1350877')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 164 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.17ms |
| 165 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.12ms |
| 166 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.14ms |
| 167 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner1') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.27ms |
| 168 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.26ms |
| 169 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.17ms |
| 170 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.13ms |
| 171 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.14ms |
| 172 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner2') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.27ms |
| 173 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner2') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.27ms |
| 174 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.17ms |
| 175 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.11ms |
| 176 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.12ms |
| 177 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner3') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 178 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner3') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.23ms |
| 179 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.17ms |
| 180 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.13ms |
| 181 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.13ms |
| 182 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner4') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 183 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner4') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.23ms |
| 184 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.15ms |
| 185 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.11ms |
| 186 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.11ms |
| 187 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner5') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.26ms |
| 188 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner5') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.24ms |
| 189 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.18ms |
| 190 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.13ms |
| 191 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.12ms |
| 192 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner6') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.24ms |
| 193 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'BottomBanner6') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.24ms |
| 194 | SELECT DISTINCT e.entity_id, e.sku, spci.buy_without_stock, ( SELECT title FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS title, ( SELECT short_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS short_description, ( SELECT long_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS long_description, ( SELECT buy_without_stock_text FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS buy_without_stock_text, spcii.image_url, spcii.image_title, spidi.image_url AS image_url_default, spidi.image_title AS image_title_default, stock_status_index.stock_status AS is_salable FROM catalog_product_entity AS e INNER JOIN ( SELECT t1.* FROM semic_pim_collective_items t1 INNER JOIN ( SELECT magento_product_id, MIN( CASE WHEN is_published = 1 AND in_trash = 0 AND in_promotion = 1 AND collective_id IN (1) THEN FIELD(collective_id, 1) ELSE 99999 END ) AS min_order FROM semic_pim_collective_items GROUP BY magento_product_id ) t2 ON t1.magento_product_id = t2.magento_product_id WHERE is_published = 1 AND in_trash = 0 AND in_promotion = 1 AND collective_id IN (1) AND FIELD(t1.collective_id, 1) = t2.min_order ) spci ON e.entity_id = spci.magento_product_id LEFT JOIN semic_pim_collective_items_images AS spcii ON spcii.pim_collective_item_id = spci.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN semic_pim_items_default_images AS spidi ON spidi.pim_item_id = spci.pim_item_id AND spidi.entity_id = ( SELECT entity_id FROM semic_pim_items_default_images WHERE pim_item_id = spci.pim_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) 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 LIMIT 12 | 287.49ms |
| 195 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` 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 WHERE (`e`.`entity_id` IN('1331971', '1332549', '1332589', '1332667', '1333842', '1339113', '1374750')) ORDER BY FIELD(e.entity_id, 1331971,1332549,1332589,1332667,1333842,1339113,1374750) | 0.40ms |
| 196 | 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 = 1 WHERE (e.entity_id IN (1331971, 1332549, 1332589, 1332667, 1333842, 1339113, 1374750)) AND (t_d.attribute_id IN ('5109', '93', '4838', '5093', '131', '128', '83', '5050', '5108', '91', '117', '120', '115', '175', '121', '4824', '4489', '118', '97', '5051', '5054', '140', '134', '5213', '99', '119')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_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 = 1 WHERE (e.entity_id IN (1331971, 1332549, 1332589, 1332667, 1333842, 1339113, 1374750)) AND (t_d.attribute_id IN ('171', '114', '100', '116', '5045', '173', '172', '96', '132', '87', '109', '2333', '130', '5211', '86', '84', '170', '123', '73', '106', '104', '161', '160', '129', '88', '110', '5052', '5053', '5212', '133', '89', '111', '5214', '126', '127', '174')) 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 = 1 WHERE (e.entity_id IN (1331971, 1332549, 1332589, 1332667, 1333842, 1339113, 1374750)) AND (t_d.attribute_id IN ('5225', '162', '163', '103', '75', '85', '5106', '76')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1331971, 1332549, 1332589, 1332667, 1333842, 1339113, 1374750)) AND (t_d.attribute_id IN ('81', '98', '122', '77', '78', '5055', '92', '82')) 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 = 1 WHERE (e.entity_id IN (1331971, 1332549, 1332589, 1332667, 1333842, 1339113, 1374750)) AND (t_d.attribute_id IN ('101', '102', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 5.26ms |
| 197 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.21ms |
| 198 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.18ms |
| 199 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.15ms |
| 200 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.18ms |
| 201 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.16ms |
| 202 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.19ms |
| 203 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.16ms |
| 204 | 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 ('1331971')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.32ms |
| 205 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1331971') AND (store_id = 0) | 0.23ms |
| 206 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331971')) | 0.27ms |
| 207 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1331971) | 0.17ms |
| 208 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1331971) | 0.17ms |
| 209 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1331971') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1331971') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1331971') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1331971') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1331971') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.12ms |
| 210 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1331971') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.41ms |
| 211 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1331971') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.46ms |
| 212 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331971) | 0.17ms |
| 213 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1331971) | 0.17ms |
| 214 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1331971') ORDER BY `qty` ASC | 0.21ms |
| 215 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1331971) | 0.17ms |
| 216 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1331971')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 217 | 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 ('1332549')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.31ms |
| 218 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1332549') AND (store_id = 0) | 0.20ms |
| 219 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332549')) | 0.25ms |
| 220 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1332549) | 0.15ms |
| 221 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1332549) | 0.16ms |
| 222 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1332549') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1332549') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1332549') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1332549') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1332549') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.06ms |
| 223 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1332549') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 224 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1332549') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 225 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332549) | 0.17ms |
| 226 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1332549) | 0.16ms |
| 227 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1332549') ORDER BY `qty` ASC | 0.20ms |
| 228 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332549) | 0.17ms |
| 229 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332549')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 230 | 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 ('1332589')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.31ms |
| 231 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1332589') AND (store_id = 0) | 0.20ms |
| 232 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332589')) | 0.26ms |
| 233 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1332589) | 0.16ms |
| 234 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1332589) | 0.16ms |
| 235 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1332589') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1332589') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1332589') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1332589') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1332589') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.06ms |
| 236 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1332589') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 237 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1332589') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.44ms |
| 238 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332589) | 0.17ms |
| 239 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1332589) | 0.16ms |
| 240 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1332589') ORDER BY `qty` ASC | 0.20ms |
| 241 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332589) | 0.16ms |
| 242 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332589')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 243 | 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 ('1332667')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.31ms |
| 244 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1332667') AND (store_id = 0) | 0.20ms |
| 245 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332667')) | 0.25ms |
| 246 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1332667) | 0.17ms |
| 247 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1332667) | 0.15ms |
| 248 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1332667') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1332667') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1332667') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1332667') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1332667') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.05ms |
| 249 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1332667') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.40ms |
| 250 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1332667') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 251 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332667) | 0.17ms |
| 252 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1332667) | 0.15ms |
| 253 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1332667') ORDER BY `qty` ASC | 0.22ms |
| 254 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332667) | 0.16ms |
| 255 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332667')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 256 | 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 ('1333842')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.34ms |
| 257 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1333842') AND (store_id = 0) | 0.20ms |
| 258 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333842')) | 0.24ms |
| 259 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1333842) | 0.16ms |
| 260 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1333842) | 0.15ms |
| 261 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1333842') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1333842') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1333842') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1333842') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1333842') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.05ms |
| 262 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1333842') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 263 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1333842') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.42ms |
| 264 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333842) | 0.17ms |
| 265 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1333842) | 0.16ms |
| 266 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1333842') ORDER BY `qty` ASC | 0.19ms |
| 267 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333842) | 0.17ms |
| 268 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333842')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 269 | 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 ('1339113')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.29ms |
| 270 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1339113') AND (store_id = 0) | 0.21ms |
| 271 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1339113')) | 0.27ms |
| 272 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1339113) | 0.15ms |
| 273 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1339113) | 0.16ms |
| 274 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1339113') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1339113') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1339113') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1339113') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1339113') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.01ms |
| 275 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1339113') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 276 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1339113') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 277 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1339113) | 0.17ms |
| 278 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1339113) | 0.16ms |
| 279 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1339113') ORDER BY `qty` ASC | 0.20ms |
| 280 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1339113) | 0.15ms |
| 281 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1339113')) AND (`main_table`.`website_id` = '0') | 0.24ms |
| 282 | 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 ('1374750')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.32ms |
| 283 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1374750') AND (store_id = 0) | 0.20ms |
| 284 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1374750')) | 0.25ms |
| 285 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1374750) | 0.17ms |
| 286 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1374750) | 0.15ms |
| 287 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1374750') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1374750') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1374750') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1374750') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1374750') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.04ms |
| 288 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1374750') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 289 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1374750') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.42ms |
| 290 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1374750) | 0.17ms |
| 291 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1374750) | 0.17ms |
| 292 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1374750') ORDER BY `qty` ASC | 0.21ms |
| 293 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1374750) | 0.16ms |
| 294 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1374750')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 295 | SELECT DISTINCT e.entity_id, e.sku, spci.buy_without_stock, ( SELECT title FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS title, ( SELECT short_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS short_description, ( SELECT long_description FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS long_description, ( SELECT buy_without_stock_text FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' LIMIT 1) AS buy_without_stock_text, spcii.image_url, spcii.image_title, spidi.image_url AS image_url_default, spidi.image_title AS image_title_default, stock_status_index.stock_status AS is_salable FROM catalog_product_entity AS e INNER JOIN ( SELECT t1.* FROM semic_pim_collective_items t1 INNER JOIN ( SELECT magento_product_id, MIN( CASE WHEN is_published = 1 AND in_trash = 0 AND highlighted = 1 AND collective_id IN (1) THEN FIELD(collective_id, 1) ELSE 99999 END ) AS min_order FROM semic_pim_collective_items GROUP BY magento_product_id ) t2 ON t1.magento_product_id = t2.magento_product_id WHERE is_published = 1 AND in_trash = 0 AND highlighted = 1 AND collective_id IN (1) AND FIELD(t1.collective_id, 1) = t2.min_order ) spci ON e.entity_id = spci.magento_product_id LEFT JOIN semic_pim_collective_items_images AS spcii ON spcii.pim_collective_item_id = spci.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = spci.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN semic_pim_items_default_images AS spidi ON spidi.pim_item_id = spci.pim_item_id AND spidi.entity_id = ( SELECT entity_id FROM semic_pim_items_default_images WHERE pim_item_id = spci.pim_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) 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 LIMIT 12 | 288.32ms |
| 296 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` 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 WHERE (`e`.`entity_id` IN('1332493', '1333176', '1333208', '1345458', '1374989')) ORDER BY FIELD(e.entity_id, 1332493,1333176,1333208,1345458,1374989) | 0.51ms |
| 297 | 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 = 1 WHERE (e.entity_id IN (1332493, 1333176, 1333208, 1345458, 1374989)) AND (t_d.attribute_id IN ('5109', '93', '4838', '5093', '131', '128', '83', '5050', '5108', '91', '117', '120', '115', '175', '121', '4824', '4489', '118', '97', '5051', '5054', '140', '134', '5213', '99', '119')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_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 = 1 WHERE (e.entity_id IN (1332493, 1333176, 1333208, 1345458, 1374989)) AND (t_d.attribute_id IN ('171', '114', '100', '116', '5045', '173', '172', '96', '132', '87', '109', '2333', '130', '5211', '86', '84', '170', '123', '73', '106', '104', '161', '160', '129', '88', '110', '5052', '5053', '5212', '133', '89', '111', '5214', '126', '127', '174')) 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 = 1 WHERE (e.entity_id IN (1332493, 1333176, 1333208, 1345458, 1374989)) AND (t_d.attribute_id IN ('5225', '162', '163', '103', '75', '85', '5106', '76')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1332493, 1333176, 1333208, 1345458, 1374989)) AND (t_d.attribute_id IN ('81', '98', '122', '77', '78', '5055', '92', '82')) 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 = 1 WHERE (e.entity_id IN (1332493, 1333176, 1333208, 1345458, 1374989)) AND (t_d.attribute_id IN ('101', '102', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 5.33ms |
| 298 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.21ms |
| 299 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.19ms |
| 300 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.16ms |
| 301 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.18ms |
| 302 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.17ms |
| 303 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.20ms |
| 304 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.16ms |
| 305 | 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 ('1332493')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.33ms |
| 306 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1332493') AND (store_id = 0) | 0.22ms |
| 307 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332493')) | 0.26ms |
| 308 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1332493) | 0.15ms |
| 309 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1332493) | 0.17ms |
| 310 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1332493') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1332493') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1332493') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1332493') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1332493') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.13ms |
| 311 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1332493') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.42ms |
| 312 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1332493') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.46ms |
| 313 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332493) | 0.18ms |
| 314 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1332493) | 0.16ms |
| 315 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1332493') ORDER BY `qty` ASC | 0.22ms |
| 316 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1332493) | 0.17ms |
| 317 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1332493')) AND (`main_table`.`website_id` = '0') | 0.25ms |
| 318 | 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 ('1333176')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.33ms |
| 319 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1333176') AND (store_id = 0) | 0.20ms |
| 320 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333176')) | 0.25ms |
| 321 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1333176) | 0.17ms |
| 322 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1333176) | 0.16ms |
| 323 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1333176') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1333176') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1333176') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1333176') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1333176') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.08ms |
| 324 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1333176') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.41ms |
| 325 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1333176') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.45ms |
| 326 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333176) | 0.18ms |
| 327 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1333176) | 0.17ms |
| 328 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1333176') ORDER BY `qty` ASC | 0.21ms |
| 329 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333176) | 0.17ms |
| 330 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333176')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 331 | 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 ('1333208')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.33ms |
| 332 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1333208') AND (store_id = 0) | 0.21ms |
| 333 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333208')) | 0.25ms |
| 334 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1333208) | 0.17ms |
| 335 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1333208) | 0.16ms |
| 336 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1333208') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1333208') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1333208') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1333208') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1333208') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.06ms |
| 337 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1333208') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.40ms |
| 338 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1333208') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.44ms |
| 339 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333208) | 0.18ms |
| 340 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1333208) | 0.16ms |
| 341 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1333208') ORDER BY `qty` ASC | 0.21ms |
| 342 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1333208) | 0.16ms |
| 343 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1333208')) AND (`main_table`.`website_id` = '0') | 0.25ms |
| 344 | 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 ('1345458')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.34ms |
| 345 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1345458') AND (store_id = 0) | 0.20ms |
| 346 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1345458')) | 0.25ms |
| 347 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1345458) | 0.15ms |
| 348 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1345458) | 0.16ms |
| 349 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1345458') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1345458') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1345458') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1345458') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1345458') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.03ms |
| 350 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1345458') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 351 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1345458') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.42ms |
| 352 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1345458) | 0.20ms |
| 353 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1345458) | 0.16ms |
| 354 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1345458') ORDER BY `qty` ASC | 0.20ms |
| 355 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1345458) | 0.17ms |
| 356 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1345458')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 357 | 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 ('1374989')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.33ms |
| 358 | SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='1374989') AND (store_id = 0) | 0.21ms |
| 359 | SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1374989')) | 0.25ms |
| 360 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1374989) | 0.16ms |
| 361 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1374989) | 0.16ms |
| 362 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1374989') AND (attribute_id IN ('97', '121', '5051', '5050', '118', '5054', '91', '117', '120', '134', '115', '119', '99', '140', '5109', '5108', '175', '93', '4838', '4489', '4824', '5093', '128', '131', '5213')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (entity_id = '1374989') AND (attribute_id IN ('75', '76', '103', '85', '5106', '162', '163', '5225')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (entity_id = '1374989') AND (attribute_id IN ('87', '126', '104', '132', '73', '88', '84', '106', '5052', '89', '5045', '100', '5053', '133', '86', '116', '96', '123', '127', '109', '110', '111', '114', '160', '161', '170', '171', '172', '173', '174', '129', '130', '5211', '5212', '5214')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (entity_id = '1374989') AND (attribute_id IN ('78', '81', '77', '92', '5055', '122', '98', '82')) AND (`store_id` IN (1, 0))) UNION ALL( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (entity_id = '1374989') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.03ms |
| 363 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '1374989') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.38ms |
| 364 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '1374989') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.42ms |
| 365 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1374989) | 0.18ms |
| 366 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1374989) | 0.16ms |
| 367 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '1374989') ORDER BY `qty` ASC | 0.20ms |
| 368 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1374989) | 0.18ms |
| 369 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM `cataloginventory_stock_status` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id WHERE (`main_table`.`product_id` IN('1374989')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 370 | SELECT codigo_asociado FROM `semic_colectivos` WHERE codigo_colectivo_4G = '9999'; | 0.18ms |
| 371 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_asociado = 'C9999' | 0.13ms |
| 372 | SELECT * FROM `semic_pim_colectivos_baners` WHERE IdCollective = 1 ORDER BY `Order` ASC | 0.15ms |
| 373 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'ModalConcursos') AND (`is_banner` = '1') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.25ms |
| 374 | SELECT `main_table`.* FROM `semic_sliders` AS `main_table` WHERE (`slider_zone` = 'ModalConcursos') AND (((`customer_group` IS NULL) OR (FIND_IN_SET('1', `customer_group`)))) AND (((`storeview` = 0) OR (FIND_IN_SET('1', `storeview`)))) ORDER BY sortorder ASC | 0.23ms |
| 375 | 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`='politica_privacidad_formularios') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.45ms |
| 376 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '160') | 0.16ms |
| 377 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.19ms |
| 378 | 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`='semic_brands') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.41ms |
| 379 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '143') | 0.17ms |
| 380 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.19ms |
| 381 | 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`='semic_footer_top_1') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.39ms |
| 382 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '137') | 0.15ms |
| 383 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.19ms |
| 384 | 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`='politica_privacidad_formularios') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.42ms |
| 385 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '160') | 0.15ms |
| 386 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 387 | 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`='semic_footer_column_1') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.38ms |
| 388 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '138') | 0.14ms |
| 389 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 390 | 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`='semic_footer_column_2') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.41ms |
| 391 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '139') | 0.15ms |
| 392 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 393 | 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`='semic_footer_column_3') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.40ms |
| 394 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '140') | 0.16ms |
| 395 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 396 | 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`='semic_footer_column_4') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.40ms |
| 397 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '141') | 0.14ms |
| 398 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 399 | 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`='semic_footer_accordion_1') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.39ms |
| 400 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '153') | 0.14ms |
| 401 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.17ms |
| 402 | 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`='semic_footer_accordion_2') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.41ms |
| 403 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '154') | 0.15ms |
| 404 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.17ms |
| 405 | 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`='semic_footer_accordion_3') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.39ms |
| 406 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '155') | 0.14ms |
| 407 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.18ms |
| 408 | 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`='semic_footer_accordion_4') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.39ms |
| 409 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '156') | 0.15ms |
| 410 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.17ms |
| 411 | 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`='semic_footer_payment') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.40ms |
| 412 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '142') | 0.14ms |
| 413 | SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) | 0.17ms |
exception.log
Tail the 20 last linessystem.log
Tail the 20 last linesdebug.log
Tail the 20 last lines
| Template Path Hints for Storefront | ||
|---|---|---|
| Template Path Hints for Admin | ||
| Add Block Names to Hints | ||
| Translate inline | ||
| Flush Cache Storage |
ADM_QuickDevBar (version 0.1.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.
