SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311452 LIMIT 1 [ RunTime:0.003559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311452 [ RunTime:0.005646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403175,689036,884464,782286,105482,519003,639885,282998,468150,703696,742187,350324,394064,754802,429578,969212,121662,312801,605668,232890,383798,214271,672644,282573,230151,177656,990471,712702,243770,295912,371486,358485,83217,1041816,653188,364308,98630,381126,493577,64525,289727,756184,873418,565834,143036,193848,364339,123401,101688,532174,303622,743207,48500,815208,68433,887,412365,1022563,118142,64879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]