SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971504 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971504 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516613,204181,891874,663803,786824,307113,243361,499757,521586,303818,789416,232333,619689,318088,660416,75883,757098,113311,992510,725562,386546,324516,272716,615219,592845,31859,530403,808934,612976,688334,889787,421632,653813,718364,884375,914941,692463,442821,959102,989668,60975,745740,881722,588799,643437,822895,800367,598446,628463,307326,269252,70605,214132,856220,37566,317988,559451,481726,124184,888698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]