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` = 867983 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 867983 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524824,846297,154703,385261,692283,862366,530298,1039730,897096,652191,157743,71424,229261,870360,498653,556423,907434,68249,798580,247194,328752,715809,713537,1029236,876819,1029057,440897,914407,443312,786094,314711,849558,329560,340020,296629,1004710,980018,454275,40951,807012,253191,298981,137573,899092,778230,838726,486625,569808,1036571,151733,327285,632892,352669,107040,773711,409183,256511,645615,295465,839195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 867983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 867983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003291s ]