SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419421 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419421 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956794,685392,825481,78907,932278,633193,52874,1041253,644557,18611,546809,155210,600949,934009,842039,7013,303393,837227,577889,226044,512197,905247,750560,836813,367631,698597,632699,7930,541273,755982,350092,1009004,257957,693212,603882,792873,93729,360782,93257,947337,936711,690651,1047963,533552,683124,455045,1037331,677842,246776,536979,147786,400813,982660,956023,372149,31217,757921,62512,143664,493701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]