QA SANDBOX FOR BRAIN ACADEMY
Newsletter
Quick Links
Account
- 1.9.0.1
-
info -
profiler -
0.00 s -
35.25 MB -
111
powered by mgt--commerce.com
| Controller Class: | Mage_Catalog_CategoryController |
| Controller Module: | Mage_Catalog |
| Controller Action: | view |
| Params: |
Array
(
[id] => 8
[q] =>
[/index_php/english/sale_html] =>
[gender] => 94
)
|
| Website Id: | 1 |
| Website Name: | Main Website |
| Store Id: | 1 |
| Store Name: | Madison Island |
| Store View Id: | 1 |
| Store View Code: | english |
| Store View Name: | English |
| Cache Method: | File |
| default |
| STORE_english |
| THEME_frontend_rwd_default |
| catalog_category_view |
| catalog_category_layered |
| CATEGORY_8 |
| customer_logged_out |
| MAP_popup |
| SHORTCUT_popup |
| SHORTCUT_uk_popup |
- global (71)
-
controller_action_predispatch (2)
-
- security_domain_policy
- Class: Mage_Core_Model_Domainpolicy
- Method: addDomainPolicyHeader
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: actionFrontPreDispatchXmlAdmin
-
-
adminhtml_controller_action_predispatch_start (3)
-
- store
- Class: Mage_Adminhtml_Model_Observer
- Method: bindStore
-
- massaction
- Class: Mage_Adminhtml_Model_Observer
- Method: massactionPrepareKey
-
- mgt_base_feed
- Class: Mgt_Base_Model_Feed
- Method: check
-
-
admin_user_authenticate_after (1)
-
- configuration_files_access_level_verification
- Class: Mage_Adminhtml_Model_Observer
- Method: clearCacheConfigurationFilesAccessLevelVerification
-
-
controller_front_init_routers (1)
-
- cms
- Class: Mage_Cms_Controller_Router
- Method: initControllerRouters
-
-
store_save_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processStoreSave
-
-
store_group_save_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processStoreGroupSave
-
-
website_save_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processWebsiteSave
-
-
store_delete_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processStoreDelete
-
-
store_group_delete_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processStoreGroupDelete
-
-
website_delete_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processWebsiteDelete
-
-
core_config_data_save_commit_after (1)
-
- index
- Class: Mage_Index_Model_Observer
- Method: processConfigDataSave
-
-
customer_address_save_before (1)
-
- customer_address_before_save_viv_observer
- Class: Mage_Customer_Model_Observer
- Method: beforeAddressSave
-
-
customer_address_save_after (1)
-
- customer_addres_after_save_viv_observer
- Class: Mage_Customer_Model_Observer
- Method: afterAddressSave
-
-
log_log_clean_after (2)
-
- catalog_product_compare_item
- Class: Mage_Catalog_Model_Observer
- Method: catalogProductCompareClean
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: eventClean
-
-
page_block_html_topmenu_gethtml_before (1)
-
- catalog_add_topmenu_items
- Class: Mage_Catalog_Model_Observer
- Method: addCatalogToTopmenuItems
-
-
catalog_entity_attribute_save_before (2)
-
- catalog_check_reserved_attribute_codes
- Class: Mage_Catalog_Model_Observer
- Method: checkReservedAttributeCodes
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: assignBackendModelToAttribute
-
-
prepare_catalog_product_price_index_table (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: prepareCatalogProductPriceIndexTable
-
-
catalog_product_type_configurable_price (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: catalogProductTypeConfigurablePrice
-
-
sales_order_save_before (1)
-
- payment_sales_order_save_before
- Class: Mage_Payment_Model_Observer
- Method: salesOrderBeforeSave
-
-
sales_order_payment_save_before (1)
-
- payment_before_save
- Class: Mage_Payment_Model_Observer
- Method: beforeOrderPaymentSave
-
-
sales_order_status_unassign_before (1)
-
- payment_order_status_unassign_before
- Class: Mage_Payment_Model_Observer
- Method: beforeSalesOrderStatusUnassign
-
-
sales_order_place_after (2)
-
- sales_vat_request_params_order_comment
- Class: Mage_Sales_Model_Observer
- Method: addVatRequestParamsOrderComment
-
- salesrule
- Class: Mage_SalesRule_Model_Observer
- Method: sales_order_afterPlace
-
-
catalog_block_product_status_display (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: displayProductStatusInfo
-
-
catalog_product_load_after (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: addInventoryData
-
-
catalog_product_clear (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: removeInventoryData
-
-
catalog_product_collection_load_after (2)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: addStockStatusToCollection
-
- tax
- Class: Mage_Tax_Model_Observer
- Method: addTaxPercentToProductCollection
-
-
catalog_product_prepare_index_select (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: prepareCatalogProductIndexSelect
-
-
sales_quote_item_collection_products_after_load (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: addInventoryDataToCollection
-
-
sales_quote_item_qty_set_after (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: checkQuoteItemQty
-
-
checkout_submit_all_after (2)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: checkoutAllSubmitAfter
-
- centinel
- Class: Mage_Centinel_Model_Observer
- Method: checkoutSubmitAllAfter
-
-
sales_model_service_quote_submit_before (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: subtractQuoteInventory
-
-
sales_model_service_quote_submit_success (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: reindexQuoteInventory
-
-
sales_model_service_quote_submit_failure (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: revertQuoteInventory
-
-
sales_order_item_cancel (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: cancelOrderItem
-
-
sales_order_creditmemo_save_after (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: refundOrderInventory
-
-
catalog_product_save_after (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: saveInventoryData
-
-
catalog_model_product_duplicate (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: copyInventoryData
-
-
admin_system_config_changed_section_cataloginventory (1)
-
- inventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: updateItemsStockUponConfigChange
-
-
prepare_catalog_product_index_select (1)
-
- cataloginventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: prepareCatalogProductIndexSelect
-
-
end_index_events_cataloginventory_stock_item_save (1)
-
- cataloginventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: reindexProductsMassAction
-
-
end_process_event_cataloginventory_stock_item_save (1)
-
- cataloginventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: reindexProductsMassAction
-
-
prepare_product_children_id_list_select (1)
-
- cataloginventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: prepareCatalogProductIndexSelect
-
-
sales_quote_config_get_product_attributes (1)
-
- salesrule
- Class: Mage_SalesRule_Model_Observer
- Method: addProductAttributes
-
-
sales_convert_quote_to_order (2)
-
- salesrule
- Class: Mage_SalesRule_Model_Observer
- Method: addSalesRuleNameToOrder
-
- centinel
- Class: Mage_Centinel_Model_Observer
- Method: salesEventConvertQuoteToOrder
-
-
sales_convert_quote_address_to_order (1)
-
- tax
- Class: Mage_Tax_Model_Observer
- Method: salesEventConvertQuoteAddressToOrder
-
-
sales_order_save_after (1)
-
- tax
- Class: Mage_Tax_Model_Observer
- Method: salesEventOrderAfterSave
-
-
catalog_prepare_price_select (2)
-
- tax
- Class: Mage_Tax_Model_Observer
- Method: prepareCatalogIndexPriceSelect
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: prepareCatalogIndexSelect
-
-
sales_quote_collect_totals_before (1)
-
- tax
- Class: Mage_Tax_Model_Observer
- Method: quoteCollectTotalsBefore
-
-
checkout_cart_update_items_before (1)
-
- wishlist
- Class: Mage_Wishlist_Model_Observer
- Method: processCartUpdateBefore
-
-
checkout_cart_add_product_complete (1)
-
- wishlist
- Class: Mage_Wishlist_Model_Observer
- Method: processAddToCart
-
-
before_login_post_redirect (1)
-
- oauth
- Class: Mage_Oauth_Model_Observer
- Method: afterCustomerLogin
-
-
admin_session_user_login_success (2)
-
- oauth
- Class: Mage_Oauth_Model_Observer
- Method: afterAdminLogin
-
- captcha_reset_attempt
- Class: Mage_Captcha_Model_Observer
- Method: resetAttemptForBackend
-
-
admin_session_user_login_failed (1)
-
- oauth
- Class: Mage_Oauth_Model_Observer
- Method: afterAdminLoginFailed
-
-
catalogindex_plain_reindex_after (1)
-
- bundle
- Class: Mage_Bundle_Model_Observer
- Method: catalogIndexPlainReindexAfter
-
-
controller_action_predispatch_customer_account_loginPost (1)
-
- captcha
- Class: Mage_Captcha_Model_Observer
- Method: checkUserLogin
-
-
controller_action_predispatch_customer_account_forgotpasswordpost (1)
-
- captcha
- Class: Mage_Captcha_Model_Observer
- Method: checkForgotPassword
-
-
controller_action_predispatch_customer_account_createpost (1)
-
- captcha
- Class: Mage_Captcha_Model_Observer
- Method: checkUserCreate
-
-
controller_action_predispatch_adminhtml_index_forgotpassword (1)
-
- captcha
- Class: Mage_Captcha_Model_Observer
- Method: checkUserForgotPasswordBackend
-
-
admin_user_authenticate_before (1)
-
- captcha
- Class: Mage_Captcha_Model_Observer
- Method: checkUserLoginBackend
-
-
controller_action_predispatch_checkout_onepage_saveBilling (2)
-
- captcha_guest
- Class: Mage_Captcha_Model_Observer
- Method: checkGuestCheckout
-
- captcha_register
- Class: Mage_Captcha_Model_Observer
- Method: checkRegisterCheckout
-
-
customer_customer_authenticated (1)
-
- captcha_reset_attempt
- Class: Mage_Captcha_Model_Observer
- Method: resetAttemptForFrontend
-
-
admin_user_save_after (1)
-
- api2
- Class: Mage_Api2_Model_Observer
- Method: saveAdminToRoleRelation
-
-
catalogrule_after_apply (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: updateDiscountPercents
-
-
catalog_product_view_config (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: updateCofigurableProductOptions
-
-
bundle_product_view_config (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: updateBundleProductOptions
-
-
create_order_session_quote_initialized (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: setSessionQuoteStore
-
-
init_from_order_session_quote_initialized (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: setSessionQuoteStore
-
-
currency_display_options_forming (1)
-
- mage_currencysymbol_currency_display_options
- Class: Mage_CurrencySymbol_Model_Observer
- Method: currencyDisplayOptions
-
-
websiterestriction_frontend (1)
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: restrictWebsite
-
-
clean_catalog_images_cache_after (1)
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: clearCategoryImagesCache
-
-
controller_action_layout_render_before (1)
-
- mgt_developertoolbar
- Class: Mgt_DeveloperToolbar_Model_Observer
- Method: removeCoreProfilerBlock
-
-
controller_action_predispatch (2)
- adminhtml (49)
-
cms_wysiwyg_config_prepare (2)
-
- variable_observer
- Class: Mage_Core_Model_Variable_Observer
- Method: prepareWysiwygPluginConfig
-
- widget_observer
- Class: Mage_Widget_Model_Observer
- Method: prepareWidgetsPluginConfig
-
-
controller_action_predispatch_adminhtml (1)
-
- synchronize_notification
- Class: Mage_Core_Model_Observer
- Method: addSynchronizeNotification
-
-
show_synchronize_message (1)
-
- synchronize_notification
- Class: Mage_Core_Model_Observer
- Method: addSynchronizeNotification
-
-
clean_cache_by_tags (1)
-
- clean_cache_observer
- Class: Mage_Core_Model_Observer
- Method: cleanCacheByTags
-
-
controller_action_predispatch (3)
-
- auth
- Class: Mage_Admin_Model_Observer
- Method: actionPreDispatchAdmin
-
- adminnotification
- Class: Mage_AdminNotification_Model_Observer
- Method: preDispatch
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: actionPreDispatchXmlAdmin
-
-
core_locale_set_locale (1)
-
- bind_locale
- Class: Mage_Adminhtml_Model_Observer
- Method: bindLocale
-
-
admin_system_config_changed_section_admin (1)
-
- bind_locale
- Class: Mage_Adminhtml_Model_System_Config_Backend_Admin_Observer
- Method: afterCustomUrlChanged
-
-
cms_wysiwyg_images_static_urls_allowed (1)
-
- catalog_wysiwyg
- Class: Mage_Catalog_Model_Observer
- Method: catalogCheckIsUsingStaticUrlsAllowed
-
-
admin_system_config_changed_section_catalog (1)
-
- mage_catalog
- Class: Mage_Core_Model_Observer
- Method: cleanCacheByTags
-
-
catalog_product_get_final_price (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: processAdminFinalPrice
-
-
catalog_product_save_commit_after (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: applyAllRulesOnProduct
-
-
catalog_product_import_finish_before (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: createCatalogRulesRelations
-
-
catalog_product_import_after (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: applyAllRules
-
-
catalog_entity_attribute_delete_after (2)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: catalogAttributeDeleteAfter
-
- salesrule
- Class: Mage_SalesRule_Model_Observer
- Method: catalogAttributeDeleteAfter
-
-
catalog_entity_attribute_save_after (3)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: catalogAttributeSaveAfter
-
- salesrule
- Class: Mage_SalesRule_Model_Observer
- Method: catalogAttributeSaveAfter
-
- api2
- Class: Mage_Api2_Model_Observer
- Method: catalogAttributeSaveAfter
-
-
catalog_product_delete_before (2)
-
- sales_quote_observer
- Class: Mage_Sales_Model_Observer
- Method: substractQtyFromQuotes
-
- tag
- Class: Mage_Tag_Model_Tag
- Method: productDeleteEventAction
-
-
catalogrule_after_apply (1)
-
- sales_quote_observer
- Class: Mage_Sales_Model_Observer
- Method: markQuotesRecollectOnCatalogRules
-
-
catalog_product_save_after (1)
-
- sales_quote
- Class: Mage_Sales_Model_Observer
- Method: catalogProductSaveAfter
-
-
catalog_product_status_update (1)
-
- sales_quote
- Class: Mage_Sales_Model_Observer
- Method: catalogProductStatusUpdate
-
-
catalog_product_edit_form_render_recurring (1)
-
- payment
- Class: Mage_Sales_Model_Observer
- Method: prepareProductEditFormRecurringProfile
-
-
payment_method_is_active (1)
-
- sales_billing_agreement
- Class: Mage_Sales_Model_Observer
- Method: restrictAdminBillingAgreementUsage
-
-
customer_save_after (2)
-
- customer
- Class: Mage_Sales_Model_Observer
- Method: customerSaveAfter
-
- newsletter_subscribe_observer
- Class: Mage_Newsletter_Model_Observer
- Method: subscribeCustomer
-
-
after_reindex_process_cataloginventory_stock (1)
-
- cataloginventory
- Class: Mage_CatalogInventory_Model_Observer
- Method: reindexProductsMassAction
-
-
adminhtml_init_system_config (1)
-
- paypal
- Class: Mage_Paypal_Model_Observer
- Method: loadCountryDependentSolutionsConfig
-
-
catalog_product_delete_after_done (2)
-
- review
- Class: Mage_Review_Model_Observer
- Method: processProductAfterDeleteEvent
-
- rating
- Class: Mage_Rating_Model_Observer
- Method: processProductAfterDeleteEvent
-
-
catalog_controller_product_save_visibility_changed (1)
-
- tag
- Class: Mage_Tag_Model_Tag
- Method: productEventAggregate
-
-
catalog_controller_product_delete (1)
-
- tag
- Class: Mage_Tag_Model_Tag
- Method: productEventAggregate
-
-
sales_convert_quote_item_to_order_item (2)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteItemToOrderItem
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: appendBundleSelectionData
-
-
sales_convert_quote_address_to_order (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteAddressToOrder
-
-
sales_convert_quote_to_order (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteToOrder
-
-
adminhtml_sales_order_create_create_order (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: checkoutEventCreateOrder
-
-
sales_convert_order_to_quote (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventOrderToQuote
-
-
sales_convert_order_item_to_quote_item (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventOrderItemToQuoteItem
-
-
checkout_submit_all_after (1)
-
- directpost_update_all_edit_increments
- Class: Mage_Authorizenet_Model_Directpost_Observer
- Method: updateAllEditIncrements
-
-
catalog_product_prepare_save (2)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: prepareProductSave
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: prepareProductSave
-
-
catalog_model_product_duplicate (1)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: duplicateProduct
-
-
catalog_product_edit_action (1)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: setAttributeTabBlock
-
-
catalog_product_new_action (1)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: setAttributeTabBlock
-
-
payment_info_block_prepare_specific_information (1)
-
- centinel
- Class: Mage_Centinel_Model_Observer
- Method: paymentInfoBlockPrepareSpecificInformation
-
-
customer_delete_after (1)
-
- newsletter_subscribe_observer
- Class: Mage_Newsletter_Model_Observer
- Method: customerDeleted
-
-
sales_order_item_save_commit_after (1)
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: saveDownloadableOrderItem
-
-
sales_order_save_commit_after (1)
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: setLinkStatus
-
-
adminhtml_catalog_product_edit_prepare_form (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: setWeeeRendererInForm
-
-
adminhtml_catalog_product_form_prepare_excluded_field_list (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: updateExcludedFieldList
-
-
adminhtml_product_attribute_types (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: addWeeeTaxAttributeType
-
-
adminhtml_catalog_product_edit_element_types (1)
-
- weee
- Class: Mage_Weee_Model_Observer
- Method: updateElementTypes
-
-
core_config_data_save_after (1)
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: changeUpdatedAtParamOnConfigSave
-
-
core_config_data_save_before (1)
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: changeUpdatedAtParamOnConfigSave
-
-
before_save_message_queue (1)
-
- xmlconnect
- Class: Mage_XmlConnect_Model_Observer
- Method: sendMessageImmediately
-
-
cms_wysiwyg_config_prepare (2)
- frontend (65)
-
controller_action_noroute (1)
-
- cms
- Class: Mage_Cms_Model_Observer
- Method: noRoute
-
-
controller_action_nocookies (1)
-
- cms
- Class: Mage_Cms_Model_Observer
- Method: noCookies
-
-
controller_action_layout_load_before (2)
-
- customer_is_logged_in_observer
- Class: Mage_Customer_Model_Observer
- Method: beforeLoadLayout
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: createPersistentHandleLayout
-
-
sales_model_service_quote_submit_after (1)
-
- restore_customer_group_id
- Class: Mage_Customer_Model_Observer
- Method: quoteSubmitAfter
-
-
customer_login (6)
-
- catalog
- Class: Mage_Catalog_Model_Product_Compare_Item
- Method: bindCustomerLogin
-
- loadCustomerQuote
- Class: Mage_Checkout_Model_Observer
- Method: loadCustomerQuote
-
- log
- Class: Mage_Log_Model_Visitor
- Method: bindCustomerLogin
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: customerLogin
-
- wishlist
- Class: Mage_Wishlist_Model_Observer
- Method: customerLogin
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: synchronizePersistentOnLogin
-
-
customer_logout (6)
-
- catalog
- Class: Mage_Catalog_Model_Product_Compare_Item
- Method: bindCustomerLogout
-
- unsetAll
- Class: Mage_Checkout_Model_Observer
- Method: unsetAll
-
- log
- Class: Mage_Log_Model_Visitor
- Method: bindCustomerLogout
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: customerLogout
-
- wishlist
- Class: Mage_Wishlist_Model_Observer
- Method: customerLogout
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: synchronizePersistentOnLogout
-
-
sales_convert_quote_item_to_order_item (3)
-
- catalog
- Class: Mage_Catalog_Model_Product_Option_Observer
- Method: copyQuoteFilesToOrderFiles
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteItemToOrderItem
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: appendBundleSelectionData
-
-
catalog_product_get_final_price (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: processFrontFinalPrice
-
-
prepare_catalog_product_collection_prices (1)
-
- catalogrule
- Class: Mage_CatalogRule_Model_Observer
- Method: prepareCatalogProductCollectionPrices
-
-
catalog_product_type_prepare_full_options (1)
-
- payment_recurring_profile_prepare_options
- Class: Mage_Payment_Model_Observer
- Method: prepareProductRecurringProfileOptions
-
-
sales_quote_address_collect_totals_before (1)
-
- sales_customer_validate_vat_number
- Class: Mage_Sales_Model_Observer
- Method: changeQuoteCustomerGroupId
-
-
sales_quote_address_collect_totals_after (1)
-
- sales_customer_validate_vat_number
- Class: Mage_Sales_Model_Observer
- Method: restoreQuoteCustomerGroupId
-
-
sales_quote_collect_totals_after (1)
-
- catalog_msrp
- Class: Mage_Sales_Model_Observer
- Method: setQuoteCanApplyMsrp
-
-
sales_quote_save_after (2)
-
- set_checkout_quote_id
- Class: Mage_Checkout_Model_Observer
- Method: salesQuoteSaveAfter
-
- log
- Class: Mage_Log_Model_Visitor
- Method: bindQuoteCreate
-
-
checkout_submit_all_after (2)
-
- hss_save_order_after_submit
- Class: Mage_Paypal_Model_Observer
- Method: saveOrderAfterSubmit
-
- directpost_save_order_after_submit
- Class: Mage_Authorizenet_Model_Directpost_Observer
- Method: saveOrderAfterSubmit
-
-
controller_action_postdispatch_checkout_onepage_saveOrder (2)
-
- hss_save_order_onepage
- Class: Mage_Paypal_Model_Observer
- Method: setResponseAfterSaveOrder
-
- directpost_save_order_onepage
- Class: Mage_Authorizenet_Model_Directpost_Observer
- Method: addAdditionalFieldsToResponseFrontend
-
-
controller_action_predispatch (6)
-
- log
- Class: Mage_Log_Model_Visitor
- Method: initByRequest
-
- pagecache
- Class: Mage_PageCache_Model_Observer
- Method: processPreDispatch
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: emulateQuote
-
- persistent_session
- Class: Mage_Persistent_Model_Observer_Session
- Method: renewCookie
-
- persistent_quote
- Class: Mage_Persistent_Model_Observer
- Method: checkExpirePersistentQuote
-
- persistent_customer
- Class: Mage_Persistent_Model_Observer
- Method: emulateCustomer
-
-
controller_action_postdispatch (1)
-
- log
- Class: Mage_Log_Model_Visitor
- Method: saveByRequest
-
-
checkout_quote_destroy (1)
-
- log
- Class: Mage_Log_Model_Visitor
- Method: bindQuoteDestroy
-
-
review_save_after (1)
-
- rss
- Class: Mage_Rss_Model_Observer
- Method: reviewSaveAfter
-
-
tag_tag_product_collection_load_after (1)
-
- review
- Class: Mage_Review_Model_Observer
- Method: tagProductCollectionLoadAfter
-
-
catalog_block_product_list_collection (1)
-
- review
- Class: Mage_Review_Model_Observer
- Method: catalogBlockProductCollectionBeforeToHtml
-
-
catalog_product_compare_remove_product (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: catalogProductCompareRemoveProduct
-
-
catalog_controller_product_view (2)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: catalogProductView
-
- sendfriend
- Class: Mage_Sendfriend_Model_Observer
- Method: register
-
-
sendfriend_product (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: sendfriendProduct
-
-
catalog_product_compare_add_product (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: catalogProductCompareAddProduct
-
-
catalog_product_compare_item_collection_clear (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: catalogProductCompareClear
-
-
sales_quote_item_save_before (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: checkoutCartAddProduct
-
-
wishlist_add_product (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: wishlistAddProduct
-
-
wishlist_share (1)
-
- reports
- Class: Mage_Reports_Model_Event_Observer
- Method: wishlistShare
-
-
checkout_onepage_controller_success_action (1)
-
- googleanalytics_order_success
- Class: Mage_GoogleAnalytics_Model_Observer
- Method: setGoogleAnalyticsOnOrderSuccessPageView
-
-
checkout_multishipping_controller_success_action (1)
-
- googleanalytics_order_success
- Class: Mage_GoogleAnalytics_Model_Observer
- Method: setGoogleAnalyticsOnOrderSuccessPageView
-
-
sales_convert_quote_address_to_order (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteAddressToOrder
-
-
sales_convert_quote_to_order (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventConvertQuoteToOrder
-
-
checkout_controller_onepage_save_shipping_method (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: checkoutEventCreateGiftMessage
-
-
checkout_controller_multishipping_shipping_post (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: checkoutEventCreateGiftMessage
-
-
sales_convert_order_to_quote (1)
-
- giftmessage
- Class: Mage_GiftMessage_Model_Observer
- Method: salesEventOrderToQuote
-
-
sales_order_save_after (2)
-
- notifystock
- Class: Mage_Rss_Model_Observer
- Method: salesOrderItemSaveAfterNotifyStock
-
- ordernew
- Class: Mage_Rss_Model_Observer
- Method: salesOrderItemSaveAfterOrderNew
-
-
catalog_product_upsell (1)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: appendUpsellProducts
-
-
catalog_product_collection_load_after (1)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: loadProductOptions
-
-
product_option_renderer_init (2)
-
- bundle_observer
- Class: Mage_Bundle_Model_Observer
- Method: initOptionRenderer
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: initOptionRenderer
-
-
payment_form_block_to_html_before (1)
-
- centinel
- Class: Mage_Centinel_Model_Observer
- Method: paymentFormBlockToHtmlBefore
-
-
customer_save_after (1)
-
- newsletter_subscribe_observer
- Class: Mage_Newsletter_Model_Observer
- Method: subscribeCustomer
-
-
customer_delete_after (1)
-
- newsletter_subscribe_observer
- Class: Mage_Newsletter_Model_Observer
- Method: customerDeleted
-
-
sales_order_item_save_commit_after (1)
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: saveDownloadableOrderItem
-
-
sales_order_save_commit_after (1)
-
- downloadable_observer
- Class: Mage_Downloadable_Model_Observer
- Method: setLinkStatus
-
-
checkout_type_onepage_save_order_after (1)
-
- checkout_type_onepage_save_order_after
- Class: Mage_Downloadable_Model_Observer
- Method: setHasDownloadableProducts
-
-
checkout_type_multishipping_create_orders_single (1)
-
- checkout_type_multishipping_create_orders_single
- Class: Mage_Downloadable_Model_Observer
- Method: setHasDownloadableProducts
-
-
checkout_allow_guest (2)
-
- checkout_allow_guest
- Class: Mage_Downloadable_Model_Observer
- Method: isAllowedGuestCheckout
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: disableGuestCheckout
-
-
controller_front_send_response_after (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: synchronizePersistentInfo
-
-
controller_action_predispatch_customer_account_loginPost (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: setRememberMeCheckedStatus
-
-
controller_action_predispatch_customer_account_createpost (2)
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: setRememberMeCheckedStatus
-
- persistent_authenticate
- Class: Mage_Persistent_Model_Observer
- Method: customerAuthenticatedEvent
-
-
controller_action_layout_generate_blocks_after (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: applyPersistentData
-
-
customer_customer_authenticated (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: customerAuthenticatedEvent
-
-
controller_action_predispatch_persistent_index_unsetCookie (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: preventClearCheckoutSession
-
-
controller_action_postdispatch_persistent_index_unsetCookie (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: makePersistentQuoteGuest
-
-
sales_quote_save_before (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: setQuotePersistentData
-
-
custom_quote_process (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: setLoadPersistentQuote
-
-
controller_action_postdispatch_checkout_onepage_saveBilling (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer_Session
- Method: setRememberMeCheckedStatus
-
-
customer_register_success (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: removePersistentCookie
-
-
controller_action_predispatch_paypal_express_start (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: preventExpressCheckout
-
-
controller_action_predispatch_paypaluk_express_start (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: preventExpressCheckout
-
-
controller_action_predispatch_checkout_multishipping_index (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: preventExpressCheckout
-
-
render_block (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: applyBlockPersistentData
-
-
update_customer_cookies (1)
-
- persistent
- Class: Mage_Persistent_Model_Observer
- Method: updateCustomerCookies
-
-
controller_action_noroute (1)
- head
- Class: Mage_Page_Block_Html_Head
- Template: frontend/base/default/template/page/html/head.phtml
- js_cookies
- Class: Mage_Page_Block_Js_Cookie
- Template: frontend/base/default/template/page/js/cookie.phtml
- head.viewport
- Class: Mage_Core_Block_Text
- optional_zip_countries
- Class: Mage_Core_Block_Template
- Template: frontend/base/default/template/directory/js/optional_zip_countries.phtml
- google_analytics
- Class: Mage_GoogleAnalytics_Block_Ga
- Template: frontend/base/default/template/googleanalytics/ga.phtml
- after_body_start
- Class: Mage_Core_Block_Text_List
- global_notices
- Class: Mage_Page_Block_Html_Notices
- Template: frontend/base/default/template/page/html/notices.phtml
- header
- Class: Mage_Page_Block_Html_Header
- Template: frontend/rwd/default/template/page/html/header.phtml
- minicart_head
- Class: Mage_Checkout_Block_Cart_Minicart
- Template: frontend/rwd/default/template/checkout/cart/minicart.phtml
- minicart_content
- Class: Mage_Checkout_Block_Cart_Sidebar
- Template: frontend/rwd/default/template/checkout/cart/minicart/items.phtml
- store_language
- Class: Mage_Page_Block_Switch
- Template: frontend/base/default/template/page/switch/languages.phtml
- welcome
- Class: Mage_Page_Block_Html_Welcome
- breadcrumbs
- Class: Mage_Page_Block_Html_Breadcrumbs
- Template: frontend/base/default/template/page/html/breadcrumbs.phtml
- left_first
- Class: Mage_Core_Block_Text_List
- catalog.leftnav
- Class: Mage_Catalog_Block_Layer_View
- Template: frontend/rwd/default/template/catalog/layer/view.phtml
- left
- Class: Mage_Core_Block_Text_List
- global_messages
- Class: Mage_Core_Block_Messages
- messages
- Class: Mage_Core_Block_Messages
- content
- Class: Mage_Core_Block_Text_List
- category.products
- Class: Mage_Catalog_Block_Category_View
- Template: frontend/base/default/template/catalog/category/view.phtml
- product_list
- Class: Mage_Catalog_Block_Product_List
- Template: frontend/rwd/default/template/catalog/product/list.phtml
- product_list_toolbar
- Class: Mage_Catalog_Block_Product_List_Toolbar
- Template: frontend/rwd/default/template/catalog/product/list/toolbar.phtml
- product_list_toolbar_pager
- Class: Mage_Page_Block_Html_Pager
- Template: frontend/rwd/default/template/page/html/pager.phtml
- product.tooltip
- Class: Mage_Core_Block_Template
- Template: frontend/rwd/default/template/catalog/msrp/popup.phtml
- product.info.addtocart.paypal.wrapper
- Class: Mage_Page_Block_Html_Wrapper
- product.info.addtocart.paypal
- Class: Mage_Paypal_Block_Express_Shortcut
- Template: frontend/base/default/template/paypal/express/shortcut.phtml
- product.info.addtocart.paypaluk.wrapper
- Class: Mage_Page_Block_Html_Wrapper
- product.info.addtocart.paypaluk
- Class: Mage_PaypalUk_Block_Express_Shortcut
- Template: frontend/base/default/template/paypal/express/shortcut.phtml
- right
- Class: Mage_Core_Block_Text_List
- right.reports.product.compared
- Class: Mage_Reports_Block_Product_Compared
- Template: frontend/base/default/template/reports/product_compared.phtml
- right.reports.product.viewed
- Class: Mage_Reports_Block_Product_Viewed
- Template: frontend/rwd/default/template/reports/product_viewed.phtml
- catalog.compare.sidebar
- Class: Mage_Catalog_Block_Product_Compare_Sidebar
- Template: frontend/rwd/default/template/catalog/product/compare/sidebar.phtml
- bml.right.logo
- Class: Mage_Paypal_Block_Bml_Banners
- Template: frontend/rwd/default/template/paypal/bml.phtml
- footer
- Class: Mage_Page_Block_Html_Footer
- Template: frontend/rwd/default/template/page/html/footer.phtml
- store_switcher
- Class: Mage_Page_Block_Switch
- Template: frontend/base/default/template/page/switch/stores.phtml
- cms_footer_links
- Class: Mage_Cms_Block_Block
- footer_links
- Class: Mage_Page_Block_Template_Links
- Template: frontend/rwd/default/template/page/template/links.phtml
- footer_links2
- Class: Mage_Page_Block_Template_Links
- Template: frontend/rwd/default/template/page/template/links.phtml
- return_link
- Class: Mage_Sales_Block_Guest_Links
- Template: frontend/base/default/template/page/template/linksblock.phtml
- cms_footer_links_sm
- Class: Mage_Cms_Block_Block
- footer_currency
- Class: Mage_Directory_Block_Currency
- Template: frontend/rwd/default/template/directory/currency.phtml
- before_body_end
- Class: Mage_Core_Block_Text_List
- global_cookie_notice
- Class: Mage_Page_Block_Html_CookieNotice
- Template: frontend/base/default/template/page/html/cookienotice.phtml
- mgt_developertoolbar
- Class: Mgt_DeveloperToolbar_Block_Toolbar
- Template: frontend/base/default/template/mgt_developertoolbar/toolbar.phtml
PHP Version 5.4.16 |
| System | Linux test.brainacad.com 3.10.0-693.17.1.el7.x86_64 #1 SMP Thu Jan 25 20:13:58 UTC 2018 x86_64 |
| Build Date | Nov 15 2017 16:35:24 |
| Server API | FPM/FastCGI |
| Virtual Directory Support | disabled |
| Configuration File (php.ini) Path | /etc |
| Loaded Configuration File | /etc/php.ini |
| Scan this dir for additional .ini files | /etc/php.d |
| Additional .ini files parsed | /etc/php.d/apcu.ini, /etc/php.d/bcmath.ini, /etc/php.d/curl.ini, /etc/php.d/dom.ini, /etc/php.d/fileinfo.ini, /etc/php.d/gd.ini, /etc/php.d/intl.ini, /etc/php.d/json.ini, /etc/php.d/ldap.ini, /etc/php.d/mbstring.ini, /etc/php.d/mcrypt.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_pgsql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/pgsql.ini, /etc/php.d/phar.ini, /etc/php.d/posix.ini, /etc/php.d/soap.ini, /etc/php.d/sqlite3.ini, /etc/php.d/sysvmsg.ini, /etc/php.d/sysvsem.ini, /etc/php.d/sysvshm.ini, /etc/php.d/wddx.ini, /etc/php.d/xmlreader.ini, /etc/php.d/xmlwriter.ini, /etc/php.d/xsl.ini, /etc/php.d/zip.ini |
| PHP API | 20100412 |
| PHP Extension | 20100525 |
| Zend Extension | 220100525 |
| Zend Extension Build | API220100525,NTS |
| PHP Extension Build | API20100525,NTS |
| Debug Build | no |
| Thread Safety | disabled |
| Zend Signal Handling | disabled |
| Zend Memory Manager | enabled |
| Zend Multibyte Support | provided by mbstring |
| IPv6 Support | enabled |
| DTrace Support | disabled |
| Registered PHP Streams | https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip |
| Registered Stream Socket Transports | tcp, udp, unix, udg, ssl, sslv3, tls |
| Registered Stream Filters | zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, mcrypt.*, mdecrypt.* |
|
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies |
PHP Credits
Configuration
apc
| APC support | Emulated |
apcu
| APCu Support | Enabled |
|---|---|
| Version | 4.0.11 |
| APCu Debugging | Disabled |
| MMAP Support | Enabled |
| MMAP File Mask | /tmp/apc.a3gtgn |
| Serialization Support | php |
| Revision | $Revision: 328290 $ |
| Build Date | Apr 20 2016 13:02:28 |
| Directive | Local Value | Master Value |
|---|---|---|
| apc.coredump_unmap | Off | Off |
| apc.enable_cli | Off | Off |
| apc.enabled | On | On |
| apc.entries_hint | 4096 | 4096 |
| apc.gc_ttl | 3600 | 3600 |
| apc.mmap_file_mask | /tmp/apc.a3gtgn | /tmp/apc.a3gtgn |
| apc.preload_path | no value | no value |
| apc.rfc1867 | Off | Off |
| apc.rfc1867_freq | 0 | 0 |
| apc.rfc1867_name | APC_UPLOAD_PROGRESS | APC_UPLOAD_PROGRESS |
| apc.rfc1867_prefix | upload_ | upload_ |
| apc.rfc1867_ttl | 3600 | 3600 |
| apc.serializer | php | php |
| apc.shm_segments | 1 | 1 |
| apc.shm_size | 32M | 32M |
| apc.slam_defense | On | On |
| apc.smart | 0 | 0 |
| apc.ttl | 0 | 0 |
| apc.use_request_time | On | On |
| apc.writable | /tmp | /tmp |
bcmath
| BCMath support | enabled |
| Directive | Local Value | Master Value |
|---|---|---|
| bcmath.scale | 0 | 0 |
bz2
| BZip2 Support | Enabled |
| Stream Wrapper support | compress.bzip2:// |
| Stream Filter support | bzip2.decompress, bzip2.compress |
| BZip2 Version | 1.0.6, 6-Sept-2010 |
calendar
| Calendar support | enabled |
cgi-fcgi
| php-fpm | active |
| Directive | Local Value | Master Value |
|---|---|---|
| cgi.discard_path | 0 | 0 |
| cgi.fix_pathinfo | 1 | 1 |
| cgi.force_redirect | 1 | 1 |
| cgi.nph | 0 | 0 |
| cgi.redirect_status_env | no value | no value |
| cgi.rfc2616_headers | 0 | 0 |
| fastcgi.error_header | no value | no value |
| fastcgi.logging | 1 | 1 |
| fpm.config | no value | no value |
Core
| PHP Version | 5.4.16 |
| Directive | Local Value | Master Value |
|---|---|---|
| allow_url_fopen | On | On |
| allow_url_include | Off | Off |
| always_populate_raw_post_data | Off | Off |
| arg_separator.input | & | & |
| arg_separator.output | & | & |
| asp_tags | Off | Off |
| auto_append_file | no value | no value |
| auto_globals_jit | On | On |
| auto_prepend_file | no value | no value |
| browscap | no value | no value |
| default_charset | no value | no value |
| default_mimetype | text/html | text/html |
| disable_classes | no value | no value |
| disable_functions | no value | no value |
| display_errors | On | On |
| display_startup_errors | Off | Off |
| doc_root | no value | no value |
| docref_ext | no value | no value |
| docref_root | no value | no value |
| enable_dl | Off | Off |
| enable_post_data_reading | On | On |
| error_append_string | no value | no value |
| error_log | /var/log/php-fpm/www-error.log | /var/log/php-fpm/www-error.log |
| error_prepend_string | no value | no value |
| error_reporting | 32767 | 32767 |
| exit_on_timeout | Off | Off |
| expose_php | On | On |
| extension_dir | /usr/lib64/php/modules | /usr/lib64/php/modules |
| file_uploads | On | On |
| highlight.comment | #FF8000 | #FF8000 |
| highlight.default | #0000BB | #0000BB |
| highlight.html | #000000 | #000000 |
| highlight.keyword | #007700 | #007700 |
| highlight.string | #DD0000 | #DD0000 |
| html_errors | On | On |
| ignore_repeated_errors | Off | Off |
| ignore_repeated_source | Off | Off |
| ignore_user_abort | Off | Off |
| implicit_flush | Off | Off |
| include_path | /v1/www/magento.mainacad.com/app/code/local:/v1/www/magento.mainacad.com/app/code/community:/v1/www/magento.mainacad.com/app/code/core:/v1/www/magento.mainacad.com/lib:.:/usr/share/pear:/usr/share/php | .:/usr/share/pear:/usr/share/php |
| log_errors | On | On |
| log_errors_max_len | 1024 | 1024 |
| mail.add_x_header | On | On |
| mail.force_extra_parameters | no value | no value |
| mail.log | no value | no value |
| max_execution_time | 120 | 120 |
| max_file_uploads | 20 | 20 |
| max_input_nesting_level | 64 | 64 |
| max_input_time | 60 | 60 |
| max_input_vars | 1000 | 1000 |
| memory_limit | 256M | 256M |
| open_basedir | no value | no value |
| output_buffering | 4096 | 4096 |
| output_handler | no value | no value |
| post_max_size | 8M | 8M |
| precision | 14 | 14 |
| realpath_cache_size | 16K | 16K |
| realpath_cache_ttl | 120 | 120 |
| register_argc_argv | Off | Off |
| report_memleaks | On | On |
| report_zend_debug | On | On |
| request_order | GP | GP |
| sendmail_from | no value | no value |
| sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i |
| serialize_precision | 17 | 17 |
| short_open_tag | On | On |
| SMTP | localhost | localhost |
| smtp_port | 25 | 25 |
| sql.safe_mode | Off | Off |
| track_errors | Off | Off |
| unserialize_callback_func | no value | no value |
| upload_max_filesize | 2M | 2M |
| upload_tmp_dir | no value | no value |
| user_dir | no value | no value |
| user_ini.cache_ttl | 300 | 300 |
| user_ini.filename | .user.ini | .user.ini |
| variables_order | GPCS | GPCS |
| xmlrpc_error_number | 0 | 0 |
| xmlrpc_errors | Off | Off |
| zend.detect_unicode | On | On |
| zend.enable_gc | On | On |
| zend.multibyte | Off | Off |
| zend.script_encoding | no value | no value |
ctype
| ctype functions | enabled |
curl
| cURL support | enabled |
| cURL Information | 7.29.0 |
| Age | 3 |
| Features | |
| AsynchDNS | Yes |
| Debug | No |
| GSS-Negotiate | Yes |
| IDN | Yes |
| IPv6 | Yes |
| Largefile | Yes |
| NTLM | Yes |
| SPNEGO | No |
| SSL | Yes |
| SSPI | No |
| krb4 | No |
| libz | Yes |
| CharConv | No |
| Protocols | dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp |
| Host | x86_64-redhat-linux-gnu |
| SSL Version | NSS/3.28.4 |
| ZLib Version | 1.2.7 |
| libSSH Version | libssh2/1.4.3 |
date
| date/time support | enabled |
| "Olson" Timezone Database Version | 0.system |
| Timezone Database | internal |
| Default timezone | UTC |
| Directive | Local Value | Master Value |
|---|---|---|
| date.default_latitude | 31.7667 | 31.7667 |
| date.default_longitude | 35.2333 | 35.2333 |
| date.sunrise_zenith | 90.583333 | 90.583333 |
| date.sunset_zenith | 90.583333 | 90.583333 |
| date.timezone | Europe/Kiev | Europe/Kiev |
dom
| DOM/XML | enabled |
| DOM/XML API Version | 20031129 |
| libxml Version | 2.9.1 |
| HTML Support | enabled |
| XPath Support | enabled |
| XPointer Support | enabled |
| Schema Support | enabled |
| RelaxNG Support | enabled |
ereg
| Regex Library | Bundled library enabled |
exif
| EXIF Support | enabled |
| EXIF Version | 1.4 $Id$ |
| Supported EXIF Version | 0220 |
| Supported filetypes | JPEG,TIFF |
| Directive | Local Value | Master Value |
|---|---|---|
| exif.decode_jis_intel | JIS | JIS |
| exif.decode_jis_motorola | JIS | JIS |
| exif.decode_unicode_intel | UCS-2LE | UCS-2LE |
| exif.decode_unicode_motorola | UCS-2BE | UCS-2BE |
| exif.encode_jis | no value | no value |
| exif.encode_unicode | ISO-8859-15 | ISO-8859-15 |
fileinfo
| fileinfo support | enabled |
| version | 1.0.5 |
filter
| Input Validation and Filtering | enabled |
| Revision | $Id: 2aa8dd57d9c0c655cd45e6e5872bb95fa5ad76cf $ |
| Directive | Local Value | Master Value |
|---|---|---|
| filter.default | unsafe_raw | unsafe_raw |
| filter.default_flags | no value | no value |
ftp
| FTP support | enabled |
gd
| GD Support | enabled |
| GD Version | bundled (2.1.0 compatible) |
| FreeType Support | enabled |
| FreeType Linkage | with freetype |
| FreeType Version | 2.4.11 |
| T1Lib Support | enabled |
| GIF Read Support | enabled |
| GIF Create Support | enabled |
| JPEG Support | enabled |
| libJPEG Version | 6b |
| PNG Support | enabled |
| libPNG Version | 1.5.13 |
| WBMP Support | enabled |
| XPM Support | enabled |
| libXpm Version | 30411 |
| XBM Support | enabled |
| Directive | Local Value | Master Value |
|---|---|---|
| gd.jpeg_ignore_warning | 0 | 0 |
gettext
| GetText Support | enabled |
gmp
| gmp support | enabled |
| GMP version | 6.0.0 |
hash
| hash support | enabled |
| Hashing Engines | md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b fnv132 fnv164 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 |
iconv
| iconv support | enabled |
| iconv implementation | glibc |
| iconv library version | 2.17 |
| Directive | Local Value | Master Value |
|---|---|---|
| iconv.input_encoding | ISO-8859-1 | ISO-8859-1 |
| iconv.internal_encoding | ISO-8859-1 | ISO-8859-1 |
| iconv.output_encoding | ISO-8859-1 | ISO-8859-1 |
intl
| Internationalization support | enabled |
|---|---|
| version | 1.1.0 |
| ICU version | 50.1.2 |
| ICU Data version | 50.1 |
| Directive | Local Value | Master Value |
|---|---|---|
| intl.default_locale | no value | no value |
| intl.error_level | 0 | 0 |
json
| json support | enabled |
| json version | 1.2.1 |
ldap
| LDAP Support | enabled |
| RCS Version | $Id$ |
| Total Links | 0/unlimited |
| API Version | 3001 |
| Vendor Name | OpenLDAP |
| Vendor Version | 20444 |
| SASL Support | Enabled |
| Directive | Local Value | Master Value |
|---|---|---|
| ldap.max_links | Unlimited | Unlimited |
libxml
| libXML support | active |
| libXML Compiled Version | 2.9.1 |
| libXML Loaded Version | 20901 |
| libXML streams | enabled |
mbstring
| Multibyte Support | enabled |
| Multibyte string engine | libmbfl |
| HTTP input encoding translation | disabled |
| libmbfl version | 1.3.2 |
| mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. |
|---|
| Multibyte (japanese) regex support | enabled |
| Multibyte regex (oniguruma) backtrack check | On |
| Multibyte regex (oniguruma) version | 4.7.1 |
| Directive | Local Value | Master Value |
|---|---|---|
| mbstring.detect_order | no value | no value |
| mbstring.encoding_translation | Off | Off |
| mbstring.func_overload | 0 | 0 |
| mbstring.http_input | pass | pass |
| mbstring.http_output | pass | pass |
| mbstring.http_output_conv_mimetypes | ^(text/|application/xhtml\+xml) | ^(text/|application/xhtml\+xml) |
| mbstring.internal_encoding | no value | no value |
| mbstring.language | neutral | neutral |
| mbstring.strict_detection | Off | Off |
| mbstring.substitute_character | no value | no value |
mcrypt
| mcrypt support | enabled |
|---|---|
| mcrypt_filter support | enabled |
| Version | 2.5.8 |
| Api No | 20021217 |
| Supported ciphers | cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes |
| Supported modes | cbc cfb ctr ecb ncfb nofb ofb stream |
| Directive | Local Value | Master Value |
|---|---|---|
| mcrypt.algorithms_dir | no value | no value |
| mcrypt.modes_dir | no value | no value |
mhash
| MHASH support | Enabled |
| MHASH API Version | Emulated Support |
mysql
| MySQL Support | enabled |
|---|---|
| Active Persistent Links | 0 |
| Active Links | 0 |
| Client API version | 5.5.56-MariaDB |
| MYSQL_MODULE_TYPE | external |
| MYSQL_SOCKET | /var/lib/mysql/mysql.sock |
| MYSQL_INCLUDE | -I/usr/include/mysql |
| MYSQL_LIBS | -L/usr/lib64/mysql -lmysqlclient |
| Directive | Local Value | Master Value |
|---|---|---|
| mysql.allow_local_infile | On | On |
| mysql.allow_persistent | On | On |
| mysql.connect_timeout | 60 | 60 |
| mysql.default_host | no value | no value |
| mysql.default_password | no value | no value |
| mysql.default_port | no value | no value |
| mysql.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
| mysql.default_user | no value | no value |
| mysql.max_links | Unlimited | Unlimited |
| mysql.max_persistent | Unlimited | Unlimited |
| mysql.trace_mode | Off | Off |
mysqli
| MysqlI Support | enabled |
|---|---|
| Client API library version | 5.5.56-MariaDB |
| Active Persistent Links | 0 |
| Inactive Persistent Links | 0 |
| Active Links | 0 |
| Client API header version | 5.5.56-MariaDB |
| MYSQLI_SOCKET | /var/lib/mysql/mysql.sock |
| Directive | Local Value | Master Value |
|---|---|---|
| mysqli.allow_local_infile | On | On |
| mysqli.allow_persistent | On | On |
| mysqli.default_host | no value | no value |
| mysqli.default_port | 3306 | 3306 |
| mysqli.default_pw | no value | no value |
| mysqli.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
| mysqli.default_user | no value | no value |
| mysqli.max_links | Unlimited | Unlimited |
| mysqli.max_persistent | Unlimited | Unlimited |
| mysqli.reconnect | Off | Off |
openssl
| OpenSSL support | enabled |
| OpenSSL Library Version | OpenSSL 1.0.2k-fips 26 Jan 2017 |
| OpenSSL Header Version | OpenSSL 1.0.2k-fips 26 Jan 2017 |
pcre
| PCRE (Perl Compatible Regular Expressions) Support | enabled |
| PCRE Library Version | 8.32 2012-11-30 |
| Directive | Local Value | Master Value |
|---|---|---|
| pcre.backtrack_limit | 1000000 | 1000000 |
| pcre.recursion_limit | 100000 | 100000 |
PDO
| PDO support | enabled |
|---|---|
| PDO drivers | mysql, pgsql, sqlite |
pdo_mysql
| PDO Driver for MySQL | enabled |
|---|---|
| Client API version | 5.5.56-MariaDB |
| Directive | Local Value | Master Value |
|---|---|---|
| pdo_mysql.default_socket | /var/lib/mysql/mysql.sock | /var/lib/mysql/mysql.sock |
pdo_pgsql
| PDO Driver for PostgreSQL | enabled |
|---|---|
| PostgreSQL(libpq) Version | 9.2.23 |
| Module version | 1.0.2 |
| Revision | $Id$ |
pdo_sqlite
| PDO Driver for SQLite 3.x | enabled |
|---|---|
| SQLite Library | 3.7.17 |
pgsql
| PostgreSQL Support | enabled |
|---|---|
| PostgreSQL(libpq) Version | 9.2.23 |
| PostgreSQL(libpq) | PostgreSQL 9.2.23 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit |
| Multibyte character support | enabled |
| SSL support | enabled |
| Active Persistent Links | 0 |
| Active Links | 0 |
| Directive | Local Value | Master Value |
|---|---|---|
| pgsql.allow_persistent | On | On |
| pgsql.auto_reset_persistent | Off | Off |
| pgsql.ignore_notice | Off | Off |
| pgsql.log_notice | Off | Off |
| pgsql.max_links | Unlimited | Unlimited |
| pgsql.max_persistent | Unlimited | Unlimited |
Phar
| Phar: PHP Archive support | enabled |
|---|---|
| Phar EXT version | 2.0.1 |
| Phar API version | 1.1.1 |
| SVN revision | $Id: c5042cc34acebcc0926625b57dff03deebbe6472 $ |
| Phar-based phar archives | enabled |
| Tar-based phar archives | enabled |
| ZIP-based phar archives | enabled |
| gzip compression | enabled |
| bzip2 compression | enabled |
| Native OpenSSL support | enabled |
|
Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. |
| Directive | Local Value | Master Value |
|---|---|---|
| phar.cache_list | no value | no value |
| phar.readonly | On | On |
| phar.require_hash | On | On |
posix
| Revision | $Id: 32db6705f5b617967a546be3114e178a4138c1ca $ |
Reflection
| Reflection | enabled |
|---|---|
| Version | $Id: 6c4d8062369898a397e4b128348042f5c01b4427 $ |
session
| Session Support | enabled |
| Registered save handlers | files user |
| Registered serializer handlers | php php_binary wddx |
| Directive | Local Value | Master Value |
|---|---|---|
| session.auto_start | Off | Off |
| session.cache_expire | 180 | 180 |
| session.cache_limiter | nocache | nocache |
| session.cookie_domain | magento.mainacad.com | no value |
| session.cookie_httponly | On | Off |
| session.cookie_lifetime | 3600 | 0 |
| session.cookie_path | / | / |
| session.cookie_secure | Off | Off |
| session.entropy_file | /dev/urandom | /dev/urandom |
| session.entropy_length | 32 | 32 |
| session.gc_divisor | 1000 | 1000 |
| session.gc_maxlifetime | 1440 | 1440 |
| session.gc_probability | 1 | 1 |
| session.hash_bits_per_character | 5 | 5 |
| session.hash_function | 0 | 0 |
| session.name | frontend | PHPSESSID |
| session.referer_check | no value | no value |
| session.save_handler | files | files |
| session.save_path | /v1/www/magento.mainacad.com/var/session | /var/lib/php/session |
| session.serialize_handler | php | php |
| session.upload_progress.cleanup | On | On |
| session.upload_progress.enabled | On | On |
| session.upload_progress.freq | 1% | 1% |
| session.upload_progress.min_freq | 1 | 1 |
| session.upload_progress.name | PHP_SESSION_UPLOAD_PROGRESS | PHP_SESSION_UPLOAD_PROGRESS |
| session.upload_progress.prefix | upload_progress_ | upload_progress_ |
| session.use_cookies | On | On |
| session.use_only_cookies | On | On |
| session.use_trans_sid | 0 | 0 |
shmop
| shmop support | enabled |
SimpleXML
| Simplexml support | enabled |
|---|---|
| Revision | $Id: 692516840b2d7d6e7aedb0bedded1f53b764a99f $ |
| Schema support | enabled |
soap
| Soap Client | enabled |
| Soap Server | enabled |
| Directive | Local Value | Master Value |
|---|---|---|
| soap.wsdl_cache | 1 | 1 |
| soap.wsdl_cache_dir | /tmp | /tmp |
| soap.wsdl_cache_enabled | 1 | 1 |
| soap.wsdl_cache_limit | 5 | 5 |
| soap.wsdl_cache_ttl | 86400 | 86400 |
sockets
| Sockets Support | enabled |
SPL
| SPL support | enabled |
|---|---|
| Interfaces | Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject |
| Classes | AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException |
sqlite3
| SQLite3 support | enabled |
|---|---|
| SQLite3 module version | 0.7 |
| SQLite Library | 3.7.17 |
| Directive | Local Value | Master Value |
|---|---|---|
| sqlite3.extension_dir | no value | no value |
standard
| Dynamic Library Support | enabled |
| Path to sendmail | /usr/sbin/sendmail -t -i |
| Directive | Local Value | Master Value |
|---|---|---|
| assert.active | 1 | 1 |
| assert.bail | 0 | 0 |
| assert.callback | no value | no value |
| assert.quiet_eval | 0 | 0 |
| assert.warning | 1 | 1 |
| auto_detect_line_endings | 0 | 0 |
| default_socket_timeout | 60 | 60 |
| from | no value | no value |
| url_rewriter.tags | a=href,area=href,frame=src,input=src,form=fakeentry | a=href,area=href,frame=src,input=src,form=fakeentry |
| user_agent | no value | no value |
sysvmsg
| sysvmsg support | enabled |
| Revision | $Id: e268047b695fe9a43cdf415c429729252347becd $ |
tokenizer
| Tokenizer Support | enabled |
wddx
| WDDX Support | enabled |
|---|---|
| WDDX Session Serializer | enabled |
xml
| XML Support | active |
| XML Namespace Support | active |
| libxml2 Version | 2.9.1 |
xmlreader
| XMLReader | enabled |
xmlwriter
| XMLWriter | enabled |
xsl
| XSL | enabled |
| libxslt Version | 1.1.28 |
| libxslt compiled against libxml Version | 2.9.1 |
| EXSLT | enabled |
| libexslt Version | 1.1.28 |
zip
| Zip | enabled |
| Extension Version | $Id: 0c033d4e4613d577409950ed7bf8da4b68286d15 $ |
| Zip version | 1.11.0 |
| Compiled against libzip version | 0.10.1 |
zlib
| ZLib Support | enabled |
|---|---|
| Stream Wrapper | compress.zlib:// |
| Stream Filter | zlib.inflate, zlib.deflate |
| Compiled Version | 1.2.7 |
| Linked Version | 1.2.7 |
| Directive | Local Value | Master Value |
|---|---|---|
| zlib.output_compression | Off | Off |
| zlib.output_compression_level | -1 | -1 |
| zlib.output_handler | no value | no value |
Additional Modules
| Module Name |
|---|
| sysvsem |
| sysvshm |
Environment
| Variable | Value |
|---|---|
| USER | www |
| HOME | /v1/www |
PHP Variables
| Variable | Value |
|---|---|
| _REQUEST["/index_php/english/sale_html"] | no value |
| _REQUEST["gender"] | 94 |
| _GET["/index_php/english/sale_html"] | no value |
| _GET["gender"] | 94 |
| _SERVER["USER"] | www |
| _SERVER["HOME"] | /v1/www |
| _SERVER["FCGI_ROLE"] | RESPONDER |
| _SERVER["QUERY_STRING"] | /index.php/english/sale.html&%2Findex_php%2Fenglish%2Fsale_html=&gender=94 |
| _SERVER["REQUEST_METHOD"] | GET |
| _SERVER["CONTENT_TYPE"] | no value |
| _SERVER["CONTENT_LENGTH"] | no value |
| _SERVER["SCRIPT_NAME"] | /index.php |
| _SERVER["REQUEST_URI"] | /index.php/english/sale.html?%2Findex_php%2Fenglish%2Fsale_html=&gender=94 |
| _SERVER["DOCUMENT_URI"] | /index.php |
| _SERVER["DOCUMENT_ROOT"] | /v1/www/magento.mainacad.com |
| _SERVER["SERVER_PROTOCOL"] | HTTP/1.1 |
| _SERVER["GATEWAY_INTERFACE"] | CGI/1.1 |
| _SERVER["SERVER_SOFTWARE"] | nginx/1.8.1 |
| _SERVER["REMOTE_ADDR"] | 18.204.48.199 |
| _SERVER["REMOTE_PORT"] | 55850 |
| _SERVER["SERVER_ADDR"] | 91.192.105.23 |
| _SERVER["SERVER_PORT"] | 80 |
| _SERVER["SERVER_NAME"] | magento.mainacad.com |
| _SERVER["REDIRECT_STATUS"] | 200 |
| _SERVER["SCRIPT_FILENAME"] | /v1/www/magento.mainacad.com/index.php |
| _SERVER["HTTP_USER_AGENT"] | CCBot/2.0 (https://commoncrawl.org/faq/) |
| _SERVER["HTTP_ACCEPT"] | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| _SERVER["HTTP_ACCEPT_LANGUAGE"] | en-US,en;q=0.5 |
| _SERVER["HTTP_IF_MODIFIED_SINCE"] | Sun, 25 Aug 2019 11:53:23 EDT |
| _SERVER["HTTP_HOST"] | magento.mainacad.com |
| _SERVER["HTTP_CONNECTION"] | Keep-Alive |
| _SERVER["HTTP_ACCEPT_ENCODING"] | gzip |
| _SERVER["PHP_SELF"] | /index.php |
| _SERVER["REQUEST_TIME_FLOAT"] | 1574170498.1341 |
| _SERVER["REQUEST_TIME"] | 1574170498 |
PHP License
|
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net. |
| Name | Time | Cnt | Emalloc | RealMem |
| Executed: | 111 queries in 0.071655988693237 seconds |
| Average query length: | 0.00064554944768682 seconds |
| Queries per second: | 1549.0680126569 |
| Longest query length: | 0.013749122619629 |
| Longest query: | 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('4', '10', '11', '12', '13', '42', '5', '14', '15', '16', '17', '40', '6', '18', '19', '20', '21', '7', '22', '23', '24', '25', '8', '26', '27', '28', '29', '9')) 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') |
| Total queries: | 111 |
| Insert queries: | 2 |
| Update queries: | 0 |
| Read queries: | 106 |
| Delete queries: | 0 |
| Transactions: | 2 |
- SHOW TABLE STATUS LIKE 'core_resource' Elapsed seconds: 0.00072503089904785
- SELECT `core_resource`.* FROM `core_resource` Elapsed seconds: 0.00018000602722168
- SELECT `index_process`.`indexer_code` FROM `index_process` Elapsed seconds: 0.00011396408081055
- SELECT `core_website`.`website_id`, `core_website`.`code`, `core_website`.`name` FROM `core_website` Elapsed seconds: 0.0001370906829834
- SELECT `core_store`.`store_id`, `core_store`.`code`, `core_store`.`name`, `core_store`.`website_id` FROM `core_store` ORDER BY `sort_order` ASC Elapsed seconds: 0.00015497207641602
- SELECT `core_config_data`.`scope`, `core_config_data`.`scope_id`, `core_config_data`.`path`, `core_config_data`.`value` FROM `core_config_data` Elapsed seconds: 0.0013179779052734
- SELECT `main_table`.* FROM `core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC Elapsed seconds: 0.0006110668182373
- SELECT `main_table`.* FROM `core_website` AS `main_table` ORDER BY main_table.sort_order ASC, main_table.name ASC Elapsed seconds: 0.00021600723266602
- SELECT `main_table`.* FROM `core_store_group` AS `main_table` ORDER BY main_table.name ASC Elapsed seconds: 0.00013899803161621
- SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1, :path2, :path3)) AND (store_id IN(0, 1)) Elapsed seconds: 0.00076508522033691
- 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) Elapsed seconds: 0.00037789344787598
- 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 Elapsed seconds: 0.00054597854614258
- begin Elapsed seconds: 8.702278137207E-5
- INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?) Elapsed seconds: 0.00032305717468262
- INSERT INTO `log_visitor_info` (`visitor_id`, `http_referer`, `http_user_agent`, `http_accept_charset`, `http_accept_language`, `server_addr`, `remote_addr`) VALUES (?, ?, ?, ?, ?, ?, ?) Elapsed seconds: 0.00011086463928223
- commit Elapsed seconds: 0.00067305564880371
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category') Elapsed seconds: 0.00024795532226562
- SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =8) Elapsed seconds: 0.00036406517028809
- 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 sort_order ASC Elapsed seconds: 0.00073814392089844
- 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 = '8') 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 = '8') 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 = '8') 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 = '8') 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 = '8') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC Elapsed seconds: 0.0012800693511963
- 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('8', '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 Elapsed seconds: 0.001230001449585
- 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 (8, 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 (8, 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 (8, 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 (8, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0) Elapsed seconds: 0.0011780261993408
- 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 = :catalog_category) AND (attribute_code = :is_active) Elapsed seconds: 0.0002138614654541
- SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag) Elapsed seconds: 0.00035500526428223
- 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 Elapsed seconds: 0.0014598369598389
- 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 Elapsed seconds: 0.00061893463134766
- 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 Elapsed seconds: 0.0013210773468018
- 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 Elapsed seconds: 0.00052094459533691
- 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 Elapsed seconds: 0.00041890144348145
- 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 Elapsed seconds: 0.0010828971862793
- 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 Elapsed seconds: 0.0008080005645752
- 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 Elapsed seconds: 0.0008699893951416
- 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 Elapsed seconds: 0.00042295455932617
- 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 Elapsed seconds: 0.00041007995605469
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.00035715103149414
- 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) Elapsed seconds: 0.00054717063903809
- SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_entity` AS `e` 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 = '8' 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 Elapsed seconds: 0.00037217140197754
- 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`.`attribute_id`, 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 IN('13', '11', '16')) AND (additional_table.is_filterable > 0) GROUP BY `entity_attribute`.`attribute_id` ORDER BY position ASC Elapsed seconds: 0.0016369819641113
- 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 = '194') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00031805038452148
- 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 = '176') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00036191940307617
- 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 = '192') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00028800964355469
- 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 = '198') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00025391578674316
- 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 = '92') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00039386749267578
- 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 = '199') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00027990341186523
- 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 = '179') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00032186508178711
- 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 = '184') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00030899047851562
- 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 = '200') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00027990341186523
- 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 = '181') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00026178359985352
- 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 = '189') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00046896934509277
- 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 = '175') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00026607513427734
- 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 = '180') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00048017501831055
- 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 = '178') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00028610229492188
- 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('8')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Elapsed seconds: 0.00039315223693848
- 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 (8)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0) Elapsed seconds: 0.0003199577331543
- SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='category/8') AND (store_id IN(0, '1')) ORDER BY `store_id` DESC LIMIT 1 Elapsed seconds: 0.00023102760314941
- 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) Elapsed seconds: 0.00035595893859863
- SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id) Elapsed seconds: 0.00021100044250488
- SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') Elapsed seconds: 0.00013494491577148
- SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') ORDER BY `catalog_category_entity`.`position` ASC Elapsed seconds: 0.00025796890258789
- 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) Elapsed seconds: 0.00024700164794922
- 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 (SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('4', '10', '11', '12', '13', '42', '5', '14', '15', '16', '17', '40', '6', '18', '19', '20', '21', '7', '22', '23', '24', '25', '8', '26', '27', '28', '29', '9')))) AND (IF(c.value_id > 0, c.value, d.value) = :cond) Elapsed seconds: 0.00054001808166504
- SELECT `e`.`entity_id` FROM `catalog_category_entity` AS `e` WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('4', '10', '11', '12', '13', '42', '5', '14', '15', '16', '17', '40', '6', '18', '19', '20', '21', '7', '22', '23', '24', '25', '8', '26', '27', '28', '29', '9')) Elapsed seconds: 0.00017499923706055
- 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('4', '10', '11', '12', '13', '42', '5', '14', '15', '16', '17', '40', '6', '18', '19', '20', '21', '7', '22', '23', '24', '25', '8', '26', '27', '28', '29', '9')) 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') Elapsed seconds: 0.013749122619629
- 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 (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 40, 42)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0) Elapsed seconds: 0.0011191368103027
- SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (`path` LIKE '1/2/8/%') AND (`level` <= 3) AND (IF(c.value_id > 0, c.value, d.value) = :scope) Elapsed seconds: 0.00048422813415527
- SELECT `e`.*, `core_url_rewrite`.`request_path`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` LEFT JOIN `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/%') 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 (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('26', '27', '28', '29')) ORDER BY `e`.`position` ASC Elapsed seconds: 0.0023889541625977
- 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 (26, 27, 28, 29)) AND (t_d.attribute_id IN ('43', '41')) 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 (26, 27, 28, 29)) AND (t_d.attribute_id IN ('54')) 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 (26, 27, 28, 29)) AND (t_d.attribute_id IN ('51')) AND (t_d.store_id = 0) Elapsed seconds: 0.0011370182037354
- SELECT `count_table`.`category_id`, COUNT(DISTINCT count_table.product_id) AS `product_count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_category_product_index` AS `count_table` ON count_table.product_id = e.entity_id WHERE (count_table.store_id = 1) AND (count_table.category_id IN ('26', '27', '28', '29')) GROUP BY `count_table`.`category_id` Elapsed seconds: 0.00053906440734863
- SELECT `accessories_size_idx`.`value`, COUNT(accessories_size_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `accessories_size_idx` ON accessories_size_idx.entity_id = e.entity_id AND accessories_size_idx.attribute_id = '194' AND accessories_size_idx.store_id = '1' GROUP BY `accessories_size_idx`.`value` Elapsed seconds: 0.00034809112548828
- SELECT `apparel_type_idx`.`value`, COUNT(apparel_type_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `apparel_type_idx` ON apparel_type_idx.entity_id = e.entity_id AND apparel_type_idx.attribute_id = '176' AND apparel_type_idx.store_id = '1' GROUP BY `apparel_type_idx`.`value` Elapsed seconds: 0.00038290023803711
- SELECT `bag_luggage_type_idx`.`value`, COUNT(bag_luggage_type_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `bag_luggage_type_idx` ON bag_luggage_type_idx.entity_id = e.entity_id AND bag_luggage_type_idx.attribute_id = '192' AND bag_luggage_type_idx.store_id = '1' GROUP BY `bag_luggage_type_idx`.`value` Elapsed seconds: 0.00037908554077148
- SELECT `bed_bath_type_idx`.`value`, COUNT(bed_bath_type_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `bed_bath_type_idx` ON bed_bath_type_idx.entity_id = e.entity_id AND bed_bath_type_idx.attribute_id = '198' AND bed_bath_type_idx.store_id = '1' GROUP BY `bed_bath_type_idx`.`value` Elapsed seconds: 0.00035905838012695
- SELECT `color_idx`.`value`, COUNT(color_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `color_idx` ON color_idx.entity_id = e.entity_id AND color_idx.attribute_id = '92' AND color_idx.store_id = '1' GROUP BY `color_idx`.`value` Elapsed seconds: 0.00037789344787598
- SELECT `decor_type_idx`.`value`, COUNT(decor_type_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `decor_type_idx` ON decor_type_idx.entity_id = e.entity_id AND decor_type_idx.attribute_id = '199' AND decor_type_idx.store_id = '1' GROUP BY `decor_type_idx`.`value` Elapsed seconds: 0.00037503242492676
- SELECT `fit_idx`.`value`, COUNT(fit_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `fit_idx` ON fit_idx.entity_id = e.entity_id AND fit_idx.attribute_id = '179' AND fit_idx.store_id = '1' GROUP BY `fit_idx`.`value` Elapsed seconds: 0.00036406517028809
- SELECT `home_decor_type_idx`.`value`, COUNT(home_decor_type_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `home_decor_type_idx` ON home_decor_type_idx.entity_id = e.entity_id AND home_decor_type_idx.attribute_id = '200' AND home_decor_type_idx.store_id = '1' GROUP BY `home_decor_type_idx`.`value` Elapsed seconds: 0.00038981437683105
- SELECT `length_idx`.`value`, COUNT(length_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `length_idx` ON length_idx.entity_id = e.entity_id AND length_idx.attribute_id = '181' AND length_idx.store_id = '1' GROUP BY `length_idx`.`value` Elapsed seconds: 0.00037884712219238
- SELECT `material_idx`.`value`, COUNT(material_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `material_idx` ON material_idx.entity_id = e.entity_id AND material_idx.attribute_id = '189' AND material_idx.store_id = '1' GROUP BY `material_idx`.`value` Elapsed seconds: 0.00038480758666992
- SELECT `occasion_idx`.`value`, COUNT(occasion_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `occasion_idx` ON occasion_idx.entity_id = e.entity_id AND occasion_idx.attribute_id = '175' AND occasion_idx.store_id = '1' GROUP BY `occasion_idx`.`value` Elapsed seconds: 0.00038409233093262
- SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price ) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price ) * 1, 2)) AS `std` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' WHERE (price_index.min_price IS NOT NULL) Elapsed seconds: 0.00043201446533203
- SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 100) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` AS `e` 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 = '8' INNER JOIN `catalog_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 100) + 1 ORDER BY FLOOR((ROUND((e.min_price) * 1, 2)) / 100) + 1 ASC Elapsed seconds: 0.00037789344787598
- SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` AS `e` 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 = '8' INNER JOIN `catalog_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1 ORDER BY FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1 ASC Elapsed seconds: 0.00037217140197754
- SELECT `size_idx`.`value`, COUNT(size_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `size_idx` ON size_idx.entity_id = e.entity_id AND size_idx.attribute_id = '180' AND size_idx.store_id = '1' GROUP BY `size_idx`.`value` Elapsed seconds: 0.00041294097900391
- SELECT `sleeve_length_idx`.`value`, COUNT(sleeve_length_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' INNER JOIN `catalog_product_index_eav` AS `sleeve_length_idx` ON sleeve_length_idx.entity_id = e.entity_id AND sleeve_length_idx.attribute_id = '178' AND sleeve_length_idx.store_id = '1' GROUP BY `sleeve_length_idx`.`value` Elapsed seconds: 0.00039505958557129
- SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' Elapsed seconds: 0.00033783912658691
- SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` 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 = '8' 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_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '184' AND gender_idx.store_id = 1 AND gender_idx.value = '94' ORDER BY `cat_index`.`position` ASC LIMIT 12 Elapsed seconds: 0.00036811828613281
- 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_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (423, 338)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '118', '119')) 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_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (423, 338)) AND (t_d.attribute_id IN ('73')) 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_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (423, 338)) AND (t_d.attribute_id IN ('75', '76', '120', '136', '137')) 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_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (423, 338)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) 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_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (423, 338)) AND (t_d.attribute_id IN ('96', '122', '124', '126', '127', '128', '129', '132')) AND (t_d.store_id = 0) Elapsed seconds: 0.0018119812011719
- SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 8 OR category_id IS NULL) AND (product_id IN('423', '338')) ORDER BY `category_id` DESC Elapsed seconds: 0.001176118850708
- SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('423', '338')) AND (stock_id=1) AND (website_id=1) Elapsed seconds: 0.00019598007202148
- SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (entity_pk_value IN('423', '338')) AND (entity_type = 1) AND (store_id = '1') Elapsed seconds: 0.00020790100097656
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.0001828670501709
- SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='msrp_enabled') AND (entity_type_id = :entity_type_id) Elapsed seconds: 0.00015997886657715
- SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.00011014938354492
- SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) Elapsed seconds: 0.00014996528625488
- SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (product_id = '423') ORDER BY position ASC Elapsed seconds: 0.00018692016601562
- 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 = '13') ORDER BY sort_order ASC Elapsed seconds: 0.0011579990386963
- 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 ('76', '115', '116', '71', '82', '85', '100', '103', '123', '92', '72', '83', '86', '101', '104', '147', '175', '73', '136', '84', '87', '105', '148', '176', '74', '137', '88', '106', '178', '80', '75', '95', '107', '179', '89', '93', '90', '109', '180', '94', '181', '99', '96', '77', '184', '97', '78', '102', '79', '98', '117', '91', '118', '108', '119', '110', '120', '111', '139', '112', '122', '140', '113', '127', '141', '114', '142', '143', '144', '145', '124', '146', '125', '126', '128', '129', '130', '131', '132')) AND (entity.attribute_set_id = :attribute_set_id) Elapsed seconds: 0.0006260871887207
- 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`.* FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) Elapsed seconds: 0.0011329650878906
- SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color`, `at_size`.`value` AS `size` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = '92') AND (`at_color`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_size` ON (`at_size`.`entity_id` = `e`.`entity_id`) AND (`at_size`.`attribute_id` = '180') AND (`at_size`.`store_id` = 0) WHERE (link_table.parent_id = 423) AND (((`e`.`required_options` != '1') OR (`e`.`required_options` IS NULL))) AND (at_color.value IS NOT NULL) AND (at_size.value IS NOT NULL) Elapsed seconds: 0.00053691864013672
- 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_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (302, 303, 304, 539, 540)) AND (t_d.attribute_id IN ('76', '136', '148', '137', '80', '75', '90', '99', '79', '91', '120')) 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_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (302, 303, 304, 539, 540)) AND (t_d.attribute_id IN ('71', '82', '85', '103', '123', '86', '147', '84', '87', '88', '95', '107', '109', '97', '98', '117', '118', '119', '112', '113', '114', '143', '130', '131', '206', '210')) 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_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (302, 303, 304, 539, 540)) AND (t_d.attribute_id IN ('100', '175', '176', '178', '179', '89', '181', '96', '184', '102', '139', '122', '140', '127', '141', '142', '144', '145', '124', '146', '125', '126', '128', '129', '132', '194', '192', '198', '208', '196', '195', '199', '197', '201', '182', '207', '188', '200', '193', '183', '190', '191', '81', '189', '209', '186', '187', '177')) 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_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (302, 303, 304, 539, 540)) AND (t_d.attribute_id IN ('72', '83', '101', '73', '106', '205', '202', '203', '204', '185')) 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_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (302, 303, 304, 539, 540)) AND (t_d.attribute_id IN ('104', '105', '93', '94', '77', '78')) AND (t_d.store_id = 0) Elapsed seconds: 0.0039339065551758
- SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('302', '303', '304', '539', '540')) Elapsed seconds: 0.00039482116699219
- SELECT `def`.*, IF(store.use_default IS NULL, def.use_default, store.use_default) AS `use_default`, IF(store.value IS NULL, def.value, store.value) AS `label` FROM `catalog_product_super_attribute_label` AS `def` LEFT JOIN `catalog_product_super_attribute_label` AS `store` ON store.product_super_attribute_id = def.product_super_attribute_id AND store.store_id = 1 WHERE (def.product_super_attribute_id IN (57, 58)) AND (def.store_id = 0) Elapsed seconds: 0.00023508071899414
- SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (57, 58)) AND (price.website_id = 0) Elapsed seconds: 0.00016593933105469
- 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 = '92') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00044488906860352
- 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 = '180') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC Elapsed seconds: 0.00046491622924805
- SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `report_compared_product_index` AS `idx_table` ON (idx_table.product_id=e.entity_id) AND (idx_table.visitor_id = '7648587') 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)) Elapsed seconds: 0.00063586235046387
- 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 = '7648587') 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)) Elapsed seconds: 0.00030994415283203
- 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`='footer_links_company') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1 Elapsed seconds: 0.00030183792114258
- SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.00012993812561035
- 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`='footer_links_sm') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1 Elapsed seconds: 0.0002598762512207
- SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.0001380443572998