SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450101 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450101 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715548,670918,392080,422406,166049,852961,356326,945460,196157,592230,554510,539482,172489,1022653,313908,20013,715190,851683,587154,352469,866095,283204,660970,506098,306366,85744,300142,734571,189458,907681,745828,55170,70521,928340,170639,410675,246389,520278,71434,853270,733275,817342,458914,96033,172865,1012577,656857,936,81777,293446,1024200,1018462,355415,767993,720136,43299,163380,870401,540032,329103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]