SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3101 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3101 [ RunTime:0.004239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735312,989518,713141,584079,763215,718654,91306,531245,191846,256747,307596,726455,837752,128962,732886,226725,41079,845973,135824,840558,424483,317387,902420,521167,581886,895122,889167,533099,226259,488146,783758,865106,281103,626903,34907,784473,424160,963412,320116,8415,248627,881164,39097,561231,13371,802710,426966,622509,574023,653287,204097,81354,81664,865910,679512,141137,351531,216968,996182,851935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]