SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.003944s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.026403s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.019790s ]
SELECT * FROM `jshop_b2c_goods` WHERE `marketable` = 1 AND `id` = 28 LIMIT 1 [ RunTime:0.004044s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.002371s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 28 [ RunTime:0.043727s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.005689s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.009524s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.002045s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.001947s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '28' AND `t`.`type` = 'goods' [ RunTime:0.019855s ]
UPDATE `jshop_b2c_goods` SET `view_count` = `view_count` + 1 WHERE `id` = 28 [ RunTime:0.015705s ]
SELECT * FROM `jshop_b2c_goods` ORDER BY `view_count` LIMIT 5 [ RunTime:0.127194s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.001078s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 25 [ RunTime:0.001258s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000580s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 21 [ RunTime:0.000772s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' LIMIT 1 [ RunTime:0.000614s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 16 [ RunTime:0.000708s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000570s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 24 [ RunTime:0.000688s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000634s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 22 [ RunTime:0.000729s ]
