There are no products matching the selection.
LALA CURIO is a home décor brand celebrating ancient artisanship with contemporary humour.
+852 2528 5007
| Module | Version | Status | Actions | |
|---|---|---|---|---|
| Magento | 1.9.2.0 | 1 | Toggle Status | |
| Mage_Core | 1.6.0.6 | true | Toggle Status | |
| Mage_Eav | 1.6.0.1 | true | Toggle Status | |
| Mage_Page | 1.6.0.0 | true | Toggle Status | |
| Mage_Install | 0.7.0 | true | Toggle Status | |
| Mage_Admin | 1.6.1.1 | true | Toggle Status | |
| Mage_Rule | 1.6.0.0 | true | Toggle Status | |
| Mage_Adminhtml | 0.7.1 | true | Toggle Status | |
| Mage_AdminNotification | 1.6.0.0 | true | Toggle Status | |
| Mage_Cron | 1.6.0.0 | true | Toggle Status | |
| Mage_Directory | 1.6.0.3 | true | Toggle Status | |
| Mage_Dataflow | 1.6.0.0 | true | Toggle Status | |
| Mage_Cms | 1.6.0.0.2 | true | Toggle Status | |
| Mage_Index | 1.6.0.0 | true | Toggle Status | |
| Mage_Customer | 1.6.2.0.4 | true | Toggle Status | |
| Mage_Catalog | 1.6.0.0.19.1.2 | true | Toggle Status | |
| Mage_CatalogRule | 1.6.0.3 | true | Toggle Status | |
| Mage_CatalogIndex | 1.6.0.0 | true | Toggle Status | |
| Mage_CatalogSearch | 1.8.2.0 | true | Toggle Status | |
| Mage_Payment | 1.6.0.0 | true | Toggle Status | |
| Mage_Sales | 1.6.0.9 | true | Toggle Status | |
| Mage_CatalogInventory | 1.6.0.0.2 | true | Toggle Status | |
| Mage_Shipping | 1.6.0.0 | true | Toggle Status | |
| Mage_SalesRule | 1.6.0.3 | true | Toggle Status | |
| Mage_Usa | 1.6.0.3 | true | Toggle Status | |
| Mage_Paygate | 1.6.0.0 | true | Toggle Status | |
| Mage_Checkout | 1.6.0.0 | true | Toggle Status | |
| Mage_Backup | 1.6.0.0 | true | Toggle Status | |
| Mage_Paypal | 1.6.0.6 | true | Toggle Status | |
| Mage_Poll | 1.6.0.1 | true | Toggle Status | |
| Mage_GoogleCheckout | 1.6.0.1 | true | Toggle Status | |
| Mage_Log | 1.6.1.1 | true | Toggle Status | |
| Mage_Review | 1.6.0.0 | true | Toggle Status | |
| Mage_Rating | 1.6.0.1 | true | Toggle Status | |
| Mage_Widget | 1.6.0.0 | true | Toggle Status | |
| Mage_Tag | 1.6.0.0 | true | Toggle Status | |
| Mage_Reports | 1.6.0.0.1 | true | Toggle Status | |
| Mage_GoogleAnalytics | 1.6.0.0 | true | Toggle Status | |
| Mage_Tax | 1.6.0.4 | true | Toggle Status | |
| Mage_Wishlist | 1.6.0.0 | true | Toggle Status | |
| Mage_PaypalUk | 1.6.0.0 | true | Toggle Status | |
| Mage_Media | 1.6.0.0 | true | Toggle Status | |
| Mage_GiftMessage | 1.6.0.0 | true | Toggle Status | |
| Mage_Contacts | 1.6.0.0 | true | Toggle Status | |
| Mage_Sendfriend | 1.6.0.1 | true | Toggle Status | |
| Mage_Sitemap | 1.6.0.0 | true | Toggle Status | |
| Mage_Rss | 1.6.0.0 | true | Toggle Status | |
| Mage_ProductAlert | 1.6.0.0 | true | Toggle Status | |
| Mage_Api | false | Toggle Status | ||
| Mage_Oauth | 1.0.0.0 | true | Toggle Status | |
| Mage_Authorizenet | false | Toggle Status | ||
| Mage_Bundle | 1.6.0.0.1 | true | Toggle Status | |
| Mage_Captcha | false | Toggle Status | ||
| Mage_Centinel | 1.6.0.0 | true | Toggle Status | |
| Mage_Compiler | 1.6.0.0 | true | Toggle Status | |
| Mage_ConfigurableSwatches | false | Toggle Status | ||
| Mage_Connect | false | Toggle Status | ||
| Mage_Newsletter | 1.6.0.2 | true | Toggle Status | |
| Mage_Downloadable | false | Toggle Status | ||
| Mage_ImportExport | false | Toggle Status | ||
| Mage_Api2 | 1.0.0.0 | true | Toggle Status | |
| Mage_PageCache | false | Toggle Status | ||
| Mage_Persistent | false | Toggle Status | ||
| Mage_Weee | 1.6.0.0 | true | Toggle Status | |
| Mage_CurrencySymbol | 1.0.0.0.0 | true | Toggle Status | |
| Mage_XmlConnect | 1.6.0.0.1 | true | Toggle Status | |
| Addedbytes_Duplicatecmspage | false | Toggle Status | ||
| Aoe_Scheduler | false | Toggle Status | ||
| Apptrian_Minify | 2.0.1 | true | Toggle Status | |
| Aschroder_SMTPPro | 2.0.7 | true | Toggle Status | |
| Beecoder_Beeshopy | false | Toggle Status | ||
| Bmgww_Tumblr | false | Toggle Status | ||
| Cm_RedisSession | 0.2 | true | Toggle Status | |
| Ebizmarts_AbandonedCart | false | Toggle Status | ||
| Ebizmarts_Autoresponder | false | Toggle Status | ||
| Ebizmarts_MageMonkey | false | Toggle Status | ||
| Ebizmarts_Mandrill | false | Toggle Status | ||
| Ebizmarts_SweetMonkey | false | Toggle Status | ||
| Envato_WidgetLinks | true | Toggle Status | ||
| MagePsycho_Easypathhints | false | Toggle Status | ||
| Mageplaza_Seo | false | Toggle Status | ||
| Magiccart_Alothemes | 1.5 | true | Toggle Status | |
| Magiccart_Blog | 0.1.1 | true | Toggle Status | |
| Magiccart_Magicbrand | false | Toggle Status | ||
| Magiccart_Magiccategory | false | Toggle Status | ||
| Magiccart_Magicinstall | 0.1.0 | true | Toggle Status | |
| Magiccart_Magicmenu | false | Toggle Status | ||
| Magiccart_Magicproduct | 0.1.5 | true | Toggle Status | |
| Magiccart_Magicshop | false | Toggle Status | ||
| Magiccart_Magicslider | false | Toggle Status | ||
| Magiccart_Magicsocial | 0.1.0 | true | Toggle Status | |
| Magiccart_Testimonial | 0.1.0 | true | Toggle Status | |
| Magneto_Debug | 1.0.0 | true | Toggle Status | |
| Neklo_Core | 1.0.2 | true | Toggle Status | |
| Neklo_Instagram | false | Toggle Status | ||
| OlegKoval_ContactsFormCaptcha | false | Toggle Status | ||
| Optimiseweb_Redirects | 0.3.5 | true | Toggle Status | |
| Phoenix_Moneybookers | false | Toggle Status | ||
| Zero1_Seoredirects | 1.1.9 | true | Toggle Status |
Search examples: default/system, global/resources/default_setup, frontend/events or modules. If you don't know what to search check all the configuration keys.
| # | Config | Value |
|---|
| Variable | Value |
|---|---|
| Route Name | catalog |
| Controller Module/Name | Mage_Catalog / product |
| Action Name | view |
| Request Path | catalog/product/view/id/425/category/39 |
No COOKIE data
| Variable | Value |
|---|---|
| _session_validator_data |
3.239.233.139 CCBot/2.0 (https://commoncrawl.org/faq/) |
| messages | Mage_Core_Model_Message_Collection |
| _form_key | kam26HMvoXXXYQb2 |
No GET data
No POST data
| Resource Name | Model Class | Times Instantiated |
|---|---|---|
| cms/block | Mage_Cms_Model_Block | 8 |
| catalog/product | Mage_Catalog_Model_Product | 6 |
| core/url_rewrite | Mage_Core_Model_Url_Rewrite | 5 |
| eav/entity_type | Mage_Eav_Model_Entity_Type | 2 |
| catalog/attribute | Mage_Catalog_Model_Resource_Eav_Attribute | 1 |
| catalog/category | Mage_Catalog_Model_Category | 1 |
| review/review_summary | Mage_Review_Model_Review_Summary | 1 |
| Type | Class | SQL |
|---|---|---|
| mysql | Mage_Core_Model_Resource_Store_Collection | SELECT `main_table`.* FROM `core_store` AS `main_table` |
| mysql | Mage_Core_Model_Resource_Website_Collection | SELECT `main_table`.* FROM `core_website` AS `main_table` |
| mysql | Mage_Core_Model_Resource_Store_Group_Collection | SELECT `main_table`.* FROM `core_store_group` AS `main_table` |
| eav | Mage_Catalog_Model_Resource_Category_Collection | SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('39', '30', '29', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) |
| eav | Mage_Catalog_Model_Resource_Category_Collection | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('29', '30', '39')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') |
| eav | Mage_Catalog_Model_Resource_Category_Collection | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163')) AND (`e`.`entity_id` NOT IN('58', '59', '61', '62', '112', '175', '199', '255')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') |
| mysql | Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection | 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 (attribute_id = '81') AND (tdv.store_id = 0) |
| eav | Mage_Catalog_Model_Resource_Product_Link_Product_Collection | 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` 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.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` 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' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) ORDER BY `position` ASC |
| eav | Mage_Catalog_Model_Resource_Product_Link_Product_Collection | 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` 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.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` 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' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) ORDER BY `position` ASC |
| eav | Mage_Catalog_Model_Resource_Product_Collection | SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL)) |
| eav | Mage_Catalog_Model_Resource_Product_Collection | SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL)) |
| eav | Mage_Catalog_Model_Resource_Product_Collection | SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL)) |
| Time | Action | Query |
|---|---|---|
|
0.0003 s
|
connect
|
|
|
0.0001 s
|
SET NAMES utf8
|
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 1))
Params: furniture/by-room/library/qianlong-cabinet-on-stand.html, furniture/by-room/library/qianlong-cabinet-on-stand.html/ |
|
0.0010 s
|
SHOW TABLE STATUS LIKE 'core_session'
|
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `core_session`.`session_data` FROM `core_session` WHERE (session_id = :session_id) AND (session_expires > :session_expires)
Params: 2pm6a9s0smpdej33eha8v7c1i0, 1610981810 |
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL)
Params: 1, 2021-01-18 14:56:50 |
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `core_translate`.`string`, `core_translate`.`translate` FROM `core_translate` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC
Params: en_US, 1 |
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425')
|
|
0.0003 s
|
SELECT EXPLAIN |
SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (entity_attribute.attribute_set_id = '4') ORDER BY entity_attribute.sort_order ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`='425') AND (stock_id = :stock_id)
Params: 1 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
begin
|
|
|
0.0002 s
|
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?)
Params: 2pm6a9s0smpdej33eha8v7c1i0, 2021-01-18 14:56:50, 2021-01-18 14:56:50, 0, 1 |
|
|
0.0020 s
|
commit
|
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =425)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 425)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_category_product_index`.`product_id` FROM `catalog_category_product_index` WHERE (product_id = 425) AND (category_id = 39)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =39)
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id=3) AND (entity_attribute.attribute_set_id = '3') ORDER BY entity_attribute.sort_order ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_category_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '39') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '39') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '39') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '39') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '3' WHERE (attr_table.entity_id = '39') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
begin
|
|
|
0.0009 s
|
INSERT INTO `report_viewed_product_index` (`visitor_id`,`customer_id`,`product_id`,`store_id`,`added_at`) VALUES (?, ?, ?, ?, '2021-01-18 14:56:50') ON DUPLICATE KEY UPDATE `visitor_id` = VALUES(`visitor_id`), `customer_id` = VALUES(`customer_id`), `product_id` = VALUES(`product_id`), `store_id` = VALUES(`store_id`), `added_at` = VALUES(`added_at`)
Params: 3585595, , 425, 1 |
|
|
0.0019 s
|
commit
|
|
|
0.0006 s
|
SELECT EXPLAIN |
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `report_viewed_product_index` AS `idx_table` ON (idx_table.product_id=e.entity_id) AND (idx_table.visitor_id = '3585595')
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = '2'
LEFT JOIN `core_store` AS `store_index` ON store_index.store_id = idx_table.store_id
LEFT JOIN `core_store_group` AS `store_group_index` ON store_index.group_id = store_group_index.group_id
LEFT JOIN `catalog_category_product_index` AS `store_cat_index` ON store_cat_index.product_id = e.entity_id AND store_cat_index.store_id = idx_table.store_id AND store_cat_index.category_id=store_group_index.root_category_id WHERE (cat_index.visibility IN(3, 2, 4) OR store_cat_index.visibility IN(3, 2, 4))
|
|
0.0001 s
|
begin
|
|
|
0.0002 s
|
INSERT INTO `report_event` (`logged_at`, `event_type_id`, `object_id`, `subject_id`, `subtype`, `store_id`) VALUES ('2021-01-18 14:56:50', ?, ?, ?, ?, ?)
Params: 1, 425, 3585595, 1, 1 |
|
|
0.0018 s
|
commit
|
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('39', '30', '29', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `t_d`.`entity_id`, `t_d`.`attribute_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`
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 (t_d.entity_type_id = 3) AND (t_d.entity_id IN (39, 30, 29, 2)) AND (t_d.attribute_id IN ('58', '61')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d`
LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (39, 30, 29, 2)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d`
LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (39, 30, 29, 2)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d`
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (39, 30, 29, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, alothemesdefault |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, default |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, STORE_english |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, THEME_frontend_alogg_default |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, MAP_popup |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, MAP_price_msrp_item |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, SHORTCUT_popup |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, SHORTCUT_uk_popup |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, alothemesdefault |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, catalog_product_view |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, PRODUCT_TYPE_simple |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, PRODUCT_425 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update`
INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
Params: 1, frontend, alogg, default, customer_logged_out |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('29', '30', '39')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `t_d`.`entity_id`, `t_d`.`attribute_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`
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 (t_d.entity_type_id = 3) AND (t_d.entity_id IN (29, 30, 39)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/29') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/30') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/39') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='product/425') AND (store_id = '1') ORDER BY `is_system` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='support-mobile') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 7 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id)
Params: 2 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2')
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163'))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `a`.`attribute_id`, `t`.* FROM `eav_attribute` AS `a`
INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (entity_type_code = :entity_type_code) AND (attribute_code = :attribute_code)
Params: catalog_category, is_active |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `d`.`entity_id` FROM `catalog_category_entity_int` AS `d`
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id WHERE (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (d.entity_id IN ('3', '15', '29', '30', '34', '37', '38', '39', '57', '58', '59', '60', '61', '62', '66', '67', '69', '70', '71', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '148', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '162', '163', '164', '167', '168', '169', '170', '171', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '202', '204', '205', '206', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '240', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '257', '258', '260')) AND (IF(c.value_id > 0, c.value, d.value) = :cond)
Params: 42, 1, 0, 0 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163'))
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1)
LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163')) AND (`e`.`entity_id` NOT IN('58', '59', '61', '62', '112', '175', '199', '255')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `t_d`.`entity_id`, `t_d`.`attribute_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`
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 (t_d.entity_type_id = 3) AND (t_d.entity_id IN (3, 15, 29, 30, 34, 37, 38, 39, 57, 60, 66, 67, 69, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 111, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 150, 151, 152, 153, 154, 155, 156, 157, 158, 161, 162, 163, 211, 213, 214, 215, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 257, 258)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-01-18') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('425'))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='425') AND (store_id = 1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425')
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
Params: 4 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
Params: 4 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
Params: 81 |
|
0.0001 s
|
SELECT EXPLAIN |
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 (attribute_id = '81') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425')
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
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 WHERE (main.attribute_id = '88') AND (main.entity_id in ('425')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1)
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='link-social-product') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 15 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_id IN ('115', '116', '71', '75', '82', '85', '100', '103', '122', '72', '90', '83', '86', '101', '104', '73', '76', '84', '87', '105', '74', '77', '88', '106', '80', '78', '95', '107', '89', '93', '91', '109', '94', '118', '99', '96', '119', '97', '120', '102', '121', '98', '117', '126', '137', '108', '110', '111', '112', '113', '114', '123', '124', '125', '127', '128', '129', '130', '131', '141', '144', '81')) AND (entity.attribute_set_id = :attribute_set_id)
Params: 4 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='customtab') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0002 s
|
SELECT EXPLAIN |
SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)
|
|
0.0001 s
|
SELECT EXPLAIN |
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.0001 s
|
SELECT EXPLAIN |
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`, `links`.`link_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.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` 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'
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' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 425) AND (`e`.`entity_id` != '425') ORDER BY `position` ASC
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` 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'
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 425) AND (`e`.`entity_id` != '425')
|
|
0.0001 s
|
SELECT EXPLAIN |
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.0001 s
|
SELECT EXPLAIN |
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` 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'
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 425) AND (`e`.`entity_id` != '425')
|
|
0.0001 s
|
SELECT EXPLAIN |
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`, `links`.`link_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.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` 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'
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 = '4' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 425) AND (`e`.`entity_id` != '425') ORDER BY `position` ASC LIMIT 10
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT DISTINCT `catalog_product_bundle_selection`.`parent_product_id` FROM `catalog_product_bundle_selection` WHERE (product_id IN('425'))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='sales_product') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 21 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `main_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_for_sort_by = 1)
|
|
0.0005 s
|
SELECT EXPLAIN |
SELECT max(qo) AS des_qty,`product_id`,`parent_item_id`
FROM ( SELECT sum(`qty_ordered`) AS qo,`product_id`,created_at,store_id,`parent_item_id` FROM sales_flat_order_item GROUP BY `product_id` )
AS t1 where store_id
AND parent_item_id is null
AND created_at between '2020-01-19' AND '2021-01-18 14:56:51'
GROUP BY `product_id` ORDER BY des_qty DESC LIMIT 6
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT max(qo) AS des_qty,`product_id`,`parent_item_id`
FROM ( SELECT sum(`qty_ordered`) AS qo,`product_id`,created_at,store_id,`parent_item_id` FROM sales_flat_order_item GROUP BY `product_id` )
AS t1 where store_id
AND parent_item_id is null
AND created_at between '2020-01-19' AND '2021-01-18 14:56:51'
GROUP BY `product_id` ORDER BY des_qty DESC LIMIT 6
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1)
INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT max(qo) AS des_qty,`product_id`,`parent_item_id`
FROM ( SELECT sum(`qty_ordered`) AS qo,`product_id`,created_at,store_id,`parent_item_id` FROM sales_flat_order_item GROUP BY `product_id` )
AS t1 where store_id
AND parent_item_id is null
AND created_at between '2020-01-19' AND '2021-01-18 14:56:51'
GROUP BY `product_id` ORDER BY des_qty DESC LIMIT 6
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1)
INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT max(qo) AS des_qty,`product_id`,`parent_item_id`
FROM ( SELECT sum(`qty_ordered`) AS qo,`product_id`,created_at,store_id,`parent_item_id` FROM sales_flat_order_item GROUP BY `product_id` )
AS t1 where store_id
AND parent_item_id is null
AND created_at between '2020-01-19' AND '2021-01-18 14:56:51'
GROUP BY `product_id` ORDER BY des_qty DESC LIMIT 6
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1)
INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`entity_id` IN(NULL))
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='image') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 20 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_bottom') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 8 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='newsletter') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id)
Params: 30 |
|
0.0001 s
|
SELECT EXPLAIN |
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='paypal') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
|
<?xml version="1.0"?>
<layout><block name="formkey" type="core/template" template="core/formkey.phtml"/>
<label>All Pages</label>
<block type="page/html" name="root" output="toHtml" template="page/3columns.phtml">
<block type="page/html_head" name="head" as="head">
<action method="addJs">
<script>prototype/prototype.js</script>
</action>
<action method="addJs">
<script>lib/ccard.js</script>
</action>
<action method="addJs">
<script>prototype/validation.js</script>
</action>
<action method="addJs">
<script>scriptaculous/builder.js</script>
</action>
<action method="addJs">
<script>scriptaculous/effects.js</script>
</action>
<action method="addJs">
<script>scriptaculous/dragdrop.js</script>
</action>
<action method="addJs">
<script>scriptaculous/controls.js</script>
</action>
<action method="addJs">
<script>scriptaculous/slider.js</script>
</action>
<action method="addJs">
<script>varien/js.js</script>
</action>
<action method="addJs">
<script>varien/form.js</script>
</action>
<action method="addJs">
<script>varien/menu.js</script>
</action>
<action method="addJs">
<script>mage/translate.js</script>
</action>
<action method="addJs">
<script>mage/cookies.js</script>
</action>
<block type="page/js_cookie" name="js_cookies" template="page/js/cookie.phtml"/>
<action method="addJs">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs">
<script>magiccart/bootstrap/bootstrap.min.js</script>
</action>
<action method="addJs">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/modernizr.custom.min.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/selectivizr.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/matchMedia.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/matchMedia.addListener.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/enquire.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/app.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/imagesloaded.js</name>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/bootstrap/html5shiv.js</name>
<if>lt IE 9</if>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/bootstrap/respond.min.js</name>
<if>lt IE 9</if>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/elegantfont/lte-ie7.js</name>
<if>lt IE 7</if>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/fontawesome-4.5.0/css/font-awesome.min.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/elegantfont/css/elegantfont.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/webfont/css/simple-line-icons.css</stylesheet>
</action>
<action method="addItem">
<type>skin_css</type>
<name>magiccart/plugin/css/bootstrap/bootstrap.min.css</name>
<params/>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>css/styles.css</stylesheet>
</action>
<action method="addItem">
<type>skin_css</type>
<name>css/styles-ie.css</name>
<params/>
<if>lt IE 8</if>
</action>
<action method="addCss">
<stylesheet>css/widgets.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>css/print.css</stylesheet>
<params>media="print"</params>
</action>
<action method="addItem">
<type>js</type>
<name>lib/ds-sleight.js</name>
<params/>
<if>lt IE 7</if>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/ie6.js</name>
<params/>
<if>lt IE 7</if>
</action>
</block>
<block type="core/text_list" name="after_body_start" as="after_body_start" translate="label">
<label>Page Top</label>
</block>
<block type="page/html_notices" name="global_notices" as="global_notices" template="page/html/notices.phtml"/>
<block type="page/html_header" name="header" as="header">
<block type="page/template_links" name="top.links" as="topLinks"/>
<block type="page/switch" name="store_language" as="store_language" template="page/switch/languages.phtml"/>
<block type="directory/currency" name="currency" as="currency" template="directory/currency.phtml"/>
<block type="core/text_list" name="top.menu" as="topMenu" translate="label">
<label>Navigation Bar</label>
<block type="page/html_topmenu" name="catalog.topnav" template="page/html/topmenu.phtml"/>
</block>
<block type="core/text_list" name="top_verticalmenu" as="top_verticalmenu" translate="label">
<block type="core/template" name="verticalmenu" template="magiccart/magicmenu/verticalmenu.phtml">
</block>
</block>
<block type="page/html_wrapper" name="top.container" as="topContainer" translate="label">
<label>Page Header</label>
<action method="setElementClass">
<value>top-container</value>
</action>
</block>
<block type="page/html_welcome" name="welcome" as="welcome"/>
</block>
<block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>
<block type="core/text_list" name="left_first" as="left_first" translate="label">
<label>Left Column First (shows above main column on smaller screens)</label>
</block>
<block type="core/text_list" name="left_top" as="left_top" translate="label">
<label>Left Top Column</label>
</block>
<block type="core/text_list" name="left_bottom" as="left_bottom" translate="label">
<label>Left Bottom Column</label>
</block>
<block type="core/text_list" name="right_top" as="right_top" translate="label" ignore="1">
<label>Right Top Column</label>
</block>
<block type="core/text_list" name="content_heading" as="content_heading" translate="label">
<label>Content Heading</label>
</block>
<block type="core/text_list" name="slide_home" as="slide_home" translate="label">
<label>Slide Home</label>
</block>
<block type="core/text_list" name="block_top" as="block_top" translate="label">
<label>Block Top</label>
</block>
<block type="core/text_list" name="block_right" as="block_right" translate="label">
<label>Block Right</label>
</block>
<block type="core/text_list" name="left" as="left" translate="label">
<label>Left Column</label>
</block>
<block type="core/messages" name="global_messages" as="global_messages"/>
<block type="core/messages" name="messages" as="messages"/>
<block type="core/text_list" name="content" as="content" translate="label">
<label>Main Content Area</label>
</block>
<block type="core/text_list" name="right" as="right" translate="label">
<label>Right Column</label>
</block>
<block type="core/text_list" name="right_bottom" as="right_bottom" translate="label">
<label>Right Bottom Column</label>
</block>
<block type="page/html_footer" name="footer" as="footer" template="page/html/footer.phtml">
<block type="page/html_wrapper" name="bottom.container" as="bottomContainer" translate="label">
<label>Page Footer</label>
<action method="setElementClass">
<value>bottom-container</value>
</action>
</block>
<block type="page/switch" name="store_switcher" as="store_switcher" template="page/switch/stores.phtml"/>
<block type="page/template_links" name="footer_links" as="footer_links" template="page/template/links.phtml"/>
</block>
<block type="core/text_list" name="before_body_end" as="before_body_end" translate="label">
<label>Page Bottom</label>
<block type="page/html_cookieNotice" name="global_cookie_notice" as="global_cookie_notice" template="page/html/cookienotice.phtml" before="-"/>
</block>
</block>
<block type="core/profiler" output="toHtml" name="core_profiler"/>
<reference name="head">
<block type="core/template" name="optional_zip_countries" as="optional_zip_countries" template="directory/js/optional_zip_countries.phtml"/>
</reference>
<reference name="footer">
<block type="cms/block" name="cms_footer_links" before="footer_links">
<action method="setBlockId">
<block_id>footer_links</block_id>
</action>
</block>
<block type="cms/block" name="block_footer_top" as="block_footer_top">
<action method="setBlockId">
<block_id>block_footer_top</block_id>
</action>
</block>
<block type="cms/block" name="block_footer_bottom" as="block_footer_bottom">
<action method="setBlockId">
<block_id>block_footer_bottom</block_id>
</action>
</block>
</reference>
<reference name="top.links">
<action method="addLink" translate="label title" module="customer">
<label>My Account</label>
<url helper="customer/getAccountUrl"/>
<title>My Account</title>
<prepare/>
<urlParams/>
<position>10</position>
</action>
</reference>
<reference name="root">
<action method="setTemplate">
<template>page/2columns-left.phtml</template>
</action>
<block type="core/text_list" name="support" as="support" translate="label"/>
<remove name="right_top"/>
</reference>
<reference name="left">
<block type="catalog/product_compare_sidebar" before="cart_sidebar" name="catalog.compare.sidebar" template="catalog/product/compare/sidebar.phtml"/>
<remove name="left.newsletter"/>
<remove name="tags_popular"/>
</reference>
<reference name="right">
<remove name="right.poll"/>
<remove name="wishlist_sidebar"/>
<remove name="right.reports.product.viewed"/>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="catalog" ifconfig="catalog/seo/site_map">
<label>Site Map</label>
<url helper="catalog/map/getCategoryUrl"/>
<title>Site Map</title>
</action>
</reference>
<block type="catalog/product_price_template" name="catalog_product_price_template"/>
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp.phtml</template>
</action>
<action method="addPriceBlockType">
<type>msrp_item</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
<action method="addPriceBlockType">
<type>msrp_noform</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_noform.phtml</template>
</action>
</reference>
<reference name="header">
<block type="core/template" name="top.search" as="topSearch" template="catalogsearch/form.mini.phtml"/>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="catalogsearch" ifconfig="catalog/seo/search_terms">
<label>Search Terms</label>
<url helper="catalogsearch/getSearchTermUrl"/>
<title>Search Terms</title>
</action>
<action method="addLink" translate="label title" module="catalogsearch">
<label>Advanced Search</label>
<url helper="catalogsearch/getAdvancedSearchUrl"/>
<title>Advanced Search</title>
</action>
</reference>
<reference name="top.links">
<block type="checkout/links" name="checkout_cart_link">
<action method="addCheckoutLink"/>
</block>
</reference>
<reference name="right">
</reference>
<reference name="topCart.extra_actions">
<block type="paypal/express_shortcut" name="paypal.partner.top_cart.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="cart_sidebar.extra_actions">
<block type="paypal/express_shortcut" name="paypal.partner.cart_sidebar.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="right">
<block type="poll/activePoll" name="right.poll" ignore="1">
<action method="setPollTemplate">
<template>poll/active.phtml</template>
<type>poll</type>
</action>
<action method="setPollTemplate">
<template>poll/result.phtml</template>
<type>results</type>
</action>
</block>
</reference>
<reference name="right">
<block type="reports/product_viewed" before="right.permanent.callout" name="right.reports.product.viewed" template="reports/product_viewed.phtml" ignore="1"/>
<block type="reports/product_compared" before="right.permanent.callout" name="right.reports.product.compared" template="reports/product_compared.phtml"/>
</reference>
<reference name="head" before="-">
<block type="googleanalytics/ga" name="google_analytics" as="google_analytics" template="googleanalytics/ga.phtml"/>
</reference>
<reference name="topCart.extra_actions">
<block type="paypaluk/express_shortcut" name="paypaluk.partner.top_cart.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="cart_sidebar.extra_actions">
<block type="paypaluk/express_shortcut" name="paypaluk.partner.cart_sidebar.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="contacts" ifconfig="contacts/contacts/enabled">
<label>Contact Us</label>
<url>contacts</url>
<title>Contact Us</title>
<prepare>true</prepare>
</action>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="rss" ifconfig="rss/config/active">
<label>RSS</label>
<url>rss</url>
<title>RSS</title>
<prepare>true</prepare>
<urlParams/>
<position/>
<li/>
<a>class="link-rss"</a>
</action>
</reference>
<block type="rss/list" name="head_rss" ifconfig="rss/config/active"/>
<reference name="cart_sidebar">
<action method="addItemRender">
<type>bundle</type>
<block>bundle/checkout_cart_item_renderer</block>
<template>checkout/cart/sidebar/default.phtml</template>
</action>
</reference>
<reference name="wishlist_sidebar" ignore="1">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
<reference name="left">
<block type="newsletter/subscribe" name="left.newsletter" template="newsletter/subscribe.phtml" ignore="1"/>
</reference>
<reference name="head">
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/product-media.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-list.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-product.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="alothemes/categorysearch/enabled">
<script>magiccart/plugin/jquery.ddslick.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/enabled">
<script>magiccart/jquery.alothemes.js</script>
</action>
</reference>
<update handle="alothemesdefault"/>
<block type="alothemes/themecfg" name="themecfg" template="magiccart/alothemes/themecfg.phtml"/>
<reference name="head">
<action method="append" ifconfig="alothemes/general/enabled">
<block>themecfg</block>
</action>
</reference>
<reference name="top.search">
<action method="setTemplate" ifconfig="alothemes/categorysearch/enabled">
<template>magiccart/alothemes/categorysearch/form.phtml</template>
</action>
</reference>
<reference name="head">
<action method="addCss" ifconfig="magicsocial/general/enabled">
<stylesheet>magiccart/magicsocial/css/magicsocial.css</stylesheet>
</action>
<action method="addJs" ifconfig="magicsocial/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="magicsocial/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="magicsocial/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
</reference>
<block type="magicsocial/social" name="social" template="magiccart/magicsocial/social.phtml"/>
<reference name="after_body_start">
<action ifconfig="magicsocial/social/enabled" method="insert">
<block>social</block>
</action>
</reference>
<reference name="top.links">
<action method="addLink" translate="label title" module="testimonial" ifconfig="testimonial/general/topLink">
<label>Testimonial</label>
<url>testimonial</url>
<title>Testimonial</title>
<prepare>true</prepare>
<urlParams/>
<position>0</position>
</action>
</reference>
<reference name="before_body_end">
<block type="debug/debug" name="debug_panels" template="debug/debug.phtml">
<block type="debug/versions" name="debug_versions_panel" template="debug/versions.phtml"/>
<block type="debug/config" name="debug_config_panel" template="debug/config.phtml"/>
<block type="debug/blocks" name="debug_blocks_panel" template="debug/blocks.phtml"/>
<block type="debug/controller" name="debug_controller_panel" template="debug/controller.phtml"/>
<block type="debug/models" name="debug_models_panel" template="debug/models.phtml"/>
<block type="core/template" name="debug_layout_panel" template="debug/layout.phtml"/>
<block type="core/template" name="debug_performance_panel" template="debug/performance.phtml"/>
<block type="core/template" name="debug_utils_panel" template="debug/utils.phtml"/>
</block>
</reference>
<label>Catalog Product View (Any)</label>
<reference name="root">
<action method="setTemplate">
<template>page/2columns-right.phtml</template>
</action>
<block type="core/text_list" name="support" as="support" translate="label"/>
</reference>
<reference name="head">
<action method="addJs">
<script>varien/product.js</script>
</action>
<action method="addJs">
<script>varien/configurable.js</script>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addItem">
<type>js_css</type>
<name>calendar/calendar-win2k-1.css</name>
<params/>
</action>
<action method="addItem">
<type>js</type>
<name>calendar/calendar.js</name>
</action>
<action method="addItem">
<type>js</type>
<name>calendar/calendar-setup.js</name>
</action>
</reference>
<reference name="content">
<block type="catalog/product_view" name="product.info" template="catalog/product/view.phtml">
<block type="catalog/product_view_media" name="product.info.media" as="media" template="catalog/product/view/media.phtml">
<block type="core/text_list" name="product.info.media.after" as="after"/>
</block>
<block type="core/text_list" name="alert.urls" as="alert_urls" translate="label">
<label>Alert Urls</label>
</block>
<action method="setTierPriceTemplate">
<template>catalog/product/view/tierprices.phtml</template>
</action>
<block type="catalog/product_list_upsell" name="product.info.upsell" as="upsell_products" template="catalog/product/list/upsell.phtml">
<action method="setColumnCount">
<columns>6</columns>
</action>
<action method="setItemLimit">
<type>upsell</type>
<limit>6</limit>
</action>
</block>
<block type="catalog/product_view_additional" name="product.info.additional" as="product_additional_data"/>
<block type="catalog/product_view_description" name="product.description" as="description" template="catalog/product/view/description.phtml">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Description</value>
</action>
</block>
<block type="catalog/product_view_attributes" name="product.attributes" as="additional" template="catalog/product/view/attributes.phtml">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Additional Information</value>
</action>
</block>
<block type="review/product_view_list" name="product.reviews" as="reviews" template="review/product/view/list.phtml" after="additional">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Reviews</value>
</action>
</block>
<block type="core/template" name="customtab" as="customtab" template="catalog/product/view/customtab.phtml" after="additional">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Custom Tab</value>
</action>
</block>
<block type="catalog/product_list_related" name="catalog.product.related" as="related_products" template="catalog/product/list/related.phtml"/>
<block type="catalog/product_list_related" name="product.info.related" as="related" template="catalog/product/list/related.phtml">
<action method="setColumnCount">
<columns>6</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>6</limit>
</action>
</block>
<block type="catalog/product_view" name="product.info.addto" as="addto" template="catalog/product/view/addto.phtml"/>
<block type="catalog/product_view" name="product.info.sharing" as="sharing" template="catalog/product/view/sharing.phtml"/>
<block type="catalog/product_view" name="product.info.addtocart" as="addtocart" template="catalog/product/view/addtocart.phtml"/>
<block type="core/text_list" name="product.info.extrahint" as="extrahint" translate="label">
<label>Product View Extra Hint</label>
</block>
<block type="catalog/product_view" name="product.info.options.wrapper" as="product_options_wrapper" template="catalog/product/view/options/wrapper.phtml" translate="label">
<label>Info Column Options Wrapper</label>
<block type="core/template" name="options_js" template="catalog/product/view/options/js.phtml"/>
<block type="catalog/product_view_options" name="product.info.options" as="product_options" template="catalog/product/view/options.phtml">
<action method="addOptionRenderer">
<type>text</type>
<block>catalog/product_view_options_type_text</block>
<template>catalog/product/view/options/type/text.phtml</template>
</action>
<action method="addOptionRenderer">
<type>file</type>
<block>catalog/product_view_options_type_file</block>
<template>catalog/product/view/options/type/file.phtml</template>
</action>
<action method="addOptionRenderer">
<type>select</type>
<block>catalog/product_view_options_type_select</block>
<template>catalog/product/view/options/type/select.phtml</template>
</action>
<action method="addOptionRenderer">
<type>date</type>
<block>catalog/product_view_options_type_date</block>
<template>catalog/product/view/options/type/date.phtml</template>
</action>
</block>
<block type="core/html_calendar" name="html_calendar" as="html_calendar" template="page/js/calendar.phtml"/>
</block>
<block type="catalog/product_view" name="product.info.options.wrapper.bottom" as="product_options_wrapper_bottom" template="catalog/product/view/options/wrapper/bottom.phtml" translate="label">
<label>Bottom Block Options Wrapper</label>
<action method="insert">
<block>product.tierprices</block>
</action>
<block type="catalog/product_view" name="product.clone_prices" as="prices" template="catalog/product/view/price_clone.phtml"/>
<action method="append">
<block>product.info.addtocart</block>
</action>
<action method="append">
<block>product.info.addto</block>
</action>
<action method="append">
<block>product.info.sharing</block>
</action>
</block>
<block type="core/template_facade" name="product.info.container1" as="container1">
<action method="setDataByKey">
<key>alias_in_layout</key>
<value>container1</value>
</action>
<action method="setDataByKeyFromRegistry">
<key>options_container</key>
<key_in_registry>product</key_in_registry>
</action>
<action method="append">
<block>product.info.options.wrapper</block>
</action>
<action method="append">
<block>product.info.options.wrapper.bottom</block>
</action>
</block>
<block type="core/template_facade" name="product.info.container2" as="container2">
<action method="setDataByKey">
<key>alias_in_layout</key>
<value>container2</value>
</action>
<action method="setDataByKeyFromRegistry">
<key>options_container</key>
<key_in_registry>product</key_in_registry>
</action>
<action method="append">
<block>product.info.options.wrapper</block>
</action>
<action method="append">
<block>product.info.options.wrapper.bottom</block>
</action>
</block>
<action method="unsetCallChild">
<child>container1</child>
<call>ifEquals</call>
<if>0</if>
<key>alias_in_layout</key>
<key>options_container</key>
</action>
<action method="unsetCallChild">
<child>container2</child>
<call>ifEquals</call>
<if>0</if>
<key>alias_in_layout</key>
<key>options_container</key>
</action>
</block>
</reference>
<reference name="support">
<block type="cms/block" name="support_category">
<action method="setBlockId">
<block_id>support-category</block_id>
</action>
</block>
</reference>
<reference name="left">
<block type="catalog/product_list_related" name="catalog.product.related" as="related_products" template="catalog/product/list/related.phtml">
<action method="setColumnCount">
<columns>3</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>3</limit>
</action>
</block>
</reference>
<reference name="right_top" ignore="1">
<block type="catalog/navigation" name="catalog.leftnav" after="currency" template="catalog/navigation/left.phtml">
<block type="core/text_list" name="catalog.leftnav.state.renderers" as="state_renderers"/>
</block>
</reference>
<reference name="right_bottom">
<block type="cms/block" name="sale">
<action method="setBlockId">
<block_id>sales_product</block_id>
</action>
</block>
<block type="cms/block" name="img_right_bottom">
<action method="setBlockId">
<block_id>image</block_id>
</action>
</block>
</reference>
<reference name="head">
<action method="addItem" ifconfig="sales/msrp/enabled">
<type>skin_js</type>
<name>js/msrp.js</name>
</action>
</reference>
<reference name="content">
<block type="core/template" template="catalog/msrp/popup.phtml" name="product.tooltip"/>
</reference>
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
</reference>
<reference name="product.clone_prices">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
</reference>
<update handle="MAP_popup"/>
<update handle="MAP_price_msrp_item"/>
<reference name="product.info.extrahint">
<block type="cataloginventory/qtyincrements" name="product.info.extrahint.qtyincrements" template="cataloginventory/qtyincrements.phtml"/>
</reference>
<reference name="product.tooltip">
<block type="page/html_wrapper" name="product.info.addtocart.paypal.wrapper" translate="label">
<block type="paypal/express_shortcut" name="product.info.addtocart.paypal" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
<action method="setShowOrPosition">
<value>after</value>
</action>
</block>
</block>
</reference>
<reference name="product.info.addtocart">
<block type="page/html_wrapper" name="product.info.addtocart.paypal.wrapper" translate="label">
<label>PayPal Express Checkout Shortcut Wrapper</label>
<block type="paypal/express_shortcut" name="product.info.addtocart.paypal" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
</block>
</block>
</reference>
<update handle="SHORTCUT_popup"/>
<reference name="right">
<block type="paypal/logo" name="paypal.partner.right.logo" template="paypal/partner/logo.phtml">
</block>
</reference>
<reference name="top.container">
<block type="paypal/bml_banners" name="bml.center.logo" template="paypal/bml.phtml">
<action method="setSection">
<section>productpage</section>
</action>
<action method="setPosition">
<position>0</position>
</action>
</block>
</reference>
<reference name="product.info.addtocart">
<block type="paypal/bml_banners" name="bml.right.logo" after="product.info.addtocart.paypal" template="paypal/bml.phtml">
<action method="setSection">
<section>productpage</section>
</action>
<action method="setPosition">
<position>1</position>
</action>
</block>
</reference>
<reference name="product.tooltip">
<block type="page/html_wrapper" name="product.info.addtocart.paypaluk.wrapper" translate="label">
<block type="paypaluk/express_shortcut" name="product.info.addtocart.paypaluk" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
<action method="setShowOrPosition">
<value>after</value>
</action>
</block>
</block>
</reference>
<reference name="product.info.addtocart">
<block type="page/html_wrapper" name="product.info.addtocart.paypaluk.wrapper" translate="label">
<label>PayPal Express Checkout (Payflow Edition) Shortcut Wrapper</label>
<action method="setHtmlTagName">
<tag>p</tag>
</action>
<action method="setElementClass">
<class>paypal-logo</class>
</action>
<block type="paypaluk/express_shortcut" name="product.info.addtocart.paypaluk" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
</block>
</block>
</reference>
<update handle="SHORTCUT_uk_popup"/>
<reference name="content">
<reference name="product.info">
<reference name="alert.urls">
<block type="productalert/product_view" name="productalert.price" as="productalert_price" template="productalert/product/view.phtml">
<action method="preparePriceAlertData"/>
<action method="setHtmlClass">
<value>alert-price link-price-alert</value>
</action>
<action method="setSignupLabel" translate="value">
<value>Sign up for price alert</value>
</action>
</block>
<block type="productalert/product_view" name="productalert.stock" as="productalert_stock" template="productalert/product/view.phtml">
<action method="prepareStockAlertData"/>
<action method="setHtmlClass">
<value>alert-stock link-stock-alert</value>
</action>
<action method="setSignupLabel" translate="value">
<value>Sign up to get notified when this product is back in stock</value>
</action>
</block>
</reference>
</reference>
</reference>
<reference name="catalog.product.related">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
<reference name="head">
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/product-media.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-list.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-product.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="alothemes/categorysearch/enabled">
<script>magiccart/plugin/jquery.ddslick.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/enabled">
<script>magiccart/jquery.alothemes.js</script>
</action>
</reference>
<update handle="alothemesdefault"/>
<reference name="product.info.upsell">
<action method="setTemplate">
<template>magiccart/alothemes/catalog/product/list/upsell.phtml</template>
</action>
<action method="setColumnCount">
<columns>8</columns>
</action>
<action method="setItemLimit">
<type>upsell</type>
<limit>10</limit>
</action>
</reference>
<reference name="product.info.related">
<action method="setTemplate">
<template>magiccart/alothemes/catalog/product/list/related.phtml</template>
</action>
<action method="setColumnCount">
<columns>4</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>3</limit>
</action>
</reference>
<label>Catalog Product View (Simple)</label>
<reference name="product.info">
<block type="catalog/product_view_type_simple" name="product.info.simple" as="product_type_data" template="catalog/product/view/type/default.phtml">
<block type="core/text_list" name="product.info.simple.extra" as="product_type_data_extra" translate="label">
<label>Product Extra Info</label>
</block>
</block>
<block type="catalog/product_view_type_simple" name="product.info.availability" as="product_type_availability" template="catalog/product/view/type/availability/default.phtml"/>
</reference>
<reference name="product.info.simple.extra">
<block type="cataloginventory/stockqty_default" template="cataloginventory/stockqty/default.phtml"/>
</reference>
<reference name="product.info.upsell">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
<action method="setItemLimit">
<type>bundle</type>
<limit>4</limit>
</action>
</reference>
<reference name="top.links">
<action method="addLink" translate="label title" module="customer">
<label>Log In</label>
<url helper="customer/getLoginUrl"/>
<title>Log In</title>
<prepare/>
<urlParams/>
<position>100</position>
</action>
</reference>
<remove name="reorder"/></layout>
| # | Update |
|---|---|
| 0. |
<block name="formkey" type="core/template" template="core/formkey.phtml"/>
|
| 1. |
<label>All Pages</label>
<block type="page/html" name="root" output="toHtml" template="page/3columns.phtml">
<block type="page/html_head" name="head" as="head">
<action method="addJs">
<script>prototype/prototype.js</script>
</action>
<action method="addJs">
<script>lib/ccard.js</script>
</action>
<action method="addJs">
<script>prototype/validation.js</script>
</action>
<action method="addJs">
<script>scriptaculous/builder.js</script>
</action>
<action method="addJs">
<script>scriptaculous/effects.js</script>
</action>
<action method="addJs">
<script>scriptaculous/dragdrop.js</script>
</action>
<action method="addJs">
<script>scriptaculous/controls.js</script>
</action>
<action method="addJs">
<script>scriptaculous/slider.js</script>
</action>
<action method="addJs">
<script>varien/js.js</script>
</action>
<action method="addJs">
<script>varien/form.js</script>
</action>
<action method="addJs">
<script>varien/menu.js</script>
</action>
<action method="addJs">
<script>mage/translate.js</script>
</action>
<action method="addJs">
<script>mage/cookies.js</script>
</action>
<block type="page/js_cookie" name="js_cookies" template="page/js/cookie.phtml"/>
<action method="addJs">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs">
<script>magiccart/bootstrap/bootstrap.min.js</script>
</action>
<action method="addJs">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/modernizr.custom.min.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/selectivizr.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/matchMedia.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/matchMedia.addListener.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/enquire.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/app.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/lib/imagesloaded.js</name>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/bootstrap/html5shiv.js</name>
<if>lt IE 9</if>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/bootstrap/respond.min.js</name>
<if>lt IE 9</if>
</action>
<action method="addItem">
<type>js</type>
<name>magiccart/elegantfont/lte-ie7.js</name>
<if>lt IE 7</if>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/fontawesome-4.5.0/css/font-awesome.min.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/elegantfont/css/elegantfont.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/webfont/css/simple-line-icons.css</stylesheet>
</action>
<action method="addItem">
<type>skin_css</type>
<name>magiccart/plugin/css/bootstrap/bootstrap.min.css</name>
<params/>
</action>
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>css/styles.css</stylesheet>
</action>
<action method="addItem">
<type>skin_css</type>
<name>css/styles-ie.css</name>
<params/>
<if>lt IE 8</if>
</action>
<action method="addCss">
<stylesheet>css/widgets.css</stylesheet>
</action>
<action method="addCss">
<stylesheet>css/print.css</stylesheet>
<params>media="print"</params>
</action>
<action method="addItem">
<type>js</type>
<name>lib/ds-sleight.js</name>
<params/>
<if>lt IE 7</if>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/ie6.js</name>
<params/>
<if>lt IE 7</if>
</action>
</block>
<block type="core/text_list" name="after_body_start" as="after_body_start" translate="label">
<label>Page Top</label>
</block>
<block type="page/html_notices" name="global_notices" as="global_notices" template="page/html/notices.phtml"/>
<block type="page/html_header" name="header" as="header">
<block type="page/template_links" name="top.links" as="topLinks"/>
<block type="page/switch" name="store_language" as="store_language" template="page/switch/languages.phtml"/>
<block type="directory/currency" name="currency" as="currency" template="directory/currency.phtml"/>
<block type="core/text_list" name="top.menu" as="topMenu" translate="label">
<label>Navigation Bar</label>
<block type="page/html_topmenu" name="catalog.topnav" template="page/html/topmenu.phtml"/>
</block>
<block type="core/text_list" name="top_verticalmenu" as="top_verticalmenu" translate="label">
<block type="core/template" name="verticalmenu" template="magiccart/magicmenu/verticalmenu.phtml">
</block>
</block>
<block type="page/html_wrapper" name="top.container" as="topContainer" translate="label">
<label>Page Header</label>
<action method="setElementClass">
<value>top-container</value>
</action>
</block>
<block type="page/html_welcome" name="welcome" as="welcome"/>
</block>
<block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>
<block type="core/text_list" name="left_first" as="left_first" translate="label">
<label>Left Column First (shows above main column on smaller screens)</label>
</block>
<block type="core/text_list" name="left_top" as="left_top" translate="label">
<label>Left Top Column</label>
</block>
<block type="core/text_list" name="left_bottom" as="left_bottom" translate="label">
<label>Left Bottom Column</label>
</block>
<block type="core/text_list" name="right_top" as="right_top" translate="label">
<label>Right Top Column</label>
</block>
<block type="core/text_list" name="content_heading" as="content_heading" translate="label">
<label>Content Heading</label>
</block>
<block type="core/text_list" name="slide_home" as="slide_home" translate="label">
<label>Slide Home</label>
</block>
<block type="core/text_list" name="block_top" as="block_top" translate="label">
<label>Block Top</label>
</block>
<block type="core/text_list" name="block_right" as="block_right" translate="label">
<label>Block Right</label>
</block>
<block type="core/text_list" name="left" as="left" translate="label">
<label>Left Column</label>
</block>
<block type="core/messages" name="global_messages" as="global_messages"/>
<block type="core/messages" name="messages" as="messages"/>
<block type="core/text_list" name="content" as="content" translate="label">
<label>Main Content Area</label>
</block>
<block type="core/text_list" name="right" as="right" translate="label">
<label>Right Column</label>
</block>
<block type="core/text_list" name="right_bottom" as="right_bottom" translate="label">
<label>Right Bottom Column</label>
</block>
<block type="page/html_footer" name="footer" as="footer" template="page/html/footer.phtml">
<block type="page/html_wrapper" name="bottom.container" as="bottomContainer" translate="label">
<label>Page Footer</label>
<action method="setElementClass">
<value>bottom-container</value>
</action>
</block>
<block type="page/switch" name="store_switcher" as="store_switcher" template="page/switch/stores.phtml"/>
<block type="page/template_links" name="footer_links" as="footer_links" template="page/template/links.phtml"/>
</block>
<block type="core/text_list" name="before_body_end" as="before_body_end" translate="label">
<label>Page Bottom</label>
<block type="page/html_cookieNotice" name="global_cookie_notice" as="global_cookie_notice" template="page/html/cookienotice.phtml" before="-"/>
</block>
</block>
<block type="core/profiler" output="toHtml" name="core_profiler"/>
|
| 2. |
<reference name="head">
<block type="core/template" name="optional_zip_countries" as="optional_zip_countries" template="directory/js/optional_zip_countries.phtml"/>
</reference>
|
| 3. |
<reference name="footer">
<block type="cms/block" name="cms_footer_links" before="footer_links">
<action method="setBlockId">
<block_id>footer_links</block_id>
</action>
</block>
<block type="cms/block" name="block_footer_top" as="block_footer_top">
<action method="setBlockId">
<block_id>block_footer_top</block_id>
</action>
</block>
<block type="cms/block" name="block_footer_bottom" as="block_footer_bottom">
<action method="setBlockId">
<block_id>block_footer_bottom</block_id>
</action>
</block>
</reference>
|
| 4. |
<reference name="top.links">
<action method="addLink" translate="label title" module="customer">
<label>My Account</label>
<url helper="customer/getAccountUrl"/>
<title>My Account</title>
<prepare/>
<urlParams/>
<position>10</position>
</action>
</reference>
|
| 5. |
<reference name="root">
<action method="setTemplate">
<template>page/2columns-left.phtml</template>
</action>
<block type="core/text_list" name="support" as="support" translate="label"/>
<remove name="right_top"/>
</reference>
<reference name="left">
<block type="catalog/product_compare_sidebar" before="cart_sidebar" name="catalog.compare.sidebar" template="catalog/product/compare/sidebar.phtml"/>
<remove name="left.newsletter"/>
<remove name="tags_popular"/>
</reference>
<reference name="right">
<remove name="right.poll"/>
<remove name="wishlist_sidebar"/>
<remove name="right.reports.product.viewed"/>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="catalog" ifconfig="catalog/seo/site_map">
<label>Site Map</label>
<url helper="catalog/map/getCategoryUrl"/>
<title>Site Map</title>
</action>
</reference>
<block type="catalog/product_price_template" name="catalog_product_price_template"/>
|
| 6. |
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp.phtml</template>
</action>
<action method="addPriceBlockType">
<type>msrp_item</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
<action method="addPriceBlockType">
<type>msrp_noform</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_noform.phtml</template>
</action>
</reference>
|
| 7. |
<reference name="header">
<block type="core/template" name="top.search" as="topSearch" template="catalogsearch/form.mini.phtml"/>
</reference>
<reference name="footer_links">
<action method="addLink" translate="label title" module="catalogsearch" ifconfig="catalog/seo/search_terms">
<label>Search Terms</label>
<url helper="catalogsearch/getSearchTermUrl"/>
<title>Search Terms</title>
</action>
<action method="addLink" translate="label title" module="catalogsearch">
<label>Advanced Search</label>
<url helper="catalogsearch/getAdvancedSearchUrl"/>
<title>Advanced Search</title>
</action>
</reference>
|
| 8. |
<reference name="top.links">
<block type="checkout/links" name="checkout_cart_link">
<action method="addCheckoutLink"/>
</block>
</reference>
<reference name="right">
</reference>
|
| 9. |
<reference name="topCart.extra_actions">
<block type="paypal/express_shortcut" name="paypal.partner.top_cart.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="cart_sidebar.extra_actions">
<block type="paypal/express_shortcut" name="paypal.partner.cart_sidebar.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
|
| 10. |
<reference name="right">
<block type="poll/activePoll" name="right.poll">
<action method="setPollTemplate">
<template>poll/active.phtml</template>
<type>poll</type>
</action>
<action method="setPollTemplate">
<template>poll/result.phtml</template>
<type>results</type>
</action>
</block>
</reference>
|
| 11. |
<reference name="right">
<block type="reports/product_viewed" before="right.permanent.callout" name="right.reports.product.viewed" template="reports/product_viewed.phtml"/>
<block type="reports/product_compared" before="right.permanent.callout" name="right.reports.product.compared" template="reports/product_compared.phtml"/>
</reference>
|
| 12. |
<reference name="head" before="-">
<block type="googleanalytics/ga" name="google_analytics" as="google_analytics" template="googleanalytics/ga.phtml"/>
</reference>
|
| 13. |
<reference name="topCart.extra_actions">
<block type="paypaluk/express_shortcut" name="paypaluk.partner.top_cart.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
<reference name="cart_sidebar.extra_actions">
<block type="paypaluk/express_shortcut" name="paypaluk.partner.cart_sidebar.shortcut" template="paypal/express/shortcut.phtml"/>
</reference>
|
| 14. |
<reference name="footer_links">
<action method="addLink" translate="label title" module="contacts" ifconfig="contacts/contacts/enabled">
<label>Contact Us</label>
<url>contacts</url>
<title>Contact Us</title>
<prepare>true</prepare>
</action>
</reference>
|
| 15. |
<reference name="footer_links">
<action method="addLink" translate="label title" module="rss" ifconfig="rss/config/active">
<label>RSS</label>
<url>rss</url>
<title>RSS</title>
<prepare>true</prepare>
<urlParams/>
<position/>
<li/>
<a>class="link-rss"</a>
</action>
</reference>
<block type="rss/list" name="head_rss" ifconfig="rss/config/active"/>
|
| 16. |
<reference name="cart_sidebar">
<action method="addItemRender">
<type>bundle</type>
<block>bundle/checkout_cart_item_renderer</block>
<template>checkout/cart/sidebar/default.phtml</template>
</action>
</reference>
<reference name="wishlist_sidebar">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
|
| 17. |
<reference name="left">
<block type="newsletter/subscribe" name="left.newsletter" template="newsletter/subscribe.phtml"/>
</reference>
|
| 18. |
|
| 19. |
<reference name="head">
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/product-media.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-list.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-product.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="alothemes/categorysearch/enabled">
<script>magiccart/plugin/jquery.ddslick.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/enabled">
<script>magiccart/jquery.alothemes.js</script>
</action>
</reference>
|
| 20. |
<update handle="alothemesdefault"/>
<block type="alothemes/themecfg" name="themecfg" template="magiccart/alothemes/themecfg.phtml"/>
<reference name="head">
<action method="append" ifconfig="alothemes/general/enabled">
<block>themecfg</block>
</action>
</reference>
<reference name="top.search">
<action method="setTemplate" ifconfig="alothemes/categorysearch/enabled">
<template>magiccart/alothemes/categorysearch/form.phtml</template>
</action>
</reference>
|
| 21. |
<reference name="head">
<action method="addCss" ifconfig="magicsocial/general/enabled">
<stylesheet>magiccart/magicsocial/css/magicsocial.css</stylesheet>
</action>
<action method="addJs" ifconfig="magicsocial/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="magicsocial/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="magicsocial/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
</reference>
<block type="magicsocial/social" name="social" template="magiccart/magicsocial/social.phtml"/>
<reference name="after_body_start">
<action ifconfig="magicsocial/social/enabled" method="insert">
<block>social</block>
</action>
</reference>
|
| 22. |
<reference name="top.links">
<action method="addLink" translate="label title" module="testimonial" ifconfig="testimonial/general/topLink">
<label>Testimonial</label>
<url>testimonial</url>
<title>Testimonial</title>
<prepare>true</prepare>
<urlParams/>
<position>0</position>
</action>
</reference>
|
| 23. |
<reference name="before_body_end">
<block type="debug/debug" name="debug_panels" template="debug/debug.phtml">
<block type="debug/versions" name="debug_versions_panel" template="debug/versions.phtml"/>
<block type="debug/config" name="debug_config_panel" template="debug/config.phtml"/>
<block type="debug/blocks" name="debug_blocks_panel" template="debug/blocks.phtml"/>
<block type="debug/controller" name="debug_controller_panel" template="debug/controller.phtml"/>
<block type="debug/models" name="debug_models_panel" template="debug/models.phtml"/>
<block type="core/template" name="debug_layout_panel" template="debug/layout.phtml"/>
<block type="core/template" name="debug_performance_panel" template="debug/performance.phtml"/>
<block type="core/template" name="debug_utils_panel" template="debug/utils.phtml"/>
</block>
</reference>
|
| 24. |
<label>Catalog Product View (Any)</label>
<reference name="root">
<action method="setTemplate">
<template>page/2columns-right.phtml</template>
</action>
<block type="core/text_list" name="support" as="support" translate="label"/>
</reference>
<reference name="head">
<action method="addJs">
<script>varien/product.js</script>
</action>
<action method="addJs">
<script>varien/configurable.js</script>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addItem">
<type>js_css</type>
<name>calendar/calendar-win2k-1.css</name>
<params/>
</action>
<action method="addItem">
<type>js</type>
<name>calendar/calendar.js</name>
</action>
<action method="addItem">
<type>js</type>
<name>calendar/calendar-setup.js</name>
</action>
</reference>
<reference name="content">
<block type="catalog/product_view" name="product.info" template="catalog/product/view.phtml">
<block type="catalog/product_view_media" name="product.info.media" as="media" template="catalog/product/view/media.phtml">
<block type="core/text_list" name="product.info.media.after" as="after"/>
</block>
<block type="core/text_list" name="alert.urls" as="alert_urls" translate="label">
<label>Alert Urls</label>
</block>
<action method="setTierPriceTemplate">
<template>catalog/product/view/tierprices.phtml</template>
</action>
<block type="catalog/product_list_upsell" name="product.info.upsell" as="upsell_products" template="catalog/product/list/upsell.phtml">
<action method="setColumnCount">
<columns>6</columns>
</action>
<action method="setItemLimit">
<type>upsell</type>
<limit>6</limit>
</action>
</block>
<block type="catalog/product_view_additional" name="product.info.additional" as="product_additional_data"/>
<block type="catalog/product_view_description" name="product.description" as="description" template="catalog/product/view/description.phtml">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Description</value>
</action>
</block>
<block type="catalog/product_view_attributes" name="product.attributes" as="additional" template="catalog/product/view/attributes.phtml">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Additional Information</value>
</action>
</block>
<block type="review/product_view_list" name="product.reviews" as="reviews" template="review/product/view/list.phtml" after="additional">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Reviews</value>
</action>
</block>
<block type="core/template" name="customtab" as="customtab" template="catalog/product/view/customtab.phtml" after="additional">
<action method="addToParentGroup">
<group>detailed_info</group>
</action>
<action method="setTitle" translate="value">
<value>Custom Tab</value>
</action>
</block>
<block type="catalog/product_list_related" name="catalog.product.related" as="related_products" template="catalog/product/list/related.phtml"/>
<block type="catalog/product_list_related" name="product.info.related" as="related" template="catalog/product/list/related.phtml">
<action method="setColumnCount">
<columns>6</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>6</limit>
</action>
</block>
<block type="catalog/product_view" name="product.info.addto" as="addto" template="catalog/product/view/addto.phtml"/>
<block type="catalog/product_view" name="product.info.sharing" as="sharing" template="catalog/product/view/sharing.phtml"/>
<block type="catalog/product_view" name="product.info.addtocart" as="addtocart" template="catalog/product/view/addtocart.phtml"/>
<block type="core/text_list" name="product.info.extrahint" as="extrahint" translate="label">
<label>Product View Extra Hint</label>
</block>
<block type="catalog/product_view" name="product.info.options.wrapper" as="product_options_wrapper" template="catalog/product/view/options/wrapper.phtml" translate="label">
<label>Info Column Options Wrapper</label>
<block type="core/template" name="options_js" template="catalog/product/view/options/js.phtml"/>
<block type="catalog/product_view_options" name="product.info.options" as="product_options" template="catalog/product/view/options.phtml">
<action method="addOptionRenderer">
<type>text</type>
<block>catalog/product_view_options_type_text</block>
<template>catalog/product/view/options/type/text.phtml</template>
</action>
<action method="addOptionRenderer">
<type>file</type>
<block>catalog/product_view_options_type_file</block>
<template>catalog/product/view/options/type/file.phtml</template>
</action>
<action method="addOptionRenderer">
<type>select</type>
<block>catalog/product_view_options_type_select</block>
<template>catalog/product/view/options/type/select.phtml</template>
</action>
<action method="addOptionRenderer">
<type>date</type>
<block>catalog/product_view_options_type_date</block>
<template>catalog/product/view/options/type/date.phtml</template>
</action>
</block>
<block type="core/html_calendar" name="html_calendar" as="html_calendar" template="page/js/calendar.phtml"/>
</block>
<block type="catalog/product_view" name="product.info.options.wrapper.bottom" as="product_options_wrapper_bottom" template="catalog/product/view/options/wrapper/bottom.phtml" translate="label">
<label>Bottom Block Options Wrapper</label>
<action method="insert">
<block>product.tierprices</block>
</action>
<block type="catalog/product_view" name="product.clone_prices" as="prices" template="catalog/product/view/price_clone.phtml"/>
<action method="append">
<block>product.info.addtocart</block>
</action>
<action method="append">
<block>product.info.addto</block>
</action>
<action method="append">
<block>product.info.sharing</block>
</action>
</block>
<block type="core/template_facade" name="product.info.container1" as="container1">
<action method="setDataByKey">
<key>alias_in_layout</key>
<value>container1</value>
</action>
<action method="setDataByKeyFromRegistry">
<key>options_container</key>
<key_in_registry>product</key_in_registry>
</action>
<action method="append">
<block>product.info.options.wrapper</block>
</action>
<action method="append">
<block>product.info.options.wrapper.bottom</block>
</action>
</block>
<block type="core/template_facade" name="product.info.container2" as="container2">
<action method="setDataByKey">
<key>alias_in_layout</key>
<value>container2</value>
</action>
<action method="setDataByKeyFromRegistry">
<key>options_container</key>
<key_in_registry>product</key_in_registry>
</action>
<action method="append">
<block>product.info.options.wrapper</block>
</action>
<action method="append">
<block>product.info.options.wrapper.bottom</block>
</action>
</block>
<action method="unsetCallChild">
<child>container1</child>
<call>ifEquals</call>
<if>0</if>
<key>alias_in_layout</key>
<key>options_container</key>
</action>
<action method="unsetCallChild">
<child>container2</child>
<call>ifEquals</call>
<if>0</if>
<key>alias_in_layout</key>
<key>options_container</key>
</action>
</block>
</reference>
<reference name="support">
<block type="cms/block" name="support_category">
<action method="setBlockId">
<block_id>support-category</block_id>
</action>
</block>
</reference>
<reference name="left">
<block type="catalog/product_list_related" name="catalog.product.related" as="related_products" template="catalog/product/list/related.phtml">
<action method="setColumnCount">
<columns>3</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>3</limit>
</action>
</block>
</reference>
<reference name="right_top">
<block type="catalog/navigation" name="catalog.leftnav" after="currency" template="catalog/navigation/left.phtml">
<block type="core/text_list" name="catalog.leftnav.state.renderers" as="state_renderers"/>
</block>
</reference>
<reference name="right_bottom">
<block type="cms/block" name="sale">
<action method="setBlockId">
<block_id>sales_product</block_id>
</action>
</block>
<block type="cms/block" name="img_right_bottom">
<action method="setBlockId">
<block_id>image</block_id>
</action>
</block>
</reference>
|
| 25. |
<reference name="head">
<action method="addItem" ifconfig="sales/msrp/enabled">
<type>skin_js</type>
<name>js/msrp.js</name>
</action>
</reference>
<reference name="content">
<block type="core/template" template="catalog/msrp/popup.phtml" name="product.tooltip"/>
</reference>
|
| 26. |
<reference name="catalog_product_price_template">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
</reference>
<reference name="product.clone_prices">
<action method="addPriceBlockType">
<type>msrp</type>
<block>catalog/product_price</block>
<template>catalog/product/price_msrp_item.phtml</template>
</action>
</reference>
|
| 27. |
<update handle="MAP_popup"/>
<update handle="MAP_price_msrp_item"/>
|
| 28. |
<reference name="product.info.extrahint">
<block type="cataloginventory/qtyincrements" name="product.info.extrahint.qtyincrements" template="cataloginventory/qtyincrements.phtml"/>
</reference>
|
| 29. |
<reference name="product.tooltip">
<block type="page/html_wrapper" name="product.info.addtocart.paypal.wrapper" translate="label">
<block type="paypal/express_shortcut" name="product.info.addtocart.paypal" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
<action method="setShowOrPosition">
<value>after</value>
</action>
</block>
</block>
</reference>
|
| 30. |
<reference name="product.info.addtocart">
<block type="page/html_wrapper" name="product.info.addtocart.paypal.wrapper" translate="label">
<label>PayPal Express Checkout Shortcut Wrapper</label>
<block type="paypal/express_shortcut" name="product.info.addtocart.paypal" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
</block>
</block>
</reference>
<update handle="SHORTCUT_popup"/>
<reference name="right">
<block type="paypal/logo" name="paypal.partner.right.logo" template="paypal/partner/logo.phtml">
</block>
</reference>
|
| 31. |
<reference name="top.container">
<block type="paypal/bml_banners" name="bml.center.logo" template="paypal/bml.phtml">
<action method="setSection">
<section>productpage</section>
</action>
<action method="setPosition">
<position>0</position>
</action>
</block>
</reference>
<reference name="product.info.addtocart">
<block type="paypal/bml_banners" name="bml.right.logo" after="product.info.addtocart.paypal" template="paypal/bml.phtml">
<action method="setSection">
<section>productpage</section>
</action>
<action method="setPosition">
<position>1</position>
</action>
</block>
</reference>
|
| 32. |
<reference name="product.tooltip">
<block type="page/html_wrapper" name="product.info.addtocart.paypaluk.wrapper" translate="label">
<block type="paypaluk/express_shortcut" name="product.info.addtocart.paypaluk" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
<action method="setShowOrPosition">
<value>after</value>
</action>
</block>
</block>
</reference>
|
| 33. |
<reference name="product.info.addtocart">
<block type="page/html_wrapper" name="product.info.addtocart.paypaluk.wrapper" translate="label">
<label>PayPal Express Checkout (Payflow Edition) Shortcut Wrapper</label>
<action method="setHtmlTagName">
<tag>p</tag>
</action>
<action method="setElementClass">
<class>paypal-logo</class>
</action>
<block type="paypaluk/express_shortcut" name="product.info.addtocart.paypaluk" template="paypal/express/shortcut.phtml">
<action method="setIsInCatalogProduct">
<value>1</value>
</action>
</block>
</block>
</reference>
<update handle="SHORTCUT_uk_popup"/>
|
| 34. |
<reference name="content">
<reference name="product.info">
<reference name="alert.urls">
<block type="productalert/product_view" name="productalert.price" as="productalert_price" template="productalert/product/view.phtml">
<action method="preparePriceAlertData"/>
<action method="setHtmlClass">
<value>alert-price link-price-alert</value>
</action>
<action method="setSignupLabel" translate="value">
<value>Sign up for price alert</value>
</action>
</block>
<block type="productalert/product_view" name="productalert.stock" as="productalert_stock" template="productalert/product/view.phtml">
<action method="prepareStockAlertData"/>
<action method="setHtmlClass">
<value>alert-stock link-stock-alert</value>
</action>
<action method="setSignupLabel" translate="value">
<value>Sign up to get notified when this product is back in stock</value>
</action>
</block>
</reference>
</reference>
</reference>
|
| 35. |
<reference name="catalog.product.related">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
</reference>
|
| 36. |
<reference name="head">
<action method="addCss">
<stylesheet>magiccart/plugin/css/jquery.bxslider.css</stylesheet>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/product-media.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-list.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<name>js/configurableswatches/swatches-product.js</name>
</action>
<action method="addItem">
<type>skin_js</type>
<script>js/lib/elevatezoom/jquery.elevateZoom-3.0.8.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.min.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/jquery">
<script>magiccart/jquery.noconflict.js</script>
</action>
<action method="addJs" ifconfig="alothemes/categorysearch/enabled">
<script>magiccart/plugin/jquery.ddslick.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.easing.min.js</script>
</action>
<action method="addJs" ifconfig="magicslider/general/enabled">
<script>magiccart/plugin/jquery.bxslider.js</script>
</action>
<action method="addJs" ifconfig="alothemes/general/enabled">
<script>magiccart/jquery.alothemes.js</script>
</action>
</reference>
|
| 37. |
<update handle="alothemesdefault"/>
<reference name="product.info.upsell">
<action method="setTemplate">
<template>magiccart/alothemes/catalog/product/list/upsell.phtml</template>
</action>
<action method="setColumnCount">
<columns>8</columns>
</action>
<action method="setItemLimit">
<type>upsell</type>
<limit>10</limit>
</action>
</reference>
<reference name="product.info.related">
<action method="setTemplate">
<template>magiccart/alothemes/catalog/product/list/related.phtml</template>
</action>
<action method="setColumnCount">
<columns>4</columns>
</action>
<action method="setItemLimit">
<type>related</type>
<limit>3</limit>
</action>
</reference>
|
| 38. |
<label>Catalog Product View (Simple)</label>
<reference name="product.info">
<block type="catalog/product_view_type_simple" name="product.info.simple" as="product_type_data" template="catalog/product/view/type/default.phtml">
<block type="core/text_list" name="product.info.simple.extra" as="product_type_data_extra" translate="label">
<label>Product Extra Info</label>
</block>
</block>
<block type="catalog/product_view_type_simple" name="product.info.availability" as="product_type_availability" template="catalog/product/view/type/availability/default.phtml"/>
</reference>
|
| 39. |
<reference name="product.info.simple.extra">
<block type="cataloginventory/stockqty_default" template="cataloginventory/stockqty/default.phtml"/>
</reference>
|
| 40. |
<reference name="product.info.upsell">
<action method="addPriceBlockType">
<type>bundle</type>
<block>bundle/catalog_product_price</block>
<template>bundle/catalog/product/price.phtml</template>
</action>
<action method="setItemLimit">
<type>bundle</type>
<limit>4</limit>
</action>
</reference>
|
| 41. |
<reference name="top.links">
<action method="addLink" translate="label title" module="customer">
<label>Log In</label>
<url helper="customer/getLoginUrl"/>
<title>Log In</title>
<prepare/>
<urlParams/>
<position>100</position>
</action>
</reference>
<remove name="reorder"/>
|
List of all rendered blocks.
List of all the instantiated blocks, few of them might not be rendered.
| # | name in layout | block class | template |
|---|---|---|---|
| 0 | formkey | Mage_Core_Block_Template | frontend/base/default/template/core/formkey.phtml |
| 1 | root | Mage_Page_Block_Html | frontend/alogg/default/template/page/2columns-right.phtml |
| 2 | head | Mage_Page_Block_Html_Head | frontend/alogg/default/template/page/html/head.phtml |
| 3 | js_cookies | Mage_Page_Block_Js_Cookie | frontend/alogg/default/template/page/js/cookie.phtml |
| 4 | after_body_start | Mage_Core_Block_Text_List | |
| 5 | global_notices | Mage_Page_Block_Html_Notices | frontend/alogg/default/template/page/html/notices.phtml |
| 6 | header | Mage_Page_Block_Html_Header | frontend/alogg/default/template/page/html/header.phtml |
| 7 | top.links | Mage_Page_Block_Template_Links | frontend/alogg/default/template/page/template/links.phtml |
| 8 | store_language | Mage_Page_Block_Switch | frontend/alogg/default/template/page/switch/languages.phtml |
| 9 | currency | Mage_Directory_Block_Currency | frontend/alogg/default/template/directory/currency.phtml |
| 10 | top.menu | Mage_Core_Block_Text_List | |
| 11 | catalog.topnav | Mage_Page_Block_Html_Topmenu | frontend/alogg/default/template/page/html/topmenu.phtml |
| 12 | top_verticalmenu | Mage_Core_Block_Text_List | |
| 13 | verticalmenu | Mage_Core_Block_Template | frontend/alogg/default/template/magiccart/magicmenu/verticalmenu.phtml |
| 14 | top.container | Mage_Page_Block_Html_Wrapper | |
| 15 | welcome | Mage_Page_Block_Html_Welcome | frontend/alogg/default/template/ |
| 16 | breadcrumbs | Mage_Page_Block_Html_Breadcrumbs | frontend/alogg/default/template/page/html/breadcrumbs.phtml |
| 17 | left_first | Mage_Core_Block_Text_List | |
| 18 | left_top | Mage_Core_Block_Text_List | |
| 19 | left_bottom | Mage_Core_Block_Text_List | |
| 20 | content_heading | Mage_Core_Block_Text_List | |
| 21 | slide_home | Mage_Core_Block_Text_List | |
| 22 | block_top | Mage_Core_Block_Text_List | |
| 23 | block_right | Mage_Core_Block_Text_List | |
| 24 | left | Mage_Core_Block_Text_List | |
| 25 | global_messages | Mage_Core_Block_Messages | frontend/alogg/default/template/ |
| 26 | messages | Mage_Core_Block_Messages | frontend/alogg/default/template/ |
| 27 | content | Mage_Core_Block_Text_List | |
| 28 | right | Mage_Core_Block_Text_List | |
| 29 | right_bottom | Mage_Core_Block_Text_List | |
| 30 | footer | Mage_Page_Block_Html_Footer | frontend/alogg/default/template/page/html/footer.phtml |
| 31 | bottom.container | Mage_Page_Block_Html_Wrapper | |
| 32 | store_switcher | Mage_Page_Block_Switch | frontend/alogg/default/template/page/switch/stores.phtml |
| 33 | footer_links | Mage_Page_Block_Template_Links | frontend/alogg/default/template/page/template/links.phtml |
| 34 | before_body_end | Mage_Core_Block_Text_List | |
| 35 | global_cookie_notice | Mage_Page_Block_Html_CookieNotice | frontend/alogg/default/template/page/html/cookienotice.phtml |
| 36 | core_profiler | Mage_Core_Block_Profiler | |
| 37 | optional_zip_countries | Mage_Core_Block_Template | frontend/alogg/default/template/directory/js/optional_zip_countries.phtml |
| 38 | cms_footer_links | Mage_Cms_Block_Block | |
| 39 | block_footer_top | Mage_Cms_Block_Block | |
| 40 | block_footer_bottom | Mage_Cms_Block_Block | |
| 41 | support | Mage_Core_Block_Text_List | |
| 42 | catalog.compare.sidebar | Mage_Catalog_Block_Product_Compare_Sidebar | frontend/alogg/default/template/catalog/product/compare/sidebar.phtml |
| 43 | catalog_product_price_template | Mage_Catalog_Block_Product_Price_Template | |
| 44 | top.search | Mage_Core_Block_Template | frontend/alogg/default/template/catalogsearch/form.mini.phtml |
| 45 | checkout_cart_link | Mage_Checkout_Block_Links | frontend/alogg/default/template/ |
| 46 | paypal.partner.top_cart.shortcut | Mage_Paypal_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 47 | paypal.partner.cart_sidebar.shortcut | Mage_Paypal_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 48 | right.reports.product.compared | Mage_Reports_Block_Product_Compared | frontend/base/default/template/reports/product_compared.phtml |
| 49 | google_analytics | Mage_GoogleAnalytics_Block_Ga | frontend/base/default/template/googleanalytics/ga.phtml |
| 50 | paypaluk.partner.top_cart.shortcut | Mage_PaypalUk_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 51 | paypaluk.partner.cart_sidebar.shortcut | Mage_PaypalUk_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 52 | head_rss | Mage_Rss_Block_List | frontend/alogg/default/template/ |
| 53 | themecfg | Magiccart_Alothemes_Block_Themecfg | frontend/alogg/default/template/magiccart/alothemes/themecfg.phtml |
| 54 | social | Magiccart_Magicsocial_Block_Social | frontend/alogg/default/template/magiccart/magicsocial/social.phtml |
| 55 | debug_panels | Magneto_Debug_Block_Debug | frontend/base/default/template/debug/debug.phtml |
| 56 | debug_versions_panel | Magneto_Debug_Block_Versions | frontend/base/default/template/debug/versions.phtml |
| 57 | debug_config_panel | Magneto_Debug_Block_Config | frontend/base/default/template/debug/config.phtml |
| 58 | debug_blocks_panel | Magneto_Debug_Block_Blocks | frontend/base/default/template/debug/blocks.phtml |
| 59 | debug_controller_panel | Magneto_Debug_Block_Controller | frontend/base/default/template/debug/controller.phtml |
| 60 | debug_models_panel | Magneto_Debug_Block_Models | frontend/base/default/template/debug/models.phtml |
| 61 | debug_layout_panel | Mage_Core_Block_Template | frontend/base/default/template/debug/layout.phtml |
| 62 | debug_performance_panel | Mage_Core_Block_Template | frontend/base/default/template/debug/performance.phtml |
| 63 | debug_utils_panel | Mage_Core_Block_Template | frontend/base/default/template/debug/utils.phtml |
| 64 | ANONYMOUS_64 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 65 | product.info | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view.phtml |
| 66 | product.info.media | Mage_Catalog_Block_Product_View_Media | frontend/alogg/default/template/catalog/product/view/media.phtml |
| 67 | product.info.media.after | Mage_Core_Block_Text_List | |
| 68 | alert.urls | Mage_Core_Block_Text_List | |
| 69 | product.info.upsell | Mage_Catalog_Block_Product_List_Upsell | frontend/alogg/default/template/magiccart/alothemes/catalog/product/list/upsell.phtml |
| 70 | product.info.additional | Mage_Catalog_Block_Product_View_Additional | frontend/alogg/default/template/catalog/product/view/additional.phtml |
| 71 | product.description | Mage_Catalog_Block_Product_View_Description | frontend/alogg/default/template/catalog/product/view/description.phtml |
| 72 | product.attributes | Mage_Catalog_Block_Product_View_Attributes | frontend/alogg/default/template/catalog/product/view/attributes.phtml |
| 73 | ANONYMOUS_73 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 74 | product.reviews | Mage_Review_Block_Product_View_List | frontend/alogg/default/template/review/product/view/list.phtml |
| 75 | customtab | Mage_Core_Block_Template | frontend/alogg/default/template/catalog/product/view/customtab.phtml |
| 76 | catalog.product.related | Mage_Catalog_Block_Product_List_Related | frontend/alogg/default/template/catalog/product/list/related.phtml |
| 77 | product.info.related | Mage_Catalog_Block_Product_List_Related | frontend/alogg/default/template/magiccart/alothemes/catalog/product/list/related.phtml |
| 78 | ANONYMOUS_78 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 79 | product.info.addto | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view/addto.phtml |
| 80 | ANONYMOUS_80 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 81 | product.info.sharing | Mage_Catalog_Block_Product_View | frontend/base/default/template/catalog/product/view/sharing.phtml |
| 82 | ANONYMOUS_82 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 83 | product.info.addtocart | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view/addtocart.phtml |
| 84 | product.info.extrahint | Mage_Core_Block_Text_List | |
| 85 | ANONYMOUS_85 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 86 | product.info.options.wrapper | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view/options/wrapper.phtml |
| 87 | options_js | Mage_Core_Block_Template | frontend/alogg/default/template/catalog/product/view/options/js.phtml |
| 88 | product.info.options | Mage_Catalog_Block_Product_View_Options | frontend/alogg/default/template/catalog/product/view/options.phtml |
| 89 | html_calendar | Mage_Core_Block_Html_Calendar | frontend/alogg/default/template/page/js/calendar.phtml |
| 90 | ANONYMOUS_90 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 91 | product.info.options.wrapper.bottom | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view/options/wrapper/bottom.phtml |
| 92 | ANONYMOUS_92 | Mage_Catalog_Block_Breadcrumbs | frontend/alogg/default/template/ |
| 93 | product.clone_prices | Mage_Catalog_Block_Product_View | frontend/alogg/default/template/catalog/product/view/price_clone.phtml |
| 94 | product.info.container1 | Mage_Core_Block_Template_Facade | frontend/alogg/default/template/ |
| 95 | product.info.container2 | Mage_Core_Block_Template_Facade | frontend/alogg/default/template/ |
| 96 | support_category | Mage_Cms_Block_Block | |
| 97 | sale | Mage_Cms_Block_Block | |
| 98 | img_right_bottom | Mage_Cms_Block_Block | |
| 99 | product.tooltip | Mage_Core_Block_Template | frontend/alogg/default/template/catalog/msrp/popup.phtml |
| 100 | product.info.extrahint.qtyincrements | Mage_CatalogInventory_Block_Qtyincrements | frontend/base/default/template/cataloginventory/qtyincrements.phtml |
| 101 | product.info.addtocart.paypal.wrapper | Mage_Page_Block_Html_Wrapper | |
| 102 | product.info.addtocart.paypal | Mage_Paypal_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 103 | paypal.partner.right.logo | Mage_Paypal_Block_Logo | frontend/base/default/template/paypal/partner/logo.phtml |
| 104 | bml.center.logo | Mage_Paypal_Block_Bml_Banners | frontend/base/default/template/paypal/bml.phtml |
| 105 | bml.right.logo | Mage_Paypal_Block_Bml_Banners | frontend/base/default/template/paypal/bml.phtml |
| 106 | product.info.addtocart.paypaluk.wrapper | Mage_Page_Block_Html_Wrapper | |
| 107 | product.info.addtocart.paypaluk | Mage_PaypalUk_Block_Express_Shortcut | frontend/base/default/template/paypal/express/shortcut.phtml |
| 108 | productalert.price | Mage_ProductAlert_Block_Product_View | frontend/alogg/default/template/ |
| 109 | productalert.stock | Mage_ProductAlert_Block_Product_View | frontend/alogg/default/template/ |
| 110 | product.info.simple | Mage_Catalog_Block_Product_View_Type_Simple | frontend/alogg/default/template/catalog/product/view/type/default.phtml |
| 111 | product.info.simple.extra | Mage_Core_Block_Text_List | |
| 112 | product.info.availability | Mage_Catalog_Block_Product_View_Type_Simple | frontend/alogg/default/template/catalog/product/view/type/availability/default.phtml |
| 113 | product.info.simple.extra.child0 | Mage_CatalogInventory_Block_Stockqty_Default | frontend/base/default/template/cataloginventory/stockqty/default.phtml |
Search examples: catalog/product, core/url, etc.
| # | Group Type | Search Results |
|---|
![[TR]](http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/skin/frontend/alogg/default/images/fam_book_open.png)