SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000334s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000122s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.047016s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` ASC LIMIT 0,30 [ RunTime:0.110281s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000155s ]
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` = '52' 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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` DESC LIMIT 0,30 [ RunTime:0.111125s ]
SHOW FULL COLUMNS FROM `header_menu` [ RunTime:0.000294s ]
SELECT * FROM `header_menu` ORDER BY `weight` DESC [ RunTime:0.000078s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' LIMIT 1 [ RunTime:0.000085s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000063s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ 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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000083s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.112130s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000147s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000111s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000155s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000102s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000103s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000169s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000109s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000085s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000129s ]
SHOW FULL COLUMNS FROM `marketplace_pages` [ RunTime:0.000223s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 0 AND `pid` = 0 ORDER BY `weight` [ RunTime:0.000089s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 1 AND `pid` = 1 ORDER BY `weight` [ RunTime:0.000079s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 10 AND `pid` = 10 ORDER BY `weight` [ RunTime:0.000099s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 5 AND `pid` = 5 ORDER BY `weight` [ RunTime:0.000083s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 6 AND `pid` = 6 ORDER BY `weight` [ RunTime:0.000073s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 9 AND `pid` = 9 ORDER BY `weight` [ RunTime:0.000082s ]
SELECT * FROM `categories` WHERE `handle` = 'food-beverages-tobacco' [ RunTime:0.000068s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000072s ]
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` = '52' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000112s ]