Your Language:

QA SANDBOX FOR BRAIN ACADEMY

Menu Search Account

Cart 0

Recently added item(s) ×

You have no items in your shopping cart.

Women
Men
Accessories
Home & Decor
Sale
VIP
About Us

Search:

My Account
My Wishlist
My Cart
Checkout
Register
Log In

Home /
Lafayette Convertible Dress /
Product Reviews

Price:

Actual Price:

-OR-

Our price is lower than the manufacturer's "minimum advertised price." As a result, we cannot show you the price in catalog or the product page.

You have no obligation to purchase the product once you know the price. You can simply remove the item from your cart.

Lafayette Convertible Dress

$340.00

Price
Value
Quality

2 Review(s)

Availability: In stock

« Back to Main Product Info

Only 79 left

Product Name	Qty
Convertible Dress	18
Convertible Dress	13
Convertible Dress	24
Convertible Dress	24

Qty:

-OR-

Add to Wishlist
| Add to Compare

Customer Reviews 2 item(s)

2 Item(s)

Show

Nice

This dress is exceptionally flattering. I’m a pear shape and love how it slims and flatters my curves. The color is beautiful. I’m sure it will travel well. It’s perfect and I highly recommend.

Value
Quality
Price

Review by Lisa M / (Posted on 5/28/2013)

Great buy

This is such a gorgeous dress, not only is it versatile, its comfortable and flattering for those with curves. looks great with a little shrug too.

Quality
Price
Value

Review by JanaF / (Posted on 5/28/2013)

Write Your Own Review

You're reviewing: Lafayette Convertible Dress

How do you rate this product? *

	1 1 star	2 2 star	3 3 star	4 4 star	5 5 star
Price
Value
Quality

*Let us know your thoughts
*Summary of Your Review
*What's your nickname?

Newsletter

Company

About Us
Contact Us
Customer Service
Privacy Policy

Quick Links

Site Map
Search Terms
Advanced Search

Account

My Account
Orders and Returns

Connect With Us

Facebook
Twitter
YouTube
Pinterest
RSS

1.9.0.1
info
profiler
0.00 s
36.00 MB
104

Request
General
Handles
Events/Observer
Blocks
Config
PHP-Info

Controller Class:	Mage_Review_ProductController
Controller Module:	Mage_Review
Controller Action:	list
Params:	Array ( [id] => 425 [q] => [/index_php/english/review/product/list/id/425/] => )

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
review_product_list
PRODUCT_TYPE_configurable
page_one_column
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

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

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

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.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
- product.info
  - Class: Mage_Review_Block_Product_View
  - Template: frontend/rwd/default/template/catalog/product/view.phtml
  - product_review_list.toolbar
    - Class: Mage_Page_Block_Html_Pager
    - Template: frontend/rwd/default/template/page/html/pager.phtml
  - product_review_list.count
    - Class: Mage_Core_Block_Template
    - Template: frontend/base/default/template/review/product/view/count.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

Frontend Hints:	(Disable cache to use this feature)
Translate Inline:
Clear Cache:

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.

This program makes use of the Zend Scripting Language Engine:
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.ZrWvgX
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.ZrWvgX	/tmp/apc.ZrWvgX
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/review/product/list/id/425/"]	no value
_GET["/index_php/english/review/product/list/id/425/"]	no value
_SERVER["USER"]	www
_SERVER["HOME"]	/v1/www
_SERVER["FCGI_ROLE"]	RESPONDER
_SERVER["QUERY_STRING"]	/index.php/english/review/product/list/id/425/
_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/review/product/list/id/425/
_SERVER["DOCUMENT_URI"]	/index.php
_SERVER["DOCUMENT_ROOT"]	/v1/www/magento.mainacad.com
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_SOFTWARE"]	nginx/1.8.1
_SERVER["REMOTE_ADDR"]	18.207.108.191
_SERVER["REMOTE_PORT"]	37846
_SERVER["SERVER_ADDR"]	91.192.105.23
_SERVER["SERVER_PORT"]	80
_SERVER["SERVER_NAME"]	magento.mainacad.com
_SERVER["REDIRECT_STATUS"]	200
_SERVER["SCRIPT_FILENAME"]	/v1/www/magento.mainacad.com/index.php
_SERVER["HTTP_USER_AGENT"]	CCBot/2.0 (https://commoncrawl.org/faq/)
_SERVER["HTTP_ACCEPT"]	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"]	en-US,en;q=0.5
_SERVER["HTTP_IF_MODIFIED_SINCE"]	Tue, 26 May 2020 01:03:11 GMT
_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"]	1597468006.2799
_SERVER["REQUEST_TIME"]	1597468006

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.

Profiler

Name

Time

Cnt

Emalloc

RealMem

Database Queries

Executed:	104 queries in 0.05399751663208 seconds
Average query length:	0.00051920689069308 seconds
Queries per second:	1926.0145000486
Longest query length:	0.013296842575073
Longest query:	SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('4', '10', '11', '12', '13', '42', '5', '14', '15', '16', '17', '40', '6', '18', '19', '20', '21', '7', '22', '23', '24', '25', '8', '26', '27', '28', '29', '9')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
Total queries:	104
Insert queries:	2
Update queries:	0
Read queries:	99
Delete queries:	0
Transactions:	2

SHOW TABLE STATUS LIKE 'core_resource' Elapsed seconds: 0.00043416023254395
SELECT `core_resource`.* FROM `core_resource` Elapsed seconds: 0.00016498565673828
SELECT `index_process`.`indexer_code` FROM `index_process` Elapsed seconds: 0.00011014938354492
SELECT `core_website`.`website_id`, `core_website`.`code`, `core_website`.`name` FROM `core_website` Elapsed seconds: 0.00012922286987305
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.00015592575073242
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.0017471313476562
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.00038695335388184
SELECT `main_table`.* FROM `core_website` AS `main_table` ORDER BY main_table.sort_order ASC, main_table.name ASC Elapsed seconds: 0.00014305114746094
SELECT `main_table`.* FROM `core_store_group` AS `main_table` ORDER BY main_table.name ASC Elapsed seconds: 0.0001220703125
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.00028800964355469
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.00023198127746582
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.00022292137145996
begin Elapsed seconds: 5.0067901611328E-5
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?) Elapsed seconds: 0.00014281272888184
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.00010299682617188
commit Elapsed seconds: 0.00066804885864258
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.00020718574523926
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id =425) Elapsed seconds: 0.00013399124145508
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.0011999607086182
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 = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC Elapsed seconds: 0.0015201568603516
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`='121') Elapsed seconds: 0.00013494491577148
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 9.4890594482422E-5
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 = '425') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC Elapsed seconds: 0.00040698051452637
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0) Elapsed seconds: 0.00018906593322754
SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC Elapsed seconds: 0.00019001960754395
SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item` INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (`cataloginventory_stock_item`.`product_id`='425') AND (stock_id = :stock_id) Elapsed seconds: 0.00019407272338867
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1) Elapsed seconds: 0.00013208389282227
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 = '425') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC Elapsed seconds: 0.00035500526428223
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update` INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC Elapsed seconds: 0.00063681602478027
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update` INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC Elapsed seconds: 0.00041007995605469
SELECT `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.00039982795715332
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.00040817260742188
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.00040698051452637
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.00041389465332031
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.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.00042200088500977
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.00041604042053223
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (`core_url_rewrite`.`id_path`='product/425') AND (store_id IN(0, '1')) ORDER BY `store_id` DESC LIMIT 1 Elapsed seconds: 0.00035309791564941
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='customer') Elapsed seconds: 0.00016498565673828
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_category') Elapsed seconds: 0.00023794174194336
SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = :entity_id) Elapsed seconds: 0.00012111663818359
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (`catalog_category_entity`.`entity_id` = '2') Elapsed seconds: 0.00012898445129395
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.00025200843811035
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.0002739429473877
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.00020289421081543
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.00051689147949219
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.00017189979553223
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='include_in_menu') AND (entity_type_id = :entity_type_id) Elapsed seconds: 0.00015091896057129
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.00014400482177734
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.013296842575073
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.0010280609130859
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2') Elapsed seconds: 0.00012397766113281
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.00063705444335938
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.0011210441589355
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.00020408630371094
SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2020-08-14') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('425')) Elapsed seconds: 0.00016498565673828
SELECT `main_table`.* FROM `catalog_product_super_attribute` AS `main_table` WHERE (product_id = '425') ORDER BY position ASC Elapsed seconds: 0.0002129077911377
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.00065112113952637
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.0011000633239746
SELECT `e`.*, `link_table`.`parent_id`, `at_color`.`value` AS `color`, `at_size`.`value` AS `size` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' INNER JOIN `catalog_product_entity_int` AS `at_color` ON (`at_color`.`entity_id` = `e`.`entity_id`) AND (`at_color`.`attribute_id` = '92') AND (`at_color`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_size` ON (`at_size`.`entity_id` = `e`.`entity_id`) AND (`at_size`.`attribute_id` = '180') AND (`at_size`.`store_id` = 0) WHERE (link_table.parent_id = 425) 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.00045490264892578
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 (310, 311, 312, 313, 314)) 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 (310, 311, 312, 313, 314)) 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 (310, 311, 312, 313, 314)) 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 (310, 311, 312, 313, 314)) 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 (310, 311, 312, 313, 314)) 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.0038979053497314
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('310', '311', '312', '313', '314')) Elapsed seconds: 0.00036501884460449
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 (61, 62)) AND (def.store_id = 0) Elapsed seconds: 0.00023698806762695
SELECT `price`.* FROM `catalog_product_super_attribute_pricing` AS `price` WHERE (price.product_super_attribute_id IN (61, 62)) AND (price.website_id = 0) Elapsed seconds: 0.00016403198242188
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.00045990943908691
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.00048494338989258
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') Elapsed seconds: 0.00031304359436035
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='msrp_enabled') AND (entity_type_id = :entity_type_id) Elapsed seconds: 0.00016403198242188
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.00011301040649414
SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) Elapsed seconds: 0.00032901763916016
SELECT COUNT(*) AS `review_count` FROM `review` WHERE (review.entity_pk_value = :pk_value) AND (review.status_id = :status_id) Elapsed seconds: 0.0004878044128418
SELECT DISTINCT `main_table`.*, `rating_entity`.`entity_code`, IFNULL(title.value, main_table.rating_code) AS `rating_code` FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') ORDER BY main_table.position ASC Elapsed seconds: 0.00043582916259766
SELECT `rating_option_vote`.`rating_id`, SUM(rating_option_vote.`percent`) AS `sum`, COUNT(*) AS `count` FROM `rating_option_vote` INNER JOIN `review_store` ON rating_option_vote.review_id=review_store.review_id AND review_store.store_id = :store_id INNER JOIN `rating_store` AS `rst` ON rst.rating_id = rating_option_vote.rating_id AND rst.store_id = :rst_store_id INNER JOIN `review` ON review_store.review_id=review.review_id AND review.status_id=1 WHERE (rating_option_vote.rating_id IN('3', '2', '1')) AND (rating_option_vote.entity_pk_value=:pk_value) GROUP BY `rating_option_vote`.`rating_id` Elapsed seconds: 0.00094699859619141
SELECT DISTINCT COUNT(*) FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') Elapsed seconds: 0.00020599365234375
SELECT COUNT(*) FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (store.store_id IN('1')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='425') Elapsed seconds: 0.00035500526428223
SELECT COUNT(*) FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id WHERE (store.store_id IN('1')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='425') Elapsed seconds: 0.00048708915710449
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='425') ORDER BY main_table.created_at DESC LIMIT 10 Elapsed seconds: 0.00072789192199707
SELECT `main_table`.*, `rating`.`rating_code`, IFNULL(title.value, rating.rating_code) AS `rating_code`, `store`.* FROM `rating_option_vote` AS `main_table` INNER JOIN `review_store` AS `rstore` ON main_table.review_id=rstore.review_id AND rstore.store_id=1 INNER JOIN `rating` ON rating.rating_id = main_table.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id AND store.store_id = '1' WHERE (main_table.review_id = '42') Elapsed seconds: 0.0003509521484375
SELECT `main_table`.*, `rating`.`rating_code`, IFNULL(title.value, rating.rating_code) AS `rating_code`, `store`.* FROM `rating_option_vote` AS `main_table` INNER JOIN `review_store` AS `rstore` ON main_table.review_id=rstore.review_id AND rstore.store_id=1 INNER JOIN `rating` ON rating.rating_id = main_table.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id AND store.store_id = '1' WHERE (main_table.review_id = '42') Elapsed seconds: 0.00026702880859375
SELECT `main_table`.*, `rating`.`rating_code`, IFNULL(title.value, rating.rating_code) AS `rating_code`, `store`.* FROM `rating_option_vote` AS `main_table` INNER JOIN `review_store` AS `rstore` ON main_table.review_id=rstore.review_id AND rstore.store_id=1 INNER JOIN `rating` ON rating.rating_id = main_table.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id AND store.store_id = '1' WHERE (main_table.review_id = '41') Elapsed seconds: 0.00027179718017578
SELECT `main_table`.*, `rating`.`rating_code`, IFNULL(title.value, rating.rating_code) AS `rating_code`, `store`.* FROM `rating_option_vote` AS `main_table` INNER JOIN `review_store` AS `rstore` ON main_table.review_id=rstore.review_id AND rstore.store_id=1 INNER JOIN `rating` ON rating.rating_id = main_table.rating_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id AND store.store_id = '1' WHERE (main_table.review_id = '41') Elapsed seconds: 0.00026392936706543
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id ='425') Elapsed seconds: 0.00014710426330566
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 = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '13' WHERE (attr_table.entity_id = '425') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC Elapsed seconds: 0.0014991760253906
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_id`='121') Elapsed seconds: 0.00014090538024902
SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) Elapsed seconds: 0.0001070499420166
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 = '425') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC Elapsed seconds: 0.00032806396484375
SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='425') AND (website_id = 0) Elapsed seconds: 0.00015687942504883
SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty` FROM `catalog_product_entity_tier_price` WHERE (entity_id='425') AND (website_id = 0) ORDER BY `qty` ASC Elapsed seconds: 0.00017380714416504
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('425')) AND (stock_id=1) AND (website_id=1) Elapsed seconds: 0.00013995170593262
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 = '425') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC Elapsed seconds: 0.00055193901062012
SELECT DISTINCT `main_table`.*, `rating_entity`.`entity_code`, IFNULL(title.value, main_table.rating_code) AS `rating_code` FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') ORDER BY main_table.position ASC Elapsed seconds: 0.00053095817565918
SELECT `main_table`.* FROM `rating_option` AS `main_table` WHERE (rating_id IN('3', '2', '1')) ORDER BY main_table.position ASC Elapsed seconds: 0.00018596649169922
SELECT DISTINCT `main_table`.*, `rating_entity`.`entity_code`, IFNULL(title.value, main_table.rating_code) AS `rating_code` FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') ORDER BY main_table.position ASC Elapsed seconds: 0.00028204917907715
SELECT `main_table`.* FROM `rating_option` AS `main_table` WHERE (rating_id IN('3', '2', '1')) ORDER BY main_table.position ASC Elapsed seconds: 0.00015902519226074
SELECT DISTINCT COUNT(*) FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') Elapsed seconds: 0.00022506713867188
SELECT DISTINCT `main_table`.*, `rating_entity`.`entity_code`, IFNULL(title.value, main_table.rating_code) AS `rating_code` FROM `rating` AS `main_table` INNER JOIN `rating_entity` ON main_table.entity_id=rating_entity.entity_id LEFT JOIN `rating_title` AS `title` ON main_table.rating_id=title.rating_id AND title.store_id = 1 INNER JOIN `rating_store` AS `store` ON main_table.rating_id = store.rating_id WHERE (store.store_id IN('1')) AND (rating_entity.entity_code='product') ORDER BY main_table.position ASC Elapsed seconds: 0.00026512145996094
SELECT `main_table`.* FROM `rating_option` AS `main_table` WHERE (rating_id IN('3', '2', '1')) ORDER BY main_table.position ASC Elapsed seconds: 0.00015616416931152
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.00028204917907715
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.00012397766113281
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.0004878044128418
SELECT `cms_block_store`.`store_id` FROM `cms_block_store` WHERE (block_id = :block_id) Elapsed seconds: 0.00027799606323242