SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002911s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268444 LIMIT 1 [ RunTime:0.001204s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268444 [ RunTime:0.002622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848320,142880,1013648,621608,823104,102405,676546,451218,591026,482939,339,314576,1022335,511585,854823,996691,779347,921627,954497,728133,719932,361285,700538,1034015,39747,713092,513644,913936,420824,801556,281196,1046291,731846,389357,109362,459355,543760,797431,658468,99737,679399,442959,1048333,397922,306036,327354,468043,183615,1041274,148894,843666,272052,834014,749002,167290,865638,269920,232816,818942,812681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268444 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268444 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002293s ]