SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.004856s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.001326s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.003753s ]
SELECT * FROM `jshop_b2c_goods` WHERE `marketable` = 1 AND `id` = 20 LIMIT 1 [ RunTime:0.001178s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.002089s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 20 [ RunTime:0.001275s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.002003s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000993s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.001741s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.001803s ]
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` = '20' AND `t`.`type` = 'goods' [ RunTime:0.001500s ]
UPDATE `jshop_b2c_goods` SET `view_count` = `view_count` + 1 WHERE `id` = 20 [ RunTime:0.012550s ]
SELECT * FROM `jshop_b2c_goods` ORDER BY `view_count` LIMIT 5 [ RunTime:0.024950s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000979s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000589s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000625s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000591s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.001685s ]
