SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000293s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000114s ]
SHOW FULL COLUMNS FROM `categories_to_products` [ RunTime:0.000166s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.081695s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` ASC LIMIT 0,30 [ RunTime:0.212610s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000168s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000117s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`price` DESC LIMIT 0,30 [ RunTime:0.218168s ]
SHOW FULL COLUMNS FROM `header_menu` [ RunTime:0.000264s ]
SELECT * FROM `header_menu` ORDER BY `weight` DESC [ RunTime:0.000093s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' LIMIT 1 [ RunTime:0.000101s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000082s ]
SELECT * FROM `categories` WHERE `parent_id` = 194 AND `status` = 1 LIMIT 100 [ RunTime:0.000093s ]
SELECT * FROM `categories` WHERE `parent_id` <> 0 [ RunTime:0.000271s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000204s ]
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` = '194' 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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.219833s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000167s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' LIMIT 1 [ RunTime:0.000118s ]
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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000227s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000092s ]
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` = '194' 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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000208s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000094s ]
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` = '194' 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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `marketplace_pages` [ RunTime:0.000237s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 0 AND `pid` = 0 ORDER BY `weight` [ RunTime:0.000092s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 1 AND `pid` = 1 ORDER BY `weight` [ RunTime:0.000092s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 10 AND `pid` = 10 ORDER BY `weight` [ RunTime:0.000084s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 5 AND `pid` = 5 ORDER BY `weight` [ RunTime:0.000088s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 6 AND `pid` = 6 ORDER BY `weight` [ RunTime:0.000087s ]
SELECT `id`,`mid`,`name`,`handle`,`pid`,`weight` FROM `marketplace_pages` WHERE `mid` = 1 AND `id` <> 9 AND `pid` = 9 ORDER BY `weight` [ RunTime:0.000081s ]
SELECT * FROM `categories` WHERE `handle` = 'cameras-optics' [ RunTime:0.000085s ]
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` = '194' 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` = '194' AND `b`.`status` = '1' AND `title` LIKE '%%' ORDER BY `b`.`product_id` DESC LIMIT 0,30 [ RunTime:0.000208s ]