SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50133 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50133 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70623,461879,236855,747480,659018,418462,806187,925470,183572,1020289,143721,804270,269859,540458,288980,472882,385389,517113,1036604,223583,180383,543561,85658,710702,128441,639214,193840,601646,450858,487232,254401,763339,234975,765346,739451,537670,869243,397987,536801,403453,872583,609440,591710,50933,709252,218113,823350,637669,328306,428542,904079,315521,427013,321431,602654,864872,621964,603776,478079,181291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]