SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000320s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ RunTime:0.000124s ]
SHOW FULL COLUMNS FROM `categories_to_products` [ RunTime:0.000139s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.243650s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` ASC LIMIT 0,30 [ RunTime:0.605013s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ RunTime:0.000176s ]
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` = '33' 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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` DESC LIMIT 0,30 [ RunTime:0.599162s ]
SHOW FULL COLUMNS FROM `header_menu` [ RunTime:0.000254s ]
SELECT * FROM `header_menu` ORDER BY `weight` DESC [ RunTime:0.000085s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' LIMIT 1 [ RunTime:0.000088s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ RunTime:0.000064s ]
SELECT * FROM `categories` WHERE `parent_id` = 33 AND `status` = 1 LIMIT 100 [ RunTime:0.000077s ]
SELECT * FROM `categories` WHERE `parent_id` <> 0 [ RunTime:0.000246s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ 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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000084s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.593422s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ RunTime:0.000185s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000098s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000146s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ 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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000067s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000128s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ 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` = '33' 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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000125s ]
SHOW FULL COLUMNS FROM `marketplace_pages` [ RunTime:0.000202s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 0 AND `pid` = 0 ORDER BY `weight` [ RunTime:0.000070s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 1 AND `pid` = 1 ORDER BY `weight` [ RunTime:0.000061s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 10 AND `pid` = 10 ORDER BY `weight` [ RunTime:0.000060s ]
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.000055s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 9 AND `pid` = 9 ORDER BY `weight` [ RunTime:0.000056s ]
SELECT * FROM `categories` WHERE `handle` = 'home-garden' [ RunTime:0.000060s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000060s ]
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` = '33' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000127s ]