SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291140 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291140 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392280,82737,971653,740761,208774,4237,505418,10387,1043054,952319,760410,998102,388210,853857,42353,938530,95343,890890,95271,143129,943853,863122,540101,885713,3644,302718,645313,776034,222643,56326,89315,873050,835316,117674,383688,606468,471341,270011,255055,215151,1046948,344444,257900,191482,509171,660280,657762,491884,983320,180015,297004,980989,382678,451658,821510,149866,832091,372158,180605,60977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]