SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195206 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195206 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322991,864001,413793,614006,753809,505593,568602,603291,998245,823521,419253,449993,354673,61843,406131,1042711,790482,748917,1020358,244833,614491,1012278,221320,854668,650576,756103,552293,965399,562833,59850,879611,538165,93540,396942,951404,651104,322728,391789,383398,224047,94405,1010880,418270,816473,1048244,776945,504219,672218,222567,217848,867953,589605,699477,462760,574994,545411,1008179,730174,968953,818760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001016s ]