SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32001 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32001 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314281,39594,56696,394991,193261,954246,153943,754914,493098,30269,589385,341985,506065,749412,605032,852940,558610,601944,284862,741994,473332,548530,933743,757137,220513,732986,45882,825191,1018739,564929,71754,15879,190228,824316,722505,296265,706011,108153,340652,492297,909711,387783,47392,952101,874721,521142,15921,77147,591446,761306,996446,88179,979557,87180,1046900,413779,97632,871683,356262,953370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]