SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430152 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430152 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882509,223721,436588,237231,142148,262096,764553,101415,508208,959243,899410,700213,645073,469568,414140,101243,727947,442053,650740,199717,647321,1037541,377150,162043,1802,272943,124820,747253,170969,904639,614082,578056,246759,555541,1041979,611337,87078,815980,382070,449608,541966,102079,412807,927219,588268,829132,749216,217038,869404,814901,631917,417460,590440,252905,485640,488171,482435,1010283,629879,329946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]