- Description
-
Details
Two button, single vented, notched lapels. Slim cut through the shoulders chest and waist. Flap pockets, welt inside chest pockets. Cotton/lycra. Dry clean. - Additional Information
-
Additional Information
Occasion Evening Type Blazers Gender Male - Reviews
-
QA SANDBOX FOR BRAIN ACADEMY
Newsletter
Quick Links
Account
- 1.9.0.1
-
info -
profiler -
0.00 s -
38.50 MB -
102
powered by mgt--commerce.com
| Controller Class: | Mage_Catalog_ProductController |
| Controller Module: | Mage_Catalog |
| Controller Action: | view |
| Params: |
Array
(
[id] => 407
[q] =>
[/index_php/english/stretch-cotton-blazer-632_html] =>
)
|
| 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_product_view |
| PRODUCT_TYPE_configurable |
| PRODUCT_407 |
| customer_logged_out |
| MAP_popup |
| MAP_price_msrp_item |
| 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
- 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
- product.info
- Class: Mage_Catalog_Block_Product_View
- Template: frontend/rwd/default/template/catalog/product/view.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
- external.pagecache.cookie
- Class: Mage_Core_Block_Template
- Template: frontend/base/default/template/pagecache/cookie.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
- 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.ipBMqy |
| 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.ipBMqy | /tmp/apc.ipBMqy |
| 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/stretch-cotton-blazer-632_html"] | no value |
| _GET["/index_php/english/stretch-cotton-blazer-632_html"] | no value |
| _SERVER["USER"] | www |
| _SERVER["HOME"] | /v1/www |
| _SERVER["FCGI_ROLE"] | RESPONDER |
| _SERVER["QUERY_STRING"] | /index.php/english/stretch-cotton-blazer-632.html |
| _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/stretch-cotton-blazer-632.html |
| _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"] | 100.24.125.162 |
| _SERVER["REMOTE_PORT"] | 52832 |
| _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_ACCEPT_ENCODING"] | br,gzip |
| _SERVER["HTTP_HOST"] | magento.mainacad.com |
| _SERVER["HTTP_CONNECTION"] | Keep-Alive |
| _SERVER["PHP_SELF"] | /index.php |
| _SERVER["REQUEST_TIME_FLOAT"] | 1604163876.4712 |
| _SERVER["REQUEST_TIME"] | 1604163876 |
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. |
![[TR]](http://magento.mainacad.com/skin/frontend/base/default/images/fam_book_open.png)
| Name | Time | Cnt | Emalloc | RealMem |
| Executed: | 102 queries in 0.093988180160522 seconds |
| Average query length: | 0.00092145274667179 seconds |
| Queries per second: | 1085.2428446406 |
| Longest query length: | 0.014805793762207 |
| Longest query: | INSERT INTO `report_viewed_product_index` (`visitor_id`,`customer_id`,`product_id`,`store_id`,`added_at`) VALUES (?, ?, ?, ?, '2020-10-31 17:04:37') ON DUPLICATE KEY UPDATE `visitor_id` = VALUES(`visitor_id`), `customer_id` = VALUES(`customer_id`), `product_id` = VALUES(`product_id`), `store_id` = VALUES(`store_id`), `added_at` = VALUES(`added_at`) |
| Total queries: | 102 |
| Insert queries: | 4 |
| Update queries: | 0 |
| Read queries: | 90 |
| Delete queries: | 0 |
| Transactions: | 6 |
- SHOW TABLE STATUS LIKE 'core_resource' Elapsed seconds: 0.00059986114501953
- SELECT `core_resource`.* FROM `core_resource` Elapsed seconds: 0.0004417896270752
- SELECT `index_process`.`indexer_code` FROM `index_process` Elapsed seconds: 0.00013017654418945
- SELECT `core_website`.`website_id`, `core_website`.`code`, `core_website`.`name` FROM `core_website` Elapsed seconds: 0.0001368522644043
- 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.00021100044250488
- 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.0017681121826172
- 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.00033211708068848
- SELECT `main_table`.* FROM `core_website` AS `main_table` ORDER BY main_table.sort_order ASC, main_table.name ASC Elapsed seconds: 0.00014901161193848
- SELECT `main_table`.* FROM `core_store_group` AS `main_table` ORDER BY main_table.name ASC Elapsed seconds: 0.00012803077697754
- 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.010087013244629
- 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.00020313262939453
- 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.00015997886657715
- begin Elapsed seconds: 6.103515625E-5
- INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?) Elapsed seconds: 0.00013613700866699
- 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.00011610984802246
- commit Elapsed seconds: 0.00058889389038086
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.00022602081298828
- SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =407) Elapsed seconds: 0.00013113021850586
- 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.0012428760528564
- SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '407') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '407') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '407') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '407') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '407') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC Elapsed seconds: 0.0016260147094727
- SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`='121') Elapsed seconds: 0.00013089179992676
- SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.00010395050048828
- SELECT `main`.`value_id`, `main`.`value` AS `file`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main` LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = '88') AND (main.entity_id = '407') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC Elapsed seconds: 0.0004119873046875
- SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='407') AND (website_id = 0) Elapsed seconds: 0.00017499923706055
- SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id='407') AND (website_id = 0) ORDER BY `qty` ASC Elapsed seconds: 0.00020694732666016
- SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item` INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`='407') AND (stock_id = :stock_id) Elapsed seconds: 0.00020313262939453
- SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('407')) AND (stock_id=1) AND (website_id=1) Elapsed seconds: 0.00013113021850586
- SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '1' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '1' WHERE (product_id = '407') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC Elapsed seconds: 0.00035500526428223
- SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 407) Elapsed seconds: 0.00015091896057129
- SELECT `catalog_category_product_index`.`product_id` FROM `catalog_category_product_index` WHERE (product_id = 407) AND (category_id = 0) Elapsed seconds: 0.0001528263092041
- begin Elapsed seconds: 5.2928924560547E-5
- INSERT INTO `report_viewed_product_index` (`visitor_id`,`customer_id`,`product_id`,`store_id`,`added_at`) VALUES (?, ?, ?, ?, '2020-10-31 17:04:37') ON DUPLICATE KEY UPDATE `visitor_id` = VALUES(`visitor_id`), `customer_id` = VALUES(`customer_id`), `product_id` = VALUES(`product_id`), `store_id` = VALUES(`store_id`), `added_at` = VALUES(`added_at`) Elapsed seconds: 0.014805793762207
- commit Elapsed seconds: 0.00058913230895996
- 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 = '16846334') 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.00041604042053223
- begin Elapsed seconds: 4.7922134399414E-5
- INSERT INTO `report_event` (`logged_at`, `event_type_id`, `object_id`, `subject_id`, `subtype`, `store_id`) VALUES ('2020-10-31 17:04:37', ?, ?, ?, ?, ?) Elapsed seconds: 0.0001370906829834
- commit Elapsed seconds: 0.00050592422485352
- 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.00064301490783691
- 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.00045990943908691
- 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.00043797492980957
- 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.0011711120605469
- 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.0010981559753418
- 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.00050091743469238
- 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.00040793418884277
- 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.00041794776916504
- 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.00043010711669922
- 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.00043416023254395
- 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.00043988227844238
- SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='product/407') AND (store_id IN(0, '1')) ORDER BY `store_id` DESC LIMIT 1 Elapsed seconds: 0.0007319450378418
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category') Elapsed seconds: 0.00063800811767578
- SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id) Elapsed seconds: 0.00031685829162598
- SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') Elapsed seconds: 0.00014400482177734
- 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.00023698806762695
- SELECT `main_table`.`attribute_id`, `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_input`, `main_table`.`source_model` 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=3) AND (attribute_code IN('name', 'url_key', 'is_active')) Elapsed seconds: 0.00062012672424316
- 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.00028395652770996
- 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.00055599212646484
- 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.00017213821411133
- SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='include_in_menu') AND (entity_type_id = :entity_type_id) Elapsed seconds: 0.00016283988952637
- SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.00010800361633301
- SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) Elapsed seconds: 0.00013113021850586
- 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.013767004013062
- 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.0027370452880859
- SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2') Elapsed seconds: 0.00034403800964355
- 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.0017049312591553
- 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 = '2') AND (attr_table.store_id IN (0, 1)) UNION ALL 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 = '2') 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 = '2') 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 = '2') 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 = '2') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC Elapsed seconds: 0.0028049945831299
- SELECT `cms_page`.* FROM `cms_page` INNER JOIN `cms_page_store` ON cms_page.page_id = cms_page_store.page_id WHERE (`cms_page`.`page_id`=3) AND (is_active = 1) AND (cms_page_store.store_id IN (0, 1)) ORDER BY `cms_page_store`.`store_id` DESC LIMIT 1 Elapsed seconds: 0.00042915344238281
- SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (product_id = '407') ORDER BY position ASC Elapsed seconds: 0.00036096572875977
- SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity` LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_id IN ('115', '116', '71', '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', '76', '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.00072503089904785
- 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.0025029182434082
- 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_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 = 407) 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.00097393989562988
- 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 (246, 247, 248, 508, 509)) 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 (246, 247, 248, 508, 509)) 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 (246, 247, 248, 508, 509)) 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 (246, 247, 248, 508, 509)) AND (t_d.attribute_id IN ('104', '105', '93', '94', '77', '78')) 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 (246, 247, 248, 508, 509)) AND (t_d.attribute_id IN ('136', '148', '137', '80', '75', '90', '76', '99', '79', '91', '120')) AND (t_d.store_id = 0) Elapsed seconds: 0.0072381496429443
- 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('246', '247', '248', '508', '509')) Elapsed seconds: 0.000762939453125
- 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 (23, 24)) AND (def.store_id = 0) Elapsed seconds: 0.00050497055053711
- SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (23, 24)) AND (price.website_id = 0) Elapsed seconds: 0.00043988227844238
- 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.00053501129150391
- 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.00058603286743164
- SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=1) Elapsed seconds: 0.00022387504577637
- (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 12)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '90034', '90034*', '9003*', '900*', '90*', '9*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 12)) AND (rate.zip_is_range IS NOT NULL) AND ('90034' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC Elapsed seconds: 0.00077486038208008
- SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0) Elapsed seconds: 0.00011491775512695
- SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 10) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC Elapsed seconds: 0.00073099136352539
- SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2020-10-31') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('407')) Elapsed seconds: 0.00019288063049316
- SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.00051689147949219
- SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='msrp_enabled') AND (entity_type_id = :entity_type_id) Elapsed seconds: 0.00045895576477051
- SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.0003349781036377
- SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) Elapsed seconds: 0.00035309791564941
- SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='407') AND (store_id = 1) Elapsed seconds: 0.00025200843811035
- SELECT `catalogrule_product`.* FROM `catalogrule_product` WHERE (website_id = '1') AND (customer_group_id = 0) AND (product_id = '407') AND (from_time = 0 or from_time < 1604138677) AND (to_time = 0 or to_time > 1604138677) Elapsed seconds: 0.0002751350402832
- 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.00068497657775879
- SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 1) Elapsed seconds: 0.00019407272338867
- SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 407) AND (`e`.`entity_id` != '407') ORDER BY `position` ASC Elapsed seconds: 0.00082612037658691
- SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 407) AND (`e`.`entity_id` != '407') Elapsed seconds: 0.00052714347839355
- 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.00038409233093262
- 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.00038599967956543
- 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`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (store.store_id IN('1')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='407') ORDER BY main_table.created_at DESC Elapsed seconds: 0.0003659725189209
- SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 4) Elapsed seconds: 0.00017380714416504
- SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 407) AND (`e`.`entity_id` != '407') Elapsed seconds: 0.00045180320739746
- SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '4' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 407) AND (`e`.`entity_id` != '407') ORDER BY `position` ASC LIMIT 6 Elapsed seconds: 0.00053906440734863
- 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.0003352165222168
- SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.00016307830810547
- 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.00026917457580566
- SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.0001380443572998