SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000293s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000100s ]
SHOW FULL COLUMNS FROM `categories_to_products` [ RunTime:0.000129s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.249894s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` ASC LIMIT 0,30 [ RunTime:0.596690s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000174s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000093s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` DESC LIMIT 0,30 [ RunTime:0.615380s ]
SHOW FULL COLUMNS FROM `header_menu` [ RunTime:0.000257s ]
SELECT * FROM `header_menu` ORDER BY `weight` DESC [ RunTime:0.000075s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' LIMIT 1 [ RunTime:0.000078s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000058s ]
SELECT * FROM `categories` WHERE `parent_id` = 15 AND `status` = 1 LIMIT 100 [ RunTime:0.000072s ]
SELECT * FROM `categories` WHERE `parent_id` <> 0 [ RunTime:0.000242s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000082s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.603925s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000151s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000095s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000113s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000072s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000063s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000094s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000071s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000059s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000088s ]
SHOW FULL COLUMNS FROM `marketplace_pages` [ RunTime:0.000201s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 0 AND `pid` = 0 ORDER BY `weight` [ RunTime:0.000071s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 1 AND `pid` = 1 ORDER BY `weight` [ RunTime:0.000066s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 10 AND `pid` = 10 ORDER BY `weight` [ RunTime:0.000059s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 5 AND `pid` = 5 ORDER BY `weight` [ RunTime:0.000058s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 6 AND `pid` = 6 ORDER BY `weight` [ RunTime:0.000057s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 9 AND `pid` = 9 ORDER BY `weight` [ RunTime:0.000060s ]
SELECT * FROM `categories` WHERE `handle` = 'furniture' [ RunTime:0.000063s ]
SELECT COUNT(*) AS think_count FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000061s ]
SELECT `b`.*,`c`.`store_name`,b.encoded_shop_id as store_handle FROM `categories_to_products` `a` INNER JOIN `products` `b` ON `a`.`pid`=`b`.`product_id` INNER JOIN `stores` `c` ON `c`.`encoded_id`=`b`.`encoded_shop_id` WHERE `a`.`cid` = '15' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000090s ]