SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522099 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522099 [ RunTime:0.003901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868301,125682,312663,629182,45668,451187,762848,918605,982151,777376,1028255,758999,845501,77993,738046,991520,824337,936068,202366,370336,840378,733080,219396,608554,870783,663441,96071,467557,44890,1038169,596137,732168,999930,276807,666595,143297,324741,897129,452157,454422,69690,448762,99006,299124,724981,847805,941476,292863,154290,133900,391314,728250,173359,115685,516046,257950,707877,737665,33639,964479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]