SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.003813s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.001220s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.003965s ]
SELECT * FROM `jshop_b2c_goods` WHERE `marketable` = 1 AND `id` = 28 LIMIT 1 [ RunTime:0.002788s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.002155s ]
SELECT * FROM `jshop_b2c_products` WHERE `goods_id` = 28 [ RunTime:0.001090s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.001977s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.001030s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.001797s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.001912s ]
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.001085s ]
UPDATE `jshop_b2c_goods` SET `view_count` = `view_count` + 1 WHERE `id` = 28 [ RunTime:0.010181s ]
SELECT * FROM `jshop_b2c_goods` ORDER BY `view_count` LIMIT 5 [ RunTime:0.018035s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000617s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000564s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000520s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.000509s ]