SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.002902s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.000917s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.003327s ]
SELECT * FROM `jshop_b2c_goods` WHERE `marketable` = 1 AND `id` = 29 LIMIT 1 [ RunTime:0.002783s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.002047s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 29 [ RunTime:0.000970s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.001883s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '16d1bd4977bced2dfec304e9a864b105' LIMIT 1 [ RunTime:0.000823s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.001598s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.001731s ]
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` = '29' AND `t`.`type` = 'goods' [ RunTime:0.001322s ]
UPDATE `jshop_b2c_goods` SET `view_count` = `view_count` + 1 WHERE `id` = 29 [ RunTime:0.011049s ]
SELECT * FROM `jshop_b2c_goods` ORDER BY `view_count` LIMIT 5 [ RunTime:0.012185s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.001155s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000818s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' LIMIT 1 [ RunTime:0.000772s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000578s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000568s ]