SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549213 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549213 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469763,797238,740646,1026028,972225,480642,861240,207,405160,34488,766390,533305,694853,381813,746986,649086,425676,276470,677020,466370,1029559,917108,200302,500574,3988,958598,275878,1028562,649212,851516,944707,851971,711275,100874,517923,454092,375007,608857,145040,94796,694656,484774,362393,870280,441724,192926,395882,3032,714716,902599,256958,699909,135260,362267,617548,751444,687763,251896,596094,94670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]