SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201228 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201228 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925529,623955,400665,747070,334111,659498,917562,611169,63219,245814,800122,1030644,948083,504312,741199,662676,139493,5382,241765,14761,49530,809765,518729,118941,848843,739967,656797,1019747,116392,768412,115928,608415,517445,840376,832491,1040373,686329,24973,897780,362847,947716,20804,484915,598619,1045809,763881,770630,175606,114614,905527,235989,446492,59766,1016646,807009,888379,886051,54014,848961,924438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]