SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009128 LIMIT 1 [ RunTime:0.000769s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009128 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149343,140765,143542,859400,856325,192485,410167,328509,845545,621548,129163,937694,76744,351019,556311,354056,181876,570040,982548,75904,395127,441054,859185,1025105,926028,127482,504984,849541,549377,524242,371619,941501,345255,500944,340403,972343,1000171,517978,406894,938423,382987,918185,882298,1027135,387378,860698,715001,151263,1003515,145505,503905,419865,782269,1004513,956781,212906,1039087,22132,492231,613974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]