SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000284s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000101s ]
SHOW FULL COLUMNS FROM `categories_to_products` [ RunTime:0.000141s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.136844s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` ASC LIMIT 0,30 [ RunTime:0.311533s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000159s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000099s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` DESC LIMIT 0,30 [ RunTime:0.338789s ]
SHOW FULL COLUMNS FROM `header_menu` [ RunTime:0.000262s ]
SELECT * FROM `header_menu` ORDER BY `weight` DESC [ RunTime:0.000079s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' LIMIT 1 [ RunTime:0.000082s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000062s ]
SELECT * FROM `categories` WHERE `parent_id` = 30 AND `status` = 1 LIMIT 100 [ RunTime:0.000086s ]
SELECT * FROM `categories` WHERE `parent_id` <> 0 [ RunTime:0.000224s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000186s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000089s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.308915s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000156s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000097s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000107s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000077s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000075s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000097s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ RunTime:0.000065s ]
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` = '30' 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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000092s ]
SHOW FULL COLUMNS FROM `marketplace_pages` [ RunTime:0.000198s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 0 AND `pid` = 0 ORDER BY `weight` [ RunTime:0.000068s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 1 AND `pid` = 1 ORDER BY `weight` [ RunTime:0.000073s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 10 AND `pid` = 10 ORDER BY `weight` [ RunTime:0.000069s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 5 AND `pid` = 5 ORDER BY `weight` [ RunTime:0.000063s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 6 AND `pid` = 6 ORDER BY `weight` [ RunTime:0.000068s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 9 AND `pid` = 9 ORDER BY `weight` [ RunTime:0.000077s ]
SELECT * FROM `categories` WHERE `handle` = 'office-supplies' [ 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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000070s ]
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` = '30' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000107s ]