SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140417 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140417 [ RunTime:0.002810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032551,471334,217665,52264,324463,684633,230329,142041,235658,975902,25800,1028713,146504,33422,423849,515382,31831,476340,924551,88156,818418,480159,739990,601657,1025747,80728,905346,120632,192588,280603,405592,148405,845981,292114,63839,495999,770480,235455,95014,448613,1189,235823,154754,972065,844066,978387,738067,191276,837643,1010288,1021644,683178,730387,640629,178294,432669,921221,476708,606262,187185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]