SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281141 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281141 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365810,330982,660441,500253,786647,639500,298183,758463,948688,904189,724777,226293,195274,215306,50196,771990,117431,984833,794944,108970,271651,611291,105362,740664,881737,600947,489285,28417,590383,715903,488074,41417,843592,334427,736386,787987,151066,891360,145708,657463,613142,817398,538606,336066,912933,347422,948648,539383,159958,751435,732029,396396,254866,277924,352467,488941,964472,749665,341195,836058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]