SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419665 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419665 [ RunTime:0.001323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766003,370058,785599,1016146,967045,709031,36985,394780,365239,723675,678625,448141,47873,154063,859105,866325,942940,944581,406687,814616,141999,963078,515200,441875,90175,969919,972171,400190,370963,112620,128584,569571,223378,755044,142677,318817,962899,177601,247965,111032,217278,259082,430910,337945,608572,629056,973894,493219,976148,651492,465117,540593,15546,616830,446239,992862,203002,1025375,377237,653198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419665 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419665 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]