SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322959 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322959 [ RunTime:0.003398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525261,806004,743311,808894,575071,650876,817654,276640,669261,14941,521200,102234,324091,476240,686443,546301,252071,1046675,355430,684911,276060,59545,480183,105761,282862,652285,986402,997486,397081,561217,422443,944530,361050,701051,75379,194820,608110,542378,686061,327241,1032738,495952,529510,194859,862440,143895,547335,324848,152517,301145,124642,117340,510296,189571,747559,1025623,161635,55806,698723,826083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]