SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032147 LIMIT 1 [ RunTime:0.003128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032147 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432518,118140,266948,240097,421279,46939,125168,420940,597651,360271,456728,82435,687489,237447,289698,971532,183265,854533,842925,838678,556772,734761,216914,801683,89716,110566,162700,540020,665834,890946,135742,351758,250523,628596,803251,395190,903222,1023773,669247,86164,858973,499090,326230,304495,44561,277118,870072,954589,699295,408191,827088,123447,159122,595267,856412,81878,3080,1021561,892907,388749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]