SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402132 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402132 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602649,177235,708877,985656,559569,772674,588436,323974,580533,381435,315807,125446,540865,896225,498929,107742,178804,302361,629571,61568,684633,738131,18166,509620,1042174,690012,625110,114279,281894,902851,784780,92349,737776,743839,10767,718764,788050,502984,538134,151332,582460,608851,677939,915786,315252,606657,431567,704022,910121,609139,479791,408814,162984,375583,690324,881984,613177,859723,100037,217193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]