SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103058 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103058 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512943,408998,126082,325353,468339,493240,476353,907937,6842,263899,614401,192547,702271,613943,724371,77523,820873,221645,20188,962456,1036004,710007,404957,2012,161872,1021160,127653,281991,415203,919425,250207,947292,979215,384415,855110,663149,418016,1011069,131345,152894,675248,509076,38824,868199,150751,274643,99115,68497,665362,11473,389078,94825,619926,1034188,1017565,796294,856993,198932,973577,607036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001370s ]