SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323987 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323987 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176045,381775,933726,120304,380724,52828,74255,510138,1022663,843321,1019792,375169,891319,89822,655388,367544,500979,855985,550735,785524,15135,86505,243929,859909,612746,641379,543006,804189,526800,1006692,998580,671881,14250,344311,97738,777983,134400,539983,136387,1044642,644250,32914,442906,88252,920166,732003,183729,243348,592602,417912,390274,486606,65039,450097,953674,611186,395318,798236,11886,356751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]