Skip to content

Instantly share code, notes, and snippets.

View ydenyshchenk's full-sized avatar

Yuriy Denyshchenko ydenyshchenk

View GitHub Profile
SELECT m.metadata_id, m.table_name, m.changelog_name, IF(ccd.value = 1, "On Save", "Scheduled") AS "Mode", m.version_id AS "Processed version", v.version_id AS "Changelog version"
, CAST(v.version_id AS SIGNED) - CAST(m.version_id AS SIGNED) AS "Behind"
FROM (
(SELECT "enterprise_url_rewrite_redirect_cl" AS changelog_name, "index_management/index_options/redirect_url_rewrite" AS path, version_id FROM enterprise_url_rewrite_redirect_cl ORDER BY version_id DESC LIMIT 1)
UNION (SELECT "cataloginventory_stock_status_cl", "index_management/index_options/product_price_and_stock", version_id FROM cataloginventory_stock_status_cl ORDER BY version_id DESC LIMIT 1)
UNION (SELECT "catalogsearch_fulltext_cl", "index_management/index_options/fulltext", version_id FROM catalogsearch_fulltext_cl ORDER BY version_id DESC LIMIT 1)
UNION (SELECT "enterprise_url_rewrite_category_cl", "index_management/index_options/category_url_rewrite", version_id FROM enterprise_url_rewrite_category_cl ORDER BY version_id DESC LIMIT 1)
UNION
diff --git a/index.php b/index.php
index bec6b29..fdce413 100644
--- a/index.php
+++ b/index.php
@@ -84,4 +84,46 @@ $mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : ''
/* Run store or run website */
$mageRunType = isset($_SERVER['MAGE_RUN_TYPE']) ? $_SERVER['MAGE_RUN_TYPE'] : 'store';
+$totalLoadTimeStart = microtime(true);
Mage::run($mageRunCode, $mageRunType);
@ydenyshchenk
ydenyshchenk / magento-2-sql-debug.patch
Created July 21, 2016 10:17
Magento 2 - SQL Debug
diff --git app/etc/di.xml app/etc/di.xml
index 69403de..b43d771 100755
--- app/etc/di.xml
+++ app/etc/di.xml
@@ -93,7 +93,12 @@
<preference for="Magento\Framework\Api\MetadataObjectInterface" type="Magento\Framework\Api\AttributeMetadata"/>
<preference for="Magento\Framework\Api\SearchCriteriaInterface" type="Magento\Framework\Api\SearchCriteria"/>
<preference for="Magento\Framework\App\Rss\UrlBuilderInterface" type="Magento\Framework\App\Rss\UrlBuilder"/>
- <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\Quiet"/>
+ <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/>