Català
English
Ricoh 842214 cartucho de tóner 1 pieza(s) Original Amarillo
Disponibilidad:
Disponible
¿Ya está registrado? Identifíquese
Productos exclusivos
Precios especiales
Condiciones especiales
Mejor experiencia
¿No está registrado? Pulsa aquí
| Compatibilidad | Lanier MP C 407 Ricoh MP C 407, 407 PageKeeper, 407 SPF, 407 Series |
|---|---|
| Tipo | Original |
| Marca compatible | Ricoh |
| Cantidad por paquete | 1 pieza(s) |
| Colores de impresión | Amarillo |
| Rendimiento de impresión de tóner de color | 8000 páginas |
| Tipo de suministro | Multipack |
| Unidad de tambor incorporada | No |
| Tecnología de impresión | Impresión láser |
This wishlist name is already present.
| Base Url | https://semicstore-pre.semic.es/ |
|---|---|
| Path Info | /catalog/product/view/id/1347170 |
| Module Name | catalog |
| Controller | product |
| Action | view |
| Full Action | catalog_product_view |
| Route | catalog |
| Area | frontend |
| Params | Array ( [id] => 1347170 ) |
| Client IP | 216.73.216.189 |
| 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 ...
| Variable | Value |
|---|---|
| USER | www-data |
| HOME | /var/www |
| COMPOSER_HOME | /opt/magento/semicstore-pre.semic.es/var/composer_home |
| Variable | Value |
|---|---|
| $_COOKIE['PHPSESSID'] | rbfg3ggpl7h4hn4ttov9l6sm2c |
| $_COOKIE['X-Magento-Vary'] | fb7d60d20b9330a911c355b19261427b56f75b6a |
| $_SERVER['USER'] | www-data |
| $_SERVER['HOME'] | /var/www |
| $_SERVER['SCRIPT_NAME'] | /index.php |
| $_SERVER['REQUEST_URI'] | /ricoh-842214-cartucho-de-toner-1-pieza-s-original-amarillo.html |
| $_SERVER['QUERY_STRING'] | no value |
| $_SERVER['REQUEST_METHOD'] | GET |
| $_SERVER['SERVER_PROTOCOL'] | HTTP/2.0 |
| $_SERVER['GATEWAY_INTERFACE'] | CGI/1.1 |
| $_SERVER['REDIRECT_URL'] | /ricoh-842214-cartucho-de-toner-1-pieza-s-original-amarillo.html |
| $_SERVER['REMOTE_PORT'] | 28003 |
| $_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.189 |
| $_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_COOKIE'] | PHPSESSID=rbfg3ggpl7h4hn4ttov9l6sm2c; X-Magento-Vary=fb7d60d20b9330a911c355b19261427b56f75b6a |
| $_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'] | e583a6cc1965f6df5c39c305f768078f2154d5eaa051cb4e47433858df4a98e0 |
| $_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'] | 436147-1652-3 |
| $_SERVER['H2_STREAM_ID'] | 3 |
| $_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['REDIRECT_STATUS'] | 200 |
| $_SERVER['REDIRECT_SSL_SESSION_RESUMED'] | Initial |
| $_SERVER['REDIRECT_SSL_SESSION_ID'] | e583a6cc1965f6df5c39c305f768078f2154d5eaa051cb4e47433858df4a98e0 |
| $_SERVER['REDIRECT_SSL_SERVER_A_SIG'] | sha256WithRSAEncryption |
| $_SERVER['REDIRECT_SSL_SERVER_A_KEY'] | rsaEncryption |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN'] | CN=Sectigo RSA Organization Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB |
| $_SERVER['REDIRECT_SSL_SERVER_S_DN'] | CN=*.semic.es,O=SERVICIOS MICROINFORMATICA\, S.A.,ST=Cataluña,C=ES |
| $_SERVER['REDIRECT_SSL_SERVER_V_END'] | Apr 4 23:59:59 2026 GMT |
| $_SERVER['REDIRECT_SSL_SERVER_V_START'] | Mar 4 00:00:00 2025 GMT |
| $_SERVER['REDIRECT_SSL_SERVER_M_SERIAL'] | F711FD6095AE9D7DF3C145E8E67333F6 |
| $_SERVER['REDIRECT_SSL_SERVER_M_VERSION'] | 3 |
| $_SERVER['REDIRECT_SSL_CLIENT_VERIFY'] | NONE |
| $_SERVER['REDIRECT_SSL_CIPHER_ALGKEYSIZE'] | 256 |
| $_SERVER['REDIRECT_SSL_CIPHER_USEKEYSIZE'] | 256 |
| $_SERVER['REDIRECT_SSL_CIPHER_EXPORT'] | false |
| $_SERVER['REDIRECT_SSL_CIPHER'] | TLS_AES_256_GCM_SHA384 |
| $_SERVER['REDIRECT_SSL_COMPRESS_METHOD'] | NULL |
| $_SERVER['REDIRECT_SSL_SECURE_RENEG'] | true |
| $_SERVER['REDIRECT_SSL_PROTOCOL'] | TLSv1.3 |
| $_SERVER['REDIRECT_SSL_VERSION_LIBRARY'] | OpenSSL/3.0.2 |
| $_SERVER['REDIRECT_SSL_VERSION_INTERFACE'] | mod_ssl/2.4.65 |
| $_SERVER['REDIRECT_SSL_SERVER_SAN_DNS_1'] | semic.es |
| $_SERVER['REDIRECT_SSL_SERVER_SAN_DNS_0'] | *.semic.es |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN_CN'] | Sectigo RSA Organization Validation Secure Server CA |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN_O'] | Sectigo Limited |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN_L'] | Salford |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN_ST'] | Greater Manchester |
| $_SERVER['REDIRECT_SSL_SERVER_I_DN_C'] | GB |
| $_SERVER['REDIRECT_SSL_SERVER_S_DN_CN'] | *.semic.es |
| $_SERVER['REDIRECT_SSL_SERVER_S_DN_O'] | SERVICIOS MICROINFORMATICA, S.A. |
| $_SERVER['REDIRECT_SSL_SERVER_S_DN_ST'] | Cataluña |
| $_SERVER['REDIRECT_SSL_SERVER_S_DN_C'] | ES |
| $_SERVER['REDIRECT_SSL_TLS_SNI'] | semicstore-pre.semic.es |
| $_SERVER['REDIRECT_HTTPS'] | on |
| $_SERVER['REDIRECT_H2_STREAM_TAG'] | 436147-1652-3 |
| $_SERVER['REDIRECT_H2_STREAM_ID'] | 3 |
| $_SERVER['REDIRECT_H2_PUSHED_ON'] | no value |
| $_SERVER['REDIRECT_H2_PUSHED'] | no value |
| $_SERVER['REDIRECT_H2_PUSH'] | off |
| $_SERVER['REDIRECT_H2PUSH'] | off |
| $_SERVER['REDIRECT_HTTP2'] | on |
| $_SERVER['REDIRECT_MAGE_PROFILER'] | html |
| $_SERVER['REDIRECT_MAGE_DEBUG_SHOW_ARGS'] | 1 |
| $_SERVER['REDIRECT_HTTP_AUTHORIZATION'] | no value |
| $_SERVER['FCGI_ROLE'] | RESPONDER |
| $_SERVER['PHP_SELF'] | /index.php |
| $_SERVER['REQUEST_TIME_FLOAT'] | 1765197209.7709 |
| $_SERVER['REQUEST_TIME'] | 1765197209 |
Please wait.
Content is loading ...
| Handles | default catalog_product_view catalog_product_view_id_1347170 catalog_product_view_sku_842214 catalog_product_view_type_simple |
|---|
| Blocks hierarchy |
|
|---|
| Block | Call Number |
|---|---|
| Magento\Directory\Block\Currency | 2 |
| Magento\Framework\View\Element\Template | 22 |
| 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 |
| Semic\Colectivos\Block\Html\CustomTitle | 2 |
| 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 | 15 |
| 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 |
| Semic\Colectivos\Block\Product\CustomProductView\Interceptor | 11 |
| Magento\Framework\View\Element\Html\Calendar | 1 |
| Magento\Catalog\Pricing\Render | 2 |
| Magento\Catalog\Block\Product\View\Options | 1 |
| Magento\Catalog\Block\Product\View\Options\Type\DefaultType | 1 |
| Magento\Catalog\Block\Product\View\Options\Type\Text | 1 |
| Magento\Catalog\Block\Product\View\Options\Type\File | 1 |
| Magento\Catalog\Block\Product\View\Options\Type\Select | 1 |
| Magento\Catalog\Block\Product\View\Options\Type\Date | 1 |
| Magento\Catalog\Block\Product\View\Gallery\Interceptor | 1 |
| Magento\Catalog\Block\Product\View\Details | 1 |
| Semic\Colectivos\Block\Product\View\CustomDescription | 1 |
| Semic\Colectivos\Block\Product\View\CustomProductAttributes | 1 |
| Magento\Cookie\Block\RequireCookie | 1 |
| Magento\Catalog\Block\Product\ProductList\Related\Interceptor | 1 |
| Magento\Catalog\Block\Product\ProductList\Item\Container\Interceptor | 2 |
| Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare\Interceptor | 2 |
| Magento\Catalog\Block\Product\ProductList\Upsell\Interceptor | 1 |
| Magento\Catalog\Block\Product\View\Additional | 1 |
| Magento\Catalog\Block\ShortcutButtons | 3 |
| Magento\Catalog\Block\Ui\ProductViewCounter | 1 |
| Magento\CatalogInventory\Block\Qtyincrements | 1 |
| Magento\Msrp\Block\Popup | 1 |
| Magento\InstantPurchase\Block\Button | 2 |
| Magento\Paypal\Block\Bml\Banners | 2 |
| Magento\Review\Block\Product\Review\Interceptor | 1 |
| Semic\Colectivos\Block\CustomReviewForm\Interceptor | 1 |
| MSP\ReCaptcha\Block\Frontend\ReCaptcha | 1 |
| Magento\ProductAlert\Block\Product\View\Price | 1 |
| Magento\ProductAlert\Block\Product\View\Stock | 1 |
| Magento\ProductVideo\Block\Product\View\Gallery\Interceptor | 1 |
| Magento\GoogleOptimizer\Block\Code\Product | 1 |
| Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor | 2 |
| Amasty\BannersLite\Block\Banner | 3 |
| Amasty\Promo\Block\Banner | 2 |
| Caixabank\Finance\Block\Catalog\Product\View\Finance | 1 |
| Cetelem\Payment\Block\Product\Calculator | 1 |
| MagePal\GoogleTagManager\Block\Data\Product\Interceptor | 1 |
| Smartwave\Porto\Block\RickSnippet | 1 |
| Magento\Cms\Block\Block | 1 |
| Magento\Catalog\Block\Product\View\Type\Simple\Interceptor | 1 |
| Magento\CatalogInventory\Block\Stockqty\DefaultStockqty | 1 |
$_SERVER['REDIRECT_MAGE_PROFILER']setted instead of
$_SERVER['MAGE_PROFILER']prefer apache2.conf.
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_catalog_api_data_productinterface_load_after | legacy_model_load | 5 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_product_load_after | inventory | 5 | Magento\CatalogInventory\Observer\AddInventoryDataObserver |
| catalog_controller_product_view | reports | 1 | Magento\Reports\Observer\CatalogProductViewObserver |
| 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 |
| catalog_product_get_final_price | catalogrule | 1 | Magento\CatalogRule\Observer\ProcessFrontFinalPriceObserver |
| core_layout_render_element | pagecache | 160 | Magento\PageCache\Observer\ProcessLayoutRenderElement |
| core_layout_render_element | amasty_gdprcookie_layout_render | 160 | Amasty\GdprCookie\Observer\ProcessLayoutRenderElement |
| magento_cms_api_data_blockinterface_load_after | legacy_model_cms_block_after_load | 12 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_block_product_status_display | inventory | 1 | Magento\CatalogInventory\Observer\DisplayProductStatusInfoObserver |
| shortcut_buttons_container | paypal_shortcuts | 1 | Magento\Paypal\Observer\AddPaypalShortcutsObserver |
| custom_quote_process | persistent | 1 | Magento\Persistent\Observer\SetCheckoutSessionPersistentDataObserver |
| payment_method_is_active | cetelem_payment_available | 1 | Cetelem\Payment\Observer\PaymentMethodAvailable |
| currency_display_options_forming | magento_currencysymbol_currency_display_options | 1 | Magento\CurrencySymbol\Observer\CurrencyDisplayOptions |
| magento_salesrule_api_data_ruleinterface_load_after | legacy_model_load | 3 | Magento\Framework\EntityManager\Observer\AfterEntityLoad |
| catalog_product_upsell | bundle_observer | 1 | Magento\Bundle\Observer\AppendUpsellProductsObserver |
List only events dispatched when Magento generate this page
| Event | Data | Call Number |
|---|---|---|
| model_load_before |
| 10 |
| core_abstract_load_before |
| 9 |
| model_load_after |
| 29 |
| core_abstract_load_after |
| 9 |
| customer_session_init |
| 12 |
| core_collection_abstract_load_before |
| 19 |
| store_collection_load_before |
| 2 |
| core_collection_abstract_load_after |
| 19 |
| store_collection_load_after |
| 2 |
| customer_load_before |
| 1 |
| controller_action_predispatch |
| 1 |
| controller_action_predispatch_catalog |
| 1 |
| controller_action_predispatch_catalog_product_view |
| 1 |
| entity_manager_load_before |
| 20 |
| magento_catalog_api_data_productinterface_load_before |
| 5 |
| magento_catalog_api_data_productinterface_load_after |
| 5 |
| abstract_search_result_load_before |
| 2 |
| abstract_search_result_load_after |
| 2 |
| catalog_product_load_after |
| 5 |
| entity_manager_load_after |
| 20 |
| catalog_controller_product_init_before |
| 1 |
| catalog_controller_product_init_after |
| 1 |
| catalog_controller_product_view |
| 1 |
| layout_load_before |
| 1 |
| layout_generate_blocks_before |
| 1 |
| core_layout_block_create_after |
| 203 |
| depersonalize_clear_session | 2 | |
| eav_collection_abstract_load_before |
| 5 |
| catalog_category_collection_load_before |
| 1 |
| catalog_category_collection_load_after |
| 1 |
| layout_generate_blocks_after |
| 1 |
| controller_action_postdispatch_catalog_product_view |
| 1 |
| controller_action_postdispatch_catalog |
| 1 |
| controller_action_postdispatch |
| 1 |
| layout_render_before | 1 | |
| layout_render_before_catalog_product_view | 1 | |
| view_block_abstract_to_html_before |
| 170 |
| view_block_abstract_to_html_after |
| 166 |
| catalog_product_get_final_price |
| 1 |
| core_layout_render_element |
| 160 |
| catalog_product_is_salable_before |
| 1 |
| catalog_product_is_salable_after |
| 1 |
| magento_cms_api_data_blockinterface_load_before |
| 12 |
| magento_cms_api_data_blockinterface_load_after |
| 12 |
| cms_block_load_after |
| 12 |
| catalog_product_collection_load_after |
| 2 |
| catalog_block_product_status_display |
| 1 |
| shortcut_buttons_container |
| 1 |
| custom_quote_process |
| 1 |
| checkout_quote_init |
| 1 |
| payment_method_is_active |
| 1 |
| currency_display_options_forming |
| 1 |
| magento_salesrule_api_data_ruleinterface_load_before |
| 3 |
| magento_salesrule_api_data_ruleinterface_load_after |
| 3 |
| salesrule_rule_load_after |
| 3 |
| catalog_product_collection_apply_limitations_after |
| 2 |
| catalog_product_upsell |
| 1 |
| Collection | Call Number |
|---|---|
| Magento\Store\Model\ResourceModel\Store\Collection | 2 |
| Magento\Catalog\Model\ResourceModel\Product\Option\Collection | 5 |
| Semic\Colectivos\Model\ResourceModel\ColectivoProduct\Collection | 1 |
| Magento\Store\Model\ResourceModel\Group\Collection | 2 |
| Amasty\Promo\Model\ResourceModel\Rule\Collection | 1 |
| Magento\Review\Model\ResourceModel\Review\Summary\Collection | 2 |
| Amasty\BannersLite\Model\ResourceModel\Banner\Collection | 3 |
| Magento\Eav\Model\ResourceModel\Entity\Attribute\Option\Collection | 3 |
| 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 |
| Caixabank\Finance\Model\Productratecache | 1 |
| 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\Framework\Api\DataObjectHelper | Amasty\Conditions\Plugin\Framework\Api\DataObjectHelperPlugin | 1 | beforePopulateWithArray |
| 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\Forward | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| Magento\Framework\App\Action\Forward | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Framework\App\Action\Forward | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Magento\Catalog\Model\Session | Magento\Customer\CustomerData\Plugin\SessionChecker | 0 | beforeStart |
| 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\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 |
| Magento\Catalog\Controller\Product | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| Magento\Catalog\Controller\Product | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Magento\Catalog\Controller\Product\View | Amasty\Fpc\Plugin\ActionInterface | 0 | beforeExecute |
| Magento\Catalog\Controller\Product\View | Semic\RedirectDisabledProducts\Plugin\ProductsRedirect | 0 | aroundExecute |
| Magento\Catalog\Controller\Product\View | Magento\Framework\App\Action\Plugin\Design | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Customer\Model\Plugin\CustomerNotification | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Catalog\Plugin\Framework\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Tax\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Weee\Model\App\Action\ContextPlugin | 0 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Store\App\Action\Plugin\StoreCheck | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Store\App\Action\Plugin\Context | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Magento\Customer\Model\App\Action\ContextPlugin | 10 | beforeDispatch |
| Magento\Catalog\Controller\Product\View | Semic\Colectivos\Plugin\CustomerSessionContext | 15 | aroundDispatch |
| Magento\Catalog\Controller\Product\View | Semic\Colectivos\Plugin\CheckIsInCollectiveProductView | 10 | aroundExecute |
| 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\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\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 |
| Magento\Catalog\Helper\Product\View | Magento\Wishlist\Plugin\Helper\Product\View | 0 | beforePrepareAndRender |
| Smartwave\Porto\Helper\Product\View | Magento\Wishlist\Plugin\Helper\Product\View | 0 | beforePrepareAndRender |
| 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\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\Framework\App\Cache\FlushCacheByTags | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Mageplaza\Smtp\Plugin\DefaultAttributes | 0 | afterGetDefaultAttributes |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\Move | 0 | afterChangeParent |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\Remove | 0 | aroundDelete |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogUrlRewrite\Model\Category\Plugin\Category\UpdateUrlPath | 0 | afterSave |
| Magento\Catalog\Model\ResourceModel\Category | Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Category | 0 | aroundSave |
| 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\Catalog\Block\Product\View\AbstractView | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\View\Gallery | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\View\Gallery | Semic\Colectivos\Plugin\AddCollectiveImagesToProductViewGallery | 0 | afterGetGalleryImagesJson |
| Magento\ProductVideo\Block\Product\View\Gallery | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\ProductVideo\Block\Product\View\Gallery | Semic\Colectivos\Plugin\AddCollectiveImagesToProductViewGallery | 0 | afterGetGalleryImagesJson |
| Magento\ProductVideo\Block\Product\View\Gallery | Magento\ConfigurableProduct\Block\Plugin\Product\Media\Gallery | 0 | afterGetOptionsMediaGalleryDataJson |
| 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\Pricing\Renderer\SalableResolver | Magento\ConfigurableProduct\Plugin\Catalog\Model\Product\Pricing\Renderer\SalableResolver | 0 | afterIsSalable |
| Magento\Catalog\Model\ResourceModel\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Catalog\Block\Product\View | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\View | Magento\CatalogInventory\Block\Plugin\ProductView | 0 | afterGetQuantityValidators |
| Magento\Catalog\Block\Product\View | Amasty\Promo\Plugin\Block\Product\Simple | 0 | aroundGetJsonConfig |
| Magento\Catalog\Block\Product\View | Magento\SendFriend\Block\Plugin\Catalog\Product\View | 0 | afterCanEmailToFriend |
| Semic\Colectivos\Block\Product\CustomProductView | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Semic\Colectivos\Block\Product\CustomProductView | Magento\CatalogInventory\Block\Plugin\ProductView | 0 | afterGetQuantityValidators |
| Semic\Colectivos\Block\Product\CustomProductView | Amasty\Promo\Plugin\Block\Product\Simple | 0 | aroundGetJsonConfig |
| Semic\Colectivos\Block\Product\CustomProductView | Magento\SendFriend\Block\Plugin\Catalog\Product\View | 0 | afterCanEmailToFriend |
| Magento\Catalog\Pricing\Render\PriceBox | Magento\Catalog\Block\Category\Plugin\PriceBoxTags | 0 | afterGetCacheKey |
| Magento\Catalog\Model\Product\Link | Magento\CatalogInventory\Model\Plugin\ProductLinks | 0 | afterGetProductCollection |
| Magento\Catalog\Model\ResourceModel\Config | Magento\Catalog\Plugin\Model\ResourceModel\Config | 0 | aroundGetAttributesUsedInListing |
| Magento\Catalog\Model\ResourceModel\Config | Magento\Catalog\Plugin\Model\ResourceModel\Config | 0 | aroundGetAttributesUsedForSortBy |
| Magento\Catalog\Model\ResourceModel\Product\Link\Product\Collection | Magento\CatalogInventory\Model\AddStockStatusToCollection | 0 | beforeLoad |
| Magento\Review\Block\Product\Review | Amasty\AdvancedReview\Plugin\Review\Block\Product\ReviewPlugin | 0 | afterToHtml |
| Magento\Review\Block\Form | Amasty\AdvancedReview\Plugin\Review\Block\Form | 0 | afterToHtml |
| Semic\Colectivos\Block\CustomReviewForm | Amasty\AdvancedReview\Plugin\Review\Block\Form | 0 | afterToHtml |
| Magento\Customer\Block\Account\AuthenticationPopup | MSP\ReCaptcha\Plugin\Block\Account\AuthenticationPopupPlugin | 1 | afterGetJsLayout |
| Magento\Catalog\Block\Product\ProductList\Related | Magento\Swatches\Model\Plugin\ProductImage | 0 | beforeGetImage |
| Magento\Catalog\Block\Product\ProductList\Related | Semic\Colectivos\Plugin\RelatedProductsCollective | 0 | afterGetItems |
| Estadísticas | 199 queries in 421.38ms (average time: 2.12ms) - 472 queries/second |
|---|---|
| 195 SELECT - 0 INSERT - 1 UPDATE - 0 DELETE - 0 TRANSACTION | |
| Longest | SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`pim_collective_item_id`, `main_table`.`pim_item_id`, `main_table`.`magento_product_id`, `main_table`.`collective_id`, `main_table`.`sku`, `main_table`.`is_published`, `main_table`.`in_trash`, `main_table`.`order`, `main_table`.`brand`, `main_table`.`ean`, `main_table`.`buy_without_stock`, `spcid`.`language_code`, `spcid`.`title`, `spcid`.`short_description`, `spcid`.`long_description`, `spcid`.`seo_title`, `spcid`.`seo_description`, `spcid`.`keywords`, `spcid`.`buy_without_stock_text`, `spcii`.`image_url`, `spcii`.`image_title`, `spidi`.`image_url` AS `image_url_default`, `spidi`.`image_title` AS `image_title_default` FROM `semic_pim_collective_items` AS `main_table` INNER JOIN `semic_pim_collective_items_descriptions` AS `spcid` ON main_table.pim_collective_item_id = spcid.pim_collective_item_id AND spcid.language_code = 'ES' LEFT JOIN `semic_pim_collective_items_images` AS `spcii` ON spcii.pim_collective_item_id = main_table.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = main_table.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN ( SELECT `spidi1`.`pim_item_id`, `spidi1`.`entity_id`, `spidi1`.`image_url`, `spidi1`.`image_title` FROM `semic_pim_items_default_images` AS `spidi1` INNER JOIN ( SELECT pim_item_id, MAX(is_main) as is_main, MIN(entity_id) as entity_id FROM semic_pim_items_default_images WHERE language_code = 'ES' AND is_published = 1 GROUP BY pim_item_id) AS `spidi2` ON spidi1.pim_item_id = spidi2.pim_item_id AND spidi1.entity_id = spidi2.entity_id WHERE (spidi1.language_code = 'ES' AND is_published = 1)) AS `spidi` ON spidi.pim_item_id = main_table.pim_item_id WHERE (`collective_id` IN('1')) AND (`main_table`.`is_published` = '1') AND (`in_trash` = '0') AND (`sku` = '842214') |
| (255.89ms) |
| # | SQL | Time |
|---|---|---|
| 0 | connect | 0.55ms |
| 1 | SET NAMES utf8 | 0.10ms |
| 2 | SELECT `store_website`.* FROM `store_website` | 0.21ms |
| 3 | SELECT `store_group`.* FROM `store_group` | 0.15ms |
| 4 | SELECT `store`.* FROM `store` | 0.14ms |
| 5 | SHOW TABLE STATUS LIKE 'session' | 2.15ms |
| 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.20ms |
| 8 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('ricoh-842214-cartucho-de-toner-1-pieza-s-original-amarillo.html', 'ricoh-842214-cartucho-de-toner-1-pieza-s-original-amarillo.html/')) AND (`store_id` IN ('1')) | 0.27ms |
| 9 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.17ms |
| 10 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.18ms |
| 11 | SELECT related_collectives FROM semic_colectivos WHERE id_colectivo = 1 | 0.15ms |
| 12 | SELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='') | 0.21ms |
| 13 | SELECT codigo_colectivo_4G FROM semic_colectivos WHERE id_colectivo = '' | 0.17ms |
| 14 | SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/1347170', 'catalog/product/view/id/1347170/')) AND (`store_id` IN ('1')) | 0.23ms |
| 15 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/product/view/id/1347170', 'catalog/product/view/id/1347170/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) | 0.25ms |
| 16 | SELECT codigo_colectivo_4G FROM semic_colectivos WHERE id_colectivo = '' | 0.16ms |
| 17 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1347170) | 0.18ms |
| 18 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1347170) | 0.19ms |
| 19 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 1.54ms |
| 20 | 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` = '1347170') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 21 | 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 = '1347170') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.39ms |
| 22 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.19ms |
| 23 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.18ms |
| 24 | 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 = '1347170') ORDER BY `qty` ASC | 0.23ms |
| 25 | 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('1347170')) | 0.25ms |
| 26 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.19ms |
| 27 | 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('1347170')) AND (`main_table`.`website_id` = '0') | 0.23ms |
| 28 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.22ms |
| 29 | SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`pim_collective_item_id`, `main_table`.`pim_item_id`, `main_table`.`magento_product_id`, `main_table`.`collective_id`, `main_table`.`sku`, `main_table`.`is_published`, `main_table`.`in_trash`, `main_table`.`order`, `main_table`.`brand`, `main_table`.`ean`, `main_table`.`buy_without_stock`, `spcid`.`language_code`, `spcid`.`title`, `spcid`.`short_description`, `spcid`.`long_description`, `spcid`.`seo_title`, `spcid`.`seo_description`, `spcid`.`keywords`, `spcid`.`buy_without_stock_text`, `spcii`.`image_url`, `spcii`.`image_title`, `spidi`.`image_url` AS `image_url_default`, `spidi`.`image_title` AS `image_title_default` FROM `semic_pim_collective_items` AS `main_table` INNER JOIN `semic_pim_collective_items_descriptions` AS `spcid` ON main_table.pim_collective_item_id = spcid.pim_collective_item_id AND spcid.language_code = 'ES' LEFT JOIN `semic_pim_collective_items_images` AS `spcii` ON spcii.pim_collective_item_id = main_table.pim_collective_item_id AND spcii.entity_id = ( SELECT entity_id FROM semic_pim_collective_items_images WHERE pim_collective_item_id = main_table.pim_collective_item_id AND language_code = 'ES' AND is_published = 1 ORDER BY is_main DESC, entity_id ASC LIMIT 1 ) LEFT JOIN ( SELECT `spidi1`.`pim_item_id`, `spidi1`.`entity_id`, `spidi1`.`image_url`, `spidi1`.`image_title` FROM `semic_pim_items_default_images` AS `spidi1` INNER JOIN ( SELECT pim_item_id, MAX(is_main) as is_main, MIN(entity_id) as entity_id FROM semic_pim_items_default_images WHERE language_code = 'ES' AND is_published = 1 GROUP BY pim_item_id) AS `spidi2` ON spidi1.pim_item_id = spidi2.pim_item_id AND spidi1.entity_id = spidi2.entity_id WHERE (spidi1.language_code = 'ES' AND is_published = 1)) AS `spidi` ON spidi.pim_item_id = main_table.pim_item_id WHERE (`collective_id` IN('1')) AND (`main_table`.`is_published` = '1') AND (`in_trash` = '0') AND (`sku` = '842214') | 255.89ms |
| 30 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =1347170) | 0.24ms |
| 31 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = 1347170) | 0.18ms |
| 32 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC | 1.48ms |
| 33 | 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` = '1347170') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.35ms |
| 34 | 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 = '1347170') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.39ms |
| 35 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.16ms |
| 36 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.16ms |
| 37 | 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 = '1347170') ORDER BY `qty` ASC | 0.20ms |
| 38 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.15ms |
| 39 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.16ms |
| 40 | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 1347170) AND (category_id = 0) | 0.18ms |
| 41 | SELECT COUNT(*) FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (store.store_id IN('1')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='1347170') | 0.51ms |
| 42 | SELECT `session`.* FROM `session` WHERE (session_id = :session_id) | 0.26ms |
| 43 | UPDATE `session` SET `session_expires` = ?, `session_data` = ? WHERE (session_id='rbfg3ggpl7h4hn4ttov9l6sm2c') | 5.93ms |
| 44 | SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2025-12-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1347170')) | 0.25ms |
| 45 | SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (frontend_input = :frontend_input) | 0.19ms |
| 46 | SELECT `e`.*, `at_product_id`.`product_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id) WHERE (at_product_id.product_id = '1347170') | 0.25ms |
| 47 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (51624)) AND (t_d.attribute_id IN ('45')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.39ms |
| 48 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.25ms |
| 49 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.21ms |
| 50 | 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 ('1347170')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) | 0.30ms |
| 51 | SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2025-12-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1347170')) | 0.20ms |
| 52 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.21ms |
| 53 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.25ms |
| 54 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.22ms |
| 55 | SELECT `amasty_ampromo_rule`.`sku` FROM `amasty_ampromo_rule` WHERE (salesrule_id IN (142, 143)) | 0.20ms |
| 56 | 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.44ms |
| 57 | SELECT `session`.`session_data` FROM `session` WHERE (session_id = :session_id) | 0.19ms |
| 58 | SELECT id_colectivo FROM semic_colectivos WHERE codigo_colectivo_4G = 9999 | 0.16ms |
| 59 | SELECT related_collectives, share_menu FROM semic_colectivos WHERE id_colectivo = :id_colectivo | 0.15ms |
| 60 | SELECT menu_json FROM semic_pim_collective_menu WHERE collective = :collective AND language_code = :lang | 0.18ms |
| 61 | 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.69ms |
| 62 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '136') | 0.19ms |
| 63 | 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.22ms |
| 64 | SELECT `main_table`.`salesrule_id` FROM `amasty_banners_lite_rule` AS `main_table` WHERE (show_banner_for = '0' OR (show_banner_for = '1' AND FIND_IN_SET('842214', banner_product_sku)) OR (show_banner_for = '2' AND (((FIND_IN_SET('51624', banner_product_categories)))))) | 0.31ms |
| 65 | SELECT `main_table`.`rule_id` FROM `salesrule` AS `main_table` LEFT JOIN `salesrule_coupon` AS `rule_coupons` ON main_table.rule_id = rule_coupons.rule_id AND rule_coupons.is_primary = 1 INNER JOIN ( SELECT DISTINCT `salesrule_website`.`rule_id` FROM `salesrule_website` WHERE (website_id IN (1))) AS `website` ON main_table.rule_id = website.rule_id INNER JOIN `salesrule_customer_group` AS `customer_group_ids` ON main_table.rule_id = customer_group_ids.rule_id AND customer_group_ids.customer_group_id = 1 WHERE (from_date is null or from_date <= '2025-12-08') AND (to_date is null or to_date >= '2025-12-08') AND (`is_active` = '1') AND (`main_table`.`rule_id` IN('79', '80', '81', '84', '85', '86', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '106', '109', '110', '111', '112', '113', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '130', '131', '132', '134', '135', '136', '137', '138', '139', '140', '141')) AND (`simple_action` IN('thecheapest', 'themostexpencive', 'moneyamount', 'eachn_perc', 'eachn_fixdisc', 'eachn_fixprice', 'eachmaftn_perc', 'eachmaftn_fixdisc', 'eachmaftn_fixprice', 'groupn', 'groupn_disc', 'buyxgety_perc', 'buyxgety_fixprice', 'buyxgety_fixdisc', 'buyxgetn_perc', 'buyxgetn_fixprice', 'buyxgetn_fixdisc', 'aftern_fixprice', 'aftern_disc', 'aftern_fixdisc', 'setof_percent', 'setof_fixed', 'ampromo_product', 'ampromo_items', 'ampromo_cart', 'ampromo_spent', 'ampromo_eachn')) | 1.00ms |
| 66 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` IN('141', '139', '140')) | 0.24ms |
| 67 | SELECT `main_table`.`salesrule_id` FROM `amasty_banners_lite_rule` AS `main_table` WHERE (show_banner_for = '0' OR (show_banner_for = '1' AND FIND_IN_SET('842214', banner_product_sku)) OR (show_banner_for = '2' AND (((FIND_IN_SET('51624', banner_product_categories)))))) | 0.27ms |
| 68 | SELECT `main_table`.`rule_id` FROM `salesrule` AS `main_table` LEFT JOIN `salesrule_coupon` AS `rule_coupons` ON main_table.rule_id = rule_coupons.rule_id AND rule_coupons.is_primary = 1 INNER JOIN ( SELECT DISTINCT `salesrule_website`.`rule_id` FROM `salesrule_website` WHERE (website_id IN (1))) AS `website` ON main_table.rule_id = website.rule_id INNER JOIN `salesrule_customer_group` AS `customer_group_ids` ON main_table.rule_id = customer_group_ids.rule_id AND customer_group_ids.customer_group_id = 1 WHERE (from_date is null or from_date <= '2025-12-08') AND (to_date is null or to_date >= '2025-12-08') AND (`is_active` = '1') AND (`main_table`.`rule_id` IN('79', '80', '81', '84', '85', '86', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '106', '109', '110', '111', '112', '113', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '130', '131', '132', '134', '135', '136', '137', '138', '139', '140', '141')) AND (`simple_action` IN('thecheapest', 'themostexpencive', 'moneyamount', 'eachn_perc', 'eachn_fixdisc', 'eachn_fixprice', 'eachmaftn_perc', 'eachmaftn_fixdisc', 'eachmaftn_fixprice', 'groupn', 'groupn_disc', 'buyxgety_perc', 'buyxgety_fixprice', 'buyxgety_fixdisc', 'buyxgetn_perc', 'buyxgetn_fixprice', 'buyxgetn_fixdisc', 'aftern_fixprice', 'aftern_disc', 'aftern_fixdisc', 'setof_percent', 'setof_fixed', 'ampromo_product', 'ampromo_items', 'ampromo_cart', 'ampromo_spent', 'ampromo_eachn')) | 0.98ms |
| 69 | SELECT `main_table`.* FROM `amasty_ampromo_rule` AS `main_table` WHERE (`salesrule_id` IN('141', '139', '140')) | 0.22ms |
| 70 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.29ms |
| 71 | SELECT spcii.image_url, spcii.image_title, spcii.is_main FROM semic_pim_collective_items spci INNER JOIN semic_pim_collective_items_images spcii ON spci.pim_collective_item_id = spcii.pim_collective_item_id WHERE spci.collective_id IN (1) AND spci.is_published = 1 AND spci.sku = '842214' AND spci.collective_id IN (1) AND spcii.language_code = 'ES' AND spcii.is_published = 1 | 0.49ms |
| 72 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.21ms |
| 73 | SELECT spidi.image_url, spidi.image_title, spidi.is_main FROM semic_pim_collective_items spci INNER JOIN semic_pim_items_default_images spidi ON spci.pim_item_id = spidi.pim_item_id AND spidi.is_published = 1 WHERE spci.is_published = 1 AND spci.sku = '842214' AND spci.collective_id IN (1) AND spidi.language_code = 'ES' | 37.16ms |
| 74 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.27ms |
| 75 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.20ms |
| 76 | SELECT `main_table`.* FROM `review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1347170')) AND (entity_type = 1) AND (store_id = 1) | 0.23ms |
| 77 | SELECT `semic_colectivos`.`id_colectivo` FROM `semic_colectivos` WHERE (codigo_colectivo_4G = '9999') LIMIT 1 | 0.19ms |
| 78 | SELECT `semic_pim_collective_items`.`pim_collective_item_id` FROM `semic_pim_collective_items` WHERE (magento_product_id = '1347170') AND (collective_id = '1') LIMIT 1 | 0.21ms |
| 79 | 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` = '1347170') | 0.24ms |
| 80 | 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 (1347170)) 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 (1347170)) 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 (1347170)) 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 (1347170)) 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 (1347170)) AND (t_d.attribute_id IN ('101', '102', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 4.15ms |
| 81 | SELECT COUNT(*) FROM `sw_dailydeals_dailydeal` AS `main_table` WHERE (`sw_product_sku` = '842214') | 0.20ms |
| 82 | SELECT buy_without_stock, pim_collective_item_id FROM semic_pim_collective_items WHERE magento_product_id = 1347170 AND collective_id = ( SELECT collective_id FROM semic_pim_collective_items WHERE magento_product_id = 1347170 AND collective_id IN (1) ORDER BY FIELD(collective_id, 1) LIMIT 1 ); | 0.36ms |
| 83 | SELECT buy_without_stock_text FROM semic_pim_collective_items_descriptions WHERE pim_collective_item_id = 25640 AND language_code = 'ES'; | 0.18ms |
| 84 | SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN('1347170')) | 0.20ms |
| 85 | SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id) | 0.26ms |
| 86 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1347170') | 0.38ms |
| 87 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1347170') | 0.19ms |
| 88 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.39ms |
| 89 | 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` = '1347170') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.48ms |
| 90 | 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 = '1347170') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.49ms |
| 91 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.22ms |
| 92 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.19ms |
| 93 | 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 = '1347170') ORDER BY `qty` ASC | 0.21ms |
| 94 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.17ms |
| 95 | 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` = '1347170') | 0.21ms |
| 96 | 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 (1347170)) 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 (1347170)) 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 (1347170)) 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 (1347170)) 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 (1347170)) AND (t_d.attribute_id IN ('101', '102', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 3.99ms |
| 97 | SELECT COUNT(*) FROM `sw_dailydeals_dailydeal` AS `main_table` WHERE (`sw_product_sku` = '842214') | 0.18ms |
| 98 | SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN('1347170')) | 0.38ms |
| 99 | SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id) | 0.29ms |
| 100 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.44ms |
| 101 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.23ms |
| 102 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.19ms |
| 103 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.18ms |
| 104 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.19ms |
| 105 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.16ms |
| 106 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='193') | 0.15ms |
| 107 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='194') | 0.25ms |
| 108 | SELECT `amasty_banners_lite_banner_data`.* FROM `amasty_banners_lite_banner_data` WHERE (`amasty_banners_lite_banner_data`.`entity_id`='195') | 0.22ms |
| 109 | SELECT `amasty_banners_lite_rule`.* FROM `amasty_banners_lite_rule` WHERE (`amasty_banners_lite_rule`.`salesrule_id`='79') | 0.18ms |
| 110 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.17ms |
| 111 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.16ms |
| 112 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '5050') AND (`main_table`.`option_id` IN('11548')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.78ms |
| 113 | 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`='iconos-ficha-producto') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 | 0.44ms |
| 114 | SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 4) | 0.20ms |
| 115 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '2' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE (links.product_id in ('1347170')) AND (`e`.`entity_id` != '1347170') ORDER BY `position` ASC | 0.75ms |
| 116 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.21ms |
| 117 | SELECT DISTINCT `e`.`entity_id` AS `parent_product_id` FROM `catalog_product_bundle_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = catalog_product_bundle_selection.parent_product_id WHERE (catalog_product_bundle_selection.product_id IN('1347170')) | 0.22ms |
| 118 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.19ms |
| 119 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.16ms |
| 120 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.13ms |
| 121 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.15ms |
| 122 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.16ms |
| 123 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.15ms |
| 124 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.14ms |
| 125 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1347170') | 0.16ms |
| 126 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1347170') | 0.16ms |
| 127 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.23ms |
| 128 | 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` = '1347170') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 129 | 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 = '1347170') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.44ms |
| 130 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.17ms |
| 131 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.15ms |
| 132 | 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 = '1347170') ORDER BY `qty` ASC | 0.19ms |
| 133 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.14ms |
| 134 | SELECT `product_rate_cache`.* FROM `product_rate_cache` WHERE (`product_rate_cache`.`product_id`='1347170') | 0.15ms |
| 135 | SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='1347170') | 0.17ms |
| 136 | SELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE (entity_id = '1347170') | 0.14ms |
| 137 | SELECT `u`.* FROM ( ( SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (entity_id = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') 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 = '1347170') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC | 2.15ms |
| 138 | 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` = '1347170') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC | 0.39ms |
| 139 | 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 = '1347170') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.43ms |
| 140 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.17ms |
| 141 | SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 1347170) | 0.15ms |
| 142 | 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 = '1347170') ORDER BY `qty` ASC | 0.20ms |
| 143 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 1347170) | 0.14ms |
| 144 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.23ms |
| 145 | SELECT `name` as label, `value` FROM semic_pim_collective_items spci INNER JOIN semic_pim_collective_features_values fv ON spci.pim_collective_item_id = fv.pim_collective_item_id AND fv.language_code = 'ES' INNER JOIN semic_pim_collective_features_names fn ON fn.pim_collective_feature_id = fv.pim_collective_feature_id AND fn.language_code = 'ES' INNER JOIN semic_pim_collective_features_features_group ffg ON fn.pim_collective_feature_id = ffg.pim_collective_feature_id INNER JOIN semic_pim_collective_features_group fg ON fg.pim_collective_feature_group_id = ffg.pim_collective_feature_group_id AND fg.is_visible_on_item = 1 WHERE magento_product_id = 1347170 AND collective_id = ( SELECT collective_id FROM semic_pim_collective_items spci WHERE spci.magento_product_id = 1347170 AND spci.is_published = 1 AND spci.in_trash = 0 AND spci.collective_id IN (1) ORDER BY FIELD(spci.collective_id, 1) LIMIT 1) ; | 54.14ms |
| 146 | SELECT `semic_colectivos`.`id_colectivo` FROM `semic_colectivos` WHERE (codigo_colectivo_4G = '9999') LIMIT 1 | 0.21ms |
| 147 | SELECT `semic_pim_collective_items`.`pim_collective_item_id` FROM `semic_pim_collective_items` WHERE (magento_product_id = '1347170') AND (collective_id = '1') LIMIT 1 | 0.19ms |
| 148 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.21ms |
| 149 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.18ms |
| 150 | SELECT i.sku as sku, i.pim_collective_item_id as pim_collective_item_id FROM semic_pim_collective_items i INNER JOIN catalog_product_entity p ON i.magento_product_id = p.entity_id AND p.sku = '842214'; | 0.17ms |
| 151 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '5050') AND (`main_table`.`option_id` IN('11548')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.67ms |
| 152 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '5050') AND (`main_table`.`option_id` IN('11548')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC | 0.65ms |
| 153 | SELECT `main_table`.* FROM `review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1347170')) AND (entity_type = 1) AND (store_id = 1) | 0.24ms |
| 154 | SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 1) | 0.22ms |
| 155 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE (links.product_id in ('1347170')) AND (`e`.`entity_id` != '1347170') ORDER BY `position` ASC | 0.76ms |
| 156 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.21ms |
| 157 | SELECT `t`.* FROM `salesrule` AS `t` WHERE (rule_id = 79) | 0.19ms |
| 158 | SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '79') | 0.16ms |
| 159 | SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '79') | 0.16ms |
| 160 | SELECT COUNT(*) FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.18ms |
| 161 | SELECT `main_table`.* FROM `amasty_banners_lite_banner_data` AS `main_table` WHERE (`salesrule_id` = '79') | 0.16ms |
| 162 | SELECT `amasty_ampromo_rule`.* FROM `amasty_ampromo_rule` WHERE (`amasty_ampromo_rule`.`salesrule_id`='79') | 0.17ms |
| 163 | SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) | 0.15ms |
| 164 | SELECT pim_collective_item_id FROM `semic_pim_collective_items` WHERE magento_product_id = 1347170 AND collective_id = 1 | 0.22ms |
| 165 | SELECT pim_collective_item_id_related FROM `semic_pim_collective_items_related` WHERE pim_collective_item_id = 25640 AND is_published = 1 | 0.15ms |
| 166 | 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.44ms |
| 167 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '137') | 0.17ms |
| 168 | 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 |
| 169 | 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.41ms |
| 170 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '160') | 0.17ms |
| 171 | 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 |
| 172 | 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.43ms |
| 173 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '138') | 0.15ms |
| 174 | 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 |
| 175 | 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 |
| 176 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '139') | 0.16ms |
| 177 | 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 |
| 178 | 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.97ms |
| 179 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '140') | 0.15ms |
| 180 | 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 |
| 181 | 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 |
| 182 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '141') | 0.15ms |
| 183 | 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 |
| 184 | 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.41ms |
| 185 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '153') | 0.15ms |
| 186 | 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 |
| 187 | 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.40ms |
| 188 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '154') | 0.15ms |
| 189 | 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 |
| 190 | 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.41ms |
| 191 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '155') | 0.15ms |
| 192 | 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 |
| 193 | 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.40ms |
| 194 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '156') | 0.16ms |
| 195 | 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.20ms |
| 196 | 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.39ms |
| 197 | SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '142') | 0.15ms |
| 198 | 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 |
| 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.
Info 
Design 
Profile 
Queries 
Logs 
Actions 