SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 953800 LIMIT 1 [ RunTime:0.001730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 953800 [ RunTime:0.002985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181060,77014,122721,491897,320374,306418,499089,10637,396247,292417,705495,868067,1002910,578090,200656,454948,781669,902757,973189,656468,760515,201746,1018823,506721,1003852,891741,489553,707862,324245,17723,515240,875076,237055,598100,640805,447767,892182,940972,444568,116167,325270,392679,978215,484478,605370,54330,738149,300965,165953,729227,776354,499260,321614,198030,252615,864016,252386,116215,282166,743207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 953800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 953800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]