SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291053 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291053 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653485,72224,582351,784604,606741,847398,406091,599141,791837,385824,866286,134575,1003935,167936,668814,471733,546118,1001130,338669,30112,993756,714069,310590,319351,841561,764947,988284,99303,563237,485492,60629,153363,117876,695605,431251,122515,597786,463523,233626,966078,418074,55577,420726,917281,719089,73809,740136,991022,12483,261447,428561,961972,249541,833162,1022885,89161,253713,790203,93061,498379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000372s ]