SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401148 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401148 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281452,139765,299192,463414,426727,251004,282264,784739,38313,688560,678873,162021,805123,686788,665647,800527,814396,306272,637938,698343,210808,542542,868017,853906,879298,615089,541530,100928,349085,545484,473534,550533,749251,229400,386286,177748,118816,974981,812968,98924,690575,396154,577835,17345,611057,376358,332178,1034456,210217,71401,696788,697060,198986,253511,295092,603113,654273,741985,37782,409920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]