SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551027 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551027 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011210,971582,94267,752601,411058,889144,524196,83235,771507,58387,693024,820590,300511,631691,835356,193006,740264,163873,551111,702028,1012276,889693,991583,41017,1413,951167,265200,649369,203251,810457,355361,917525,88995,767962,999672,826754,972637,224670,72244,969010,72052,516457,8590,721385,235880,515827,50402,806156,762283,321640,808002,670541,988621,720752,835560,587852,860313,694084,1027,626707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]