SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108881 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108881 [ RunTime:0.002744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35174,121574,501809,410705,16740,577114,282334,39763,509453,874897,683708,264790,391305,390070,110721,253711,1048751,568532,317432,231523,824360,255088,52795,969807,478767,482508,800142,833388,32473,310353,845664,396296,620312,599736,255673,86208,792322,455185,875058,690933,936353,904590,316584,496759,9201,508766,759347,466215,110814,45030,748923,314964,876343,430881,451508,892393,615401,714115,578361,421906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]