SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426940 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426940 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181939,705268,190244,195720,198149,577856,214328,107447,357522,750615,515657,660178,452870,294921,5640,928158,476340,564199,874299,735407,1026442,209915,25323,232568,22429,173949,802600,128361,236150,86583,235072,967433,329213,896038,342841,436945,168749,711654,819071,236168,694852,239574,274205,270754,619816,680854,124240,727461,698746,46752,615969,452974,695014,178788,417804,905073,206298,917054,44374,80825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]