SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516615 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516615 [ RunTime:0.003317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586654,680964,868267,359872,810613,1035864,763393,591874,745871,662656,19602,668510,517519,797832,569169,888594,946079,991143,659317,744358,826850,899203,490505,353117,622448,632709,406050,122097,734501,66619,29922,427407,951478,632632,799565,655334,743247,568685,232902,588852,845596,994714,559244,304201,77097,372401,67367,163336,778508,493288,837074,515823,554572,55929,250025,333024,1001888,360331,528054,484924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000829s ]