SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417679 LIMIT 1 [ RunTime:0.000782s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417679 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288320,232962,761896,267389,906418,934106,789839,116867,111862,761437,950870,254722,644156,201160,192035,835172,1004858,262227,791632,488652,1028712,91537,113284,88197,1003090,403206,541600,397957,760427,194226,19824,650491,1009328,89620,1023082,154494,492481,595444,931596,369125,143529,159694,44248,810230,155613,840054,84504,784001,666870,111054,212167,809361,288091,1048144,896995,498254,949282,689754,331479,944530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]